Re: [PHP-DB] very simple answer

2002-01-17 Thread Barry Rumsey
<[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

Re: [PHP-DB] very simple answer

2002-01-17 Thread Miles Thompson
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 fiel

[PHP-DB] very simple answer

2002-01-17 Thread Barry Rumsey
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 "); It says