Supplemental data table

[zzz]

Question.

I have a table with a lot of records. However, it does not contain all the records I need and I must use records from a supplemental table. How can I make my script check and display records from the first table and if the record is not found, use supplemental table?

[thorpe]

use an if statement. pseudo code.

if (mysql_num_results($result) < 1) {

  // run a query against the second table

}