mysql query

[jobs1109]

Hi,

 

I am getting an error message from my mysql query

 

 

I am using two variables passed from another page that I use in the query.

$Keyword_Search

$Jobcategory

 

when I echo out the variables on this page it show the values entered but how do I used it in my query. Here is the code.

 

 

<?php
include'../somedatabasefilehere';

$Keyword_Search =  $_SESSION['Keyword_Search'];
$Jobcategory =  $_SESSION['Jobcategory'];
echo $Keyword_Search;
echo $Jobcategory;

// getting data from table "Table"


$result = mysql_query(SELECT * FROM Tablename WHERE Keyword_search = "$Keyword_Search" and Jobcategory="$Jobcategory"');

while($row = mysql_fetch_array($result))
   {
   echo $row['Keyword_Search'] . " " . $row['Jobcategory'];
   echo "<br />";
   }


?> 

 

 

Here is the error message I am getting

 

 

Parse error: syntax error, unexpected T_STRING in /home/content/h/i/l/hilo101/html/Hilo-Jobs/Job-Search-Form/Getting-Data-From-Database/Getting-Data-Database.php on line 41

 

Please help.

[AyKay47]

you havn't wrapped your query in quotes

 

$result = mysql_query("SELECT * FROM Tablename WHERE Keyword_search = '$Keyword_Search' and Jobcategory='$Jobcategory'");

[jobs1109]

Still getting error message Here is the full code

 

<?php
session_start();
?>

<?php
$_SESSION['Keyword_Search']    = $_POST['Keyword_Search']; 
$_SESSION['Jobcategory']      = $_POST['Jobcategory'];
$Keyword_Search =  $_SESSION['Keyword_Search'];
$Jobcategory =  $_SESSION['Jobcategory'];
echo $Keyword_Search;
echo $Jobcategory;

?>


<?php
include'Some-database-connect-file';


// getting data from table "Sometable"


$result = mysql_query("SELECT * FROM sometable WHERE Keyword_search = '$Keyword_Search' and Jobcategory='$Jobcategory'");

while($row = mysql_fetch_array($result))
   {
   echo $row['Keyword_Search'] . " " . $row['Jobcategory'];
   echo "<br />";
   }


?> 

 

 

Here is the error message I am getting.

 

 

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/h/i/l/hilo101/html/Hilo-Jobs/Job-Search-Form/Getting-Data-From-Database/Getting-Data-Database.php on line 33

 

[AyKay47]

the error is indicating that your query is not correct and is returning false..

 

1. make sure that you are connected to your db server..

2. use mysql_error to debug your query

3. echo your query to make sure that it is what you want it to be

[fenway]

Definitely do #3.

[silkfire]

Check if your $_POST variables contains apostrophes. Those strings must be escaped prior to be used in a query by using mysql_real_escape_string()

[AyKay47]

Check if your $_POST variables contains apostrophes. Those strings must be escaped prior to be used in a query by using mysql_real_escape_string()

even if they aren't, that wouldn't cause errors...

[silkfire]

Yes it would, Mysql would complain that the query was unexpectedly cut off in the middle.

You should look for bugs in all possible causes.