> $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
In MySQL you use MAX() to retrieve the maximum value from a column.
`SELECT MAX(id) as id FROM divxtemp`
-Kevin
- Original Message -
From: "Mr. BuNgL3" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 31, 2003 2:31 PM
Subject: [PHP] doing a
$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(
3 matches
Mail list logo