troubled query

[tet3828]

My query is not returning any results however I know the my table tSession contains the value I am querying. I think I've got this query all wrong or something. please help

 

$lName = $_POST['lName'];

$sql = "SELECT * FROM tSession WHERE `lName` =`$lName`";
$result = mysql_query($qry) or die(mysql_error());
echo "the query $fName";
while($row = mysql_fetch_array($result)) {
     echo "the query $fName yeielded no results. ".$row['note']."";
}

[Nhoj]

Change

$sql = "SELECT * FROM tSession WHERE `lName` =`$lName`";

 

to

$sql = "SELECT * FROM tSession WHERE `lName` = '{$lName}'";

 

You can't use ` to surround a value, only a column or table name

[tet3828]

Strange. I don't know what the deal is. it is still coming back with an empty query.  ???

[Nhoj]

Are you positive there are row's in your table that have `lName` equal to $lName?

[trq]

Your not actually executing your query but some undefined $qry variable. Try...

 

<?php

$lName = $_POST['lName'];
$sql = "SELECT * FROM tSession WHERE `lName` = '$lName'";

if ($result = mysql_query($sql)) {
  if (mysql_num_rows($result)) {
    while($row = mysql_fetch_array($result)) {
      echo "the query $fName yeielded no results. " . $row['note'];
    }
  } else {
    echo "No results found";
  }
} else {
  echo "Query failed<br />$sql<br />" . mysql_error();
}

?>

[Nhoj]

Haha! I feel stupid....