Show mySQL query

[petenaylor]

Hi all

 

I have created a mySQL query and assigned it to a string:

 

$getjobs = mysql_query (" SELECT * FROM jobs WHERE from_date >= '".substr($newdate, 0, 10)."' $keyword_search $sector_search $salary_search $location_search $type_search ORDER BY job_refno DESC ") or die (mysql_error());

 

Is there any way to output the actual query to the browser to check it?

[Jessica]

You did not assign the actual query to a string.

$sql = "SQL here";

$result = mysql_query($sql)

or die("$sql: ".mysql_error());

[Maq]

$sql = "SELECT * FROM jobs WHERE from_date >= '".substr($newdate, 0, 10)."' $keyword_search $sector_search $salary_search $location_search $type_search ORDER BY job_refno DESC"
echo $sql;
$getjobs = mysql_query ($sql) or die (mysql_error());

[petenaylor]

Great, thanks for your help!