SID position

dpatterson256's picture

Do you guys know if the SID has to be in a particular spot in the tracking URL? I've noticed that if it naturally puts the SID first, before the real URL in the code. Does it still track if you do the SID last?

The reason I ask is that I'm running a site where I pull the affiliate links from a MySQL database and if i put the in my database it prints it literally rather than as php code. So the only way I know around this would be to put the SID at the end. Or do you have any other ideas?

Thanks everyone!

Dan

Green Giant's picture

Hi Dan,

Can you post an example of the code you are using to pull the affiliate links out of the mysql database and the code you are using on you page? I've been working with this a lot recently and we might be able to help each other.

Mike

dpatterson256's picture

Hey Mike,

I think I figured out the php problem. Once I thought about it I realized that I was using an 'echo' in the wrong place, trying to do a php label within php. So that part I have down I think, as long as it doesn't matter with CJ where i put the SID.

Here's an example of what I'm doing. This is just a snippet, but hopefully it gets the idea across:

$affLink is defined as the individual affiliate link from the database

echo "anchor text";

What I was doing before was trying to include the whole in the code above, but naturally that won't work. I'm pretty new to php, so that's my excuse :wink:

So does anyone know if it matters where in the affiliate URL i put the SID?

rayd8's picture

Dan,

Try taking a look at this post:
http://www.quityourdayjob.com/members/forums/viewtopic.php?t=1330

My post is about the fourth one down. There is a lot of good information in the PHP section here. And a lot of the questions asked were from me because I'm a hack when it comes to PHP. So if I can learn you can too.

Hope this helps,

-Michael

dpatterson256's picture

Thanks Michael,

I hadn't thought of using a switch statement. I can definitely take some ideas from this.

Dan

dpatterson256's picture

I guess part of my initial question still remains. I've put a ticket in to CJ to find out, but they haven't responded yet.

Jeremy or anyone, do you know if it matters where the actual sid= shows up in the URL string? I found that with ShareASale they don't care where you put their afftrack= code, but I haven't heard for sure about CJ.

Thanks in advance to anyone that knows the answer!

SKaze's picture

Hi,

the order of GET variables (aka "¶m=something") does not matter in general. I do usually pass the sid in CJ links as the first parameter, but it shouldn't make any difference as long as the format is ok (GET variables start after ?param1=x and then continue with ...¶mY=y...).

Regards,
Sergey

dpatterson256's picture

Sounds good. I'll probably just have to try it and see what happens. Thanks for the tips everyone!

Dan

smile66603's picture

As far as I know, the order doesn't matter, but like SKaze said, make sure you use the correct format.

The first value in a query string is preceded by a ? and all values after that are preceded by a &. So it would look like this.

domain.com?SID=value&search_engine=Yahoo

or

domain.com?search_engine=Yahoo&SID=value

Hope this helps.

James

ddeems's picture

I've moved the SID around without any problem. I use xtreme conversions, and almost always forget to add my SID to the actual link, so I end up adding it in the xtreme conversion link builder. The big thing is to make sure that you have the right symbol. Accidentally use two ?'s or no ? and two &'s and your URL will freak out.

The one problem you COULD get into is a truncated URL, depending on your specific usage situation (for example, search engine spiders have been known in the past to drop things after the ? ) But I think that's more a tip for SEO than actual usage problems.

Syndicate content