I ended up rewriting it again and somewhere I must have done something wrong
as it now works. Thanks guys. Maybe I should think about more sleep.
----- Original Message -----
From: "Miles Thompson" <[EMAIL PROTECTED]>
To: "Barry Rumsey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 18, 2002 9:48 AM
Subject: Re: [PHP-DB] very simple answer
> Barry,
>
> Add >> or die( mysql_errno() ." : ". mysql_error() ) <<
>
> It could be you don't have any data, also there's no space between
/artist'
> and ORDER BY.
>
> Also trim off everything after 'artist' and see what you get. If it still
> doesn't work there's something wrong with the field names. Then start
> adding stuff back. BTW you don't need ORDER BY if you are LIMITing to 1.
<g>
>
> Miles
>
> At 08:52 AM 1/18/2002 +1300, Barry Rumsey wrote:
> >I can't figure out where I have gone wrong. Maybe not enough sleep,
anyway
> >this is the simple query:
> >$query = "SELECT * FROM xp_topics WHERE artist='artist'ORDER BY topicid
> >DESC LIMIT 0,1"; $result = mysql_db_query($query) or die("Select
Failed!");
> >echo("Latest Artists : $topictext <br>");
> >
> >It says query failed. I know I've forgoten something but don't know what
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
