Shadowing Posted December 14, 2011 Share Posted December 14, 2011 Im trying to choose what I want the id to be set to when I create a row on another table using this code below it tells me "unknown column "id" in 'field list' making me think it has to asign a random id first <?php $d1 = "SELECT id FROM game WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'"; $b1 = mysql_query($d1) or die(mysql_error()); $c1 = mysql_fetch_array($b1); if (empty($c1['id'])) { $a1 = "INSERT INTO game SET id = '".$_SESSION['user_id']."'"; mysql_query($a1) or die(mysql_error()); ?> Link to comment https://forums.phpfreaks.com/topic/253174-choosing-id-when-inserting-a-row/ Share on other sites More sharing options...
Shadowing Posted December 14, 2011 Author Share Posted December 14, 2011 I fixed it i just had to add a id column first Link to comment https://forums.phpfreaks.com/topic/253174-choosing-id-when-inserting-a-row/#findComment-1297939 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.