Jump to content

choosing id when inserting a row


Shadowing

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.