[thelist] php/mysql - two consecutive select statements

noah noah at tookish.net
Fri Nov 16 02:41:50 CST 2001


I'm having a problem with select statements (PHP querying MySQL).

There are 2 statements in a row:

$job_query = mysql_query("SELECT client_id FROM table1 WHERE id = $job_id");
list($client_id) = mysql_fetch_row($job_query);

$client_query = mysql_query("SELECT table2.client_name, table3.givenname, 
table3.surname, table3.email FROM table2, table3 WHERE table2.consultant = 
table3.id AND table2.id = $client_id");
list($client_name, $client_consultant_givenname, 
$client_consultant_surname, $client_consultant_email) = 
mysql_fetch_row($client_query);

For some reason, if the first select is there, the second doesn't work - as 
soon as I take the first out (e.g., replace it with just "$client_id = 
2;"), the second select works fine.

(In case this is relevant, the two selects above are the second and third 
of three in a row - the first is:

$candidate_query = mysql_query("SELECT table4.givenname, table4.surname, 
table3.givenname, table3.surname, table3.email FROM table4, table3 WHERE 
table4.consultant = table3.id AND table4.id = $candidate_id");

list($candidate_givenname, $candidate_surname, 
$candidate_consultant_givenname, $candidate_consultant_surname, 
$candidate_consultant_email) = mysql_fetch_row($candidate_query);
)

Any ideas why this might be? Is there a better way to write the statements 
that might work around it?

Thanks,
Noah





More information about the thelist mailing list