Re: [PHP-DB] Really dumb question... deleting everything but newest100 rows?
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 worldwide magazine dedicated to PHP programmers Check us out on the web at http://www.phparch.com On Sat, 2002-11-23 at 17:38, Leif K-Brooks wrote: I know this is a dumb question, but how would I delete everything but the first 100 results returned from a query? I know I'd use limit, but my mind's going blank as to the exact syntax. -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Really dumb question... deleting everything but newest100 rows?
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 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/libraries/ob.lib.php on line 53 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 23 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 24 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 25 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 26 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 27 Warning: Cannot add header information - headers already sent by (output started at /home/virtual/site1/fst/var/www/html/PhpMyAdmin/sql.php:223) in /home/virtual/site1/fst/var/www/html/PhpMyAdmin/header.inc.php on line 29 Database mydb running on localhost Error SQL-query : delete from `mytable` order by col desc limit 100, -1 MySQL said: You have an error in your SQL syntax near 'order by col desc limit 100, -1' at line 1 Back http://www.ecritters.biz/PhpMyAdmin/db_details.php?lang=enserver=1db=chizzy_co_ukshow_query=ysql_query=delete+from+%60topics%60+order+by+id+desc+limit+100%2C+-1 Marco Tabini wrote: 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 worldwide magazine dedicated to PHP programmers Check us out on the web at http://www.phparch.com On Sat, 2002-11-23 at 17:38, Leif K-Brooks wrote: I know this is a dumb question, but how would I delete everything but the first 100 results returned from a query? I know I'd use limit, but my mind's going blank as to the exact syntax. -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law.
Re: [PHP-DB] Really Dumb Question...
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 ( ID int not null auto_increment primary key, TourName tinytext, TourTitle tinytext, ViewTitle tinytext, TourNum tinyint not null, Applet tinyint not null, Desc text, TourPath text, SmFile text, LgFile text ); "; $result = mysql_query($sql); - Darryl -- Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED] Education Research Technology Services, http://gollum.usask.ca/ Department of Computing Services, University of Saskatchewan -- "Go not to the Elves for counsel, for they will say both no and yes" -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Really Dumb Question...
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 create statement to a string, _then_ pass the string to mysql_query: $sql = "create table $propTable ( ID int not null auto_increment primary key, TourName tinytext, TourTitle tinytext, ViewTitle tinytext, TourNum tinyint not null, Applet tinyint not null, Desc text, TourPath text, SmFile text, LgFile text ); "; $result = mysql_query($sql); And take out the semicolon immediately after the closing parenthesis in "LgFile text )". :-) -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]