Select on error

[timstring]

I have query nested inside two queries. (I know, horribly inefficient)

$Quest = "SELECT * FROM `$System` WHERE TechNum = '$TechNum' && WorkDate = '$IncDate'"; $SelectSystemResult = mysql_query($Quest, $cxn) 
or ??????

If there is no table corresponding to $System, I want the script to jump back to the first Select statement and move onto the next row. I sure don't want to use a goto statement.

[NogDog]

I might be tempted to run one query to just get the possible table names (see SHOW TABLES), then use a simple if/else within your loop, checking to see if the supplied table name is valid, and processing the inner query if it is, else simply [FONT=Courier New]continue;[/FONT]-ing if not.