fetch array problem - i think

[stew]

hey there guys...

$sql = "SELECT * ";
$sql .= "FROM `events` ";
$sql .= "WHERE (date_start >= '$thestart') AND (date_end <= '$theend') AND (show = 'yes') ORDER BY date_start DESC LIMIT 0, 30"; 
$nums = mysql_query("$sql");

the mysql_query doesn't fail but the mysql_fetch_array($nums) does. i know all the fields are correctly spelt, so thats not the problem. When i run the above query from phpmyadmin it come up with an error saying the table doesn't exist on the current database.

can anyone help with this?

cheers

[laserlight]

Test:

$query = "SELECT * FROM `events`
	WHERE (date_start >= '$thestart')
		AND (date_end <= '$theend')
		AND (`show` = 'yes')
	ORDER BY date_start DESC LIMIT 0, 30"; 
$result = mysql_query($sql)
	OR die(mysql_error());
$num = mysql_num_rows($result);
echo "Number of rows in result set: " . mysql_num_rows($result) . '<br />';
while ($row = mysql_fetch_array($result)) {
	//etc
}