Problem with mysql versions. help
| From: | NeXaS | Date: | Sun, 06 Apr 2003 03:25:54 +0000 |
| Subject: | Problem with mysql versions. help | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-142563@lists.php.net to get a copy of this message | ||
Hello, I wrote the code for deleting the oldest string in the mysql if
it reaches over 15 strings, but it works only under 4.x.x series of MySQL and i have
3.x.x. What should I change in the code that it would work under 3.x.x
version of MySQL? Here`s the code:
$quer = "SELECT COUNT(id) FROM logai";
$rez = mysql_query($quer);
$sk = mysql_result($rez,0);
if ( $sk > 15 ) {
$wad = $sk - 15;
$queryz = "DELETE FROM logai WHERE id <> 'a nu nakuj' ORDER BY id LIMIT
$wad";
mysql_query($queryz);
}*/
Thank You. Sorry for my bad english :-(