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
