query is empty

[beamo]

I keep getting this error message:
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in W:\home\admin\WWW\dir\finalproject\sendreceipt.php on line 7
Query was empty

Can anyone tell me what is wrong? Thanks for the help.


function getTickets($username){
require("opendbo.php");
$query = mysql_query("SELECT * FROM customerinfo4 WHERE customer = ($username)");
$result=mysql_query($query);
$num=mysql_numrows($result)or die(mysql_error());
mysql_close();
for($i=0; $i<5; $i++){
$fname = mysql_result($result, $i, 'fname');
$lname = mysql_result($result, $i, 'lname');
$card = mysql_result($result, $i, 'card');
$cardnum = mysql_result($result, $i, 'cardnum');
$age = mysql_result($result, $i, 'age');
$trip = mysql_result($result, $i, 'trip');
$pop = mysql_result($result, $i, 'pop');

echo $fname;
echo "<br>";
echo $lname;
echo "<br>";
echo $card;
echo "<br>";
echo $cardnum;
echo "<br>";
echo $age;
echo "<br>";
echo $trip;
echo "<br>";
echo $pop;
}
}

[beamo]

I'm so stupid.

$query = mysql_query("SELECT * FROM customerinfo4 WHERE customer = ($username)");

should be:

$query = "SELECT * FROM customerinfo4 WHERE customer = ($username)";

Sorry to clog up your help board.