What am I missing???

[jalrock]

$sql = "SELECT * FROM deals WHERE lastname=$lastname"; 
    $result = mysql_query($sql); 
    $myrow = mysql_fetch_array($result); 
    $lastname = $myrow["lastname"];
    $id = $myrow["id"]; 
    $saleprice = $myrow["saleprice"]; 
    $rebate = $myrow["rebate"]; 
    $tradevalue = $myrow["tradevalue"]; 
    $tradepayoff = $myrow["tradepayoff"]; 
    $cashdown = $myrow["cashdown"]; 
    $msrp = $myrow["msrp"]; 
    $residual = $myrow["residual"]; 
    $firstname = $myrow["firstname"]; 

Here is the table

 lastname  varchar(50)   No       

Here is the error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/combined/public_html/bankston/recall2.php on line 11

Thanks in advance for the help.

[LordShryku]

You need quotes around the lastname.
ie:

$sql = "SELECT * FROM deals WHERE lastname='".$lastname."'"; 

mysql_error would have told you this....

$result = mysql_query($sql) or die(mysql_error());