That's probably because you can't do it in a single SQL statement, but
have to use three separate ones and build the logic to check which one
is the most recent in PHP. Try outputting the query and posting it to
the list, or try inserting a line like this:
echo mysql_error();
after you execute your query--that will print out what the MySQL server
thinks is wrong with your current query.
Hope this helps!
Cheers,
Marco
--
------------
php|architect - The magazine for PHP Professionals
The first monthly worldwide magazine dedicated to PHP programmer
Come visit us at http://www.phparch.com!
--- Begin Message ---
I know that you can select data from multiple tables, but when I do that I
get an error. The error is this:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in /usr/local/plesk/apache/vhosts/melchior.us/httpdocs/live/all.php
on line 17
----- Original Message -----
From: "Marco Tabini" <[EMAIL PROTECTED]>
To: "Stephen" <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 4:44 PM
Subject: Re: [PHP] Getting Newest
> I think you would need to make three queries, since Mysql doesn't
> support subqueries... or am I wrong?
>
>
> Marco
>
> --
> ------------
> php|architect - The magazine for PHP Professionals
> The first monthly worldwide magazine dedicated to PHP programmer
>
> Come visit us at http://www.phparch.com!
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
