PHP MYSQL data fetching problem

[kosaks]

Hello again

i would like to ask why i get null values from mysql database. This is my code

$SqlQuery->OpenConnection("localhost","sample","test");
$SqlQuery->SelectDatabase("sampleDbase");
$sql = "SELECT company_id FROM `companies` WHERE company_name = \'Jet Stream\'";
echo($SqlQuery->GetResults($sql));

function GetResults($sql)
{
 $val;
 $result = mysql_query($sql);
 while($row = mysql_fetch_object($result))
 {
  $val = $row->password;
 }
 return $val;
}

I dont know why my php code return null values. but when i try my query on mysql database i shows results. Can anyone tell me why i get null values?

thanks

[Rekha Kumaran]

Make sure whether u have values 'Jet Stream' in company_name field!!!

Try this query
SELECT company_id FROM `companies` WHERE company_name = \'%Jet Stream\%'"

[nathj]

Alternatively you could try:

$sql = "SELECT company_id FROM `companies` WHERE company_name = 'Jet Stream'"

theother option is to set up a variable

$companyname= "Jet Stream";
$sql = "SELECT company_id FROM `companies` WHERE company_name = '$companyname'";

Using a variable like this makes the code much more reusable.

Cheers
nathj