[PHP-DB] DELETE mySQL query

2009-08-15 Thread Ron Piggott
Is there a way to do the math in a DELETE statement (All 1 step; See my "sample" below pseudo code below). I am trying to delete the record if it is more than 3 hours old and the value of "approved" is still 0. DELETE FROM `guest_book` WHERE `guest_book`.`date_submitted` + 3 hours =< '$current

[PHP-DB] DELETE mySQL query

2009-08-15 Thread Ron Piggott
Is there a way to do the math in a DELETE statement (All 1 step; See my "sample" below pseudo code below). I am trying to delete the record if it is more than 3 hours old and the value of "approved" is still 0. DELETE FROM `guest_book` WHERE `guest_book`.`date_submitted` + 3 hours =< '$current

Re: [PHP-DB] Making two columns

2009-08-15 Thread Phpster
On Aug 15, 2009, at 2:26 PM, "Ron Piggott" wrote: I am needing help changing this code so the result of the mySQL query will display in two columns with the CSS tags around it. The number of records being displayed is based on the mySQL query and will increase as more poetry is

[PHP-DB] Making two columns

2009-08-15 Thread Ron Piggott
I am needing help changing this code so the result of the mySQL query will display in two columns with the CSS tags around it. The number of records being displayed is based on the mySQL query and will increase as more poetry is added to the site. echo "\r\n"; echo "\r\n"; $i=0; while ( $i