Re: Now not selecting enough
| From: | Alex Francis | Date: | Wed, 18 Dec 2002 17:11:06 +0000 |
| Subject: | Re: Now not selecting enough | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24264@lists.php.net to get a copy of this message | ||
That was quick - Works alright now thank you
"Jason Selph" <jason.selph@hp.com> wrote in message
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: [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 ("<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