SID position

Submitted by dpatterson256 on Mon, 02/25/2008 - 23:47.
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
Thanks everyone!
Dan

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
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?
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
Thanks Michael,
I hadn't thought of using a switch statement. I can definitely take some ideas from this.
Dan
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!
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
Sounds good. I'll probably just have to try it and see what happens. Thanks for the tips everyone!
Dan
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
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.