i'm passing an AUTO_INC. from one table to the form on the next page using "/page.htm?subscriberID=".$subscriberID and it's passing the variable to the next url correctly, but writing "0" in my table - can someone help, please?
thanks,
glenn
mysql_insert_id() help
Moderator: General Moderators
mysql_query($query);
$SubscriberID=mysql_insert_id();
header("Refresh: 0;url=http://www.safe-teen.net/autoreg.php?Su ... bscriberID);
i do this and it once was passing the AUTO_INCREMENTED int friom the first table to the url so i could use it in a second form, but it suddenly started passing "0" always. can't figure out why...
i think it's someting to do with the indices and the primary keys in the tables because i was fooling around with them to make it work before...
thanks
$SubscriberID=mysql_insert_id();
header("Refresh: 0;url=http://www.safe-teen.net/autoreg.php?Su ... bscriberID);
i do this and it once was passing the AUTO_INCREMENTED int friom the first table to the url so i could use it in a second form, but it suddenly started passing "0" always. can't figure out why...
i think it's someting to do with the indices and the primary keys in the tables because i was fooling around with them to make it work before...
thanks