That was quick - Works alright now thank you "Jason Selph" <jason.selph@hp.com> wrote in message B6A314FCF5A2344A8312397B725D61A6321F58@xrich01.rsn.hp.com">news:B6A314FCF5A2344A8312397B725D61A6321F58@xrich01.rsn.hp.com... > Try putting this: > echo ("<h5><A 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:afrancis@camerondesign.co.uk] > Sent: Wednesday, December 18, 2002 11:00 AM > To: php-db@lists.php.net > Subject: 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 ("<h5><A 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
