Now not selecting enough
| From: | Alex Francis | Date: | Wed, 18 Dec 2002 16:59:56 +0000 |
| Subject: | Now not selecting enough | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24259@lists.php.net to get a copy of this message | ||
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>");