RE: [PHP-DB] Now not selecting enough
Try putting this: echo (h5A HREF=\minutes_detail.php?id=$id\$meetingdate/A/h5); in your while loop. Right now it is just popping out the last record. Cheers Jason -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:00 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Now not selecting enough I am using the following script which I have used with minor variations, several times before without any trouble. I have 3 items in my database but the script only returns 1. I can change which one by leaving off the order by filter, but can't get all three. Where am I going wrong. (PHP and MySQL). $SQL = 'SELECT id, DATE_FORMAT(meetingdate, %D %M %Y)as mtgdate FROM boardprevious order by meetingdate desc '; // execute SQL statement $ret = mysql_db_query($dbname,$SQL,$link); if (!$ret) { echo( mysql_error()); } else { // retrieve values while ($row = mysql_fetch_array($ret)) { $meetingdate = $row[mtgdate]; $id = $row[id]; } } echo (h5A HREF=\minutes_detail.php?id=$id\$meetingdate/A/h5); -- 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] Now not selecting enough
That was quick - Works alright now thank you Jason Selph [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Try putting this: echo (h5A HREF=\minutes_detail.php?id=$id\$meetingdate/A/h5); in your while loop. Right now it is just popping out the last record. Cheers Jason -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:00 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Now not selecting enough I am using the following script which I have used with minor variations, several times before without any trouble. I have 3 items in my database but the script only returns 1. I can change which one by leaving off the order by filter, but can't get all three. Where am I going wrong. (PHP and MySQL). $SQL = 'SELECT id, DATE_FORMAT(meetingdate, %D %M %Y)as mtgdate FROM boardprevious order by meetingdate desc '; // execute SQL statement $ret = mysql_db_query($dbname,$SQL,$link); if (!$ret) { echo( mysql_error()); } else { // retrieve values while ($row = mysql_fetch_array($ret)) { $meetingdate = $row[mtgdate]; $id = $row[id]; } } echo (h5A HREF=\minutes_detail.php?id=$id\$meetingdate/A/h5); -- 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