If you have a column that gives you the newness of each row--I'm
assuming a date here:
delete from my_table order by date_inserted desc limit 100, -1
This should work... I recommend a db backup first :-)
Marco
php|architect - The magazine for PHP Professionals
The monthly
I was thinking something along those lines, but phpmyadmin gives an
error. The table currently has way too many rows (32362), could this
have to do with it?
Warning: Unable to jump to row 0 on MySQL result index 4 in
/home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php on line 223
How do I create a table within my PHP? Heres what I currently have, but I
keep getting parse error on the "create" line...
Because create is not a valid PHP command. You have to assign the create
statement to a string, _then_ pass the string to mysql_query:
$sql = "create table $propTable
In article 00c701c0c2af$be478f40$[EMAIL PROTECTED],
[EMAIL PROTECTED] ("Darryl Friesen") wrote:
How do I create a table within my PHP? Heres what I currently have, but I
keep getting parse error on the "create" line...
Because create is not a valid PHP command. You have to assign the