|
|
I am trying to get two tables joined so I can take data from both tables and
view them, search them from a form.
I have this as my query:
mysql_select_db($database_db, $db);
$query_job_results = "SELECT * FROM jobs, restaurants WHERE job_status = 'ON'
AND rest_city = '$_REQUEST[city]' AND job_category = '$_REQUEST[position]' AND
job_wages = '$_REQUEST[wage]' AND job_accom = '$_REQUEST[accom]' AND job_travel
= '$_REQUEST[travel]' AND job_drvlicense = '$_REQUEST[drvlic]' AND
rest_licenced = '$_REQUEST[bar]'";
$job_results = mysql_query($query_job_results, $db) or die(mysql_error());
$row_job_results = mysql_fetch_assoc($job_results);
$totalRows_job_results = mysql_num_rows($job_results);
Displays nothing apart from the blank page, have I missed something out?
I havent done table joins for over 4 years now :'(
|
|