doing auto number myself to a primary key...
| From: | Mr. BuNgL3 | Date: | Fri, 31 Jan 2003 21:31:00 +0000 |
| Subject: | doing auto number myself to a primary key... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-133825@lists.php.net to get a copy of this message | ||
$sql="SELECT TOP(id) FROM divxtemp";
$res=mysql_db_query("DB",$sql) or die (mysql_error());
$reg=mysql_fetch_array($res);
$id=$reg["id"]+1;
$sql="INSERT INTO divxtemp (titulo,cds,id) VALUES
('$titulotxt','$cdstxt','$id')";
mysql_db_query("DB",$sql) or die (mysql_error());
the id is always 1 so he can't save duplicate keys...
what i'm doing wrong? : \
thanks...