WHat is wrong with this code

[stardock]

Try to display 5 var.

// this part happens if we don't press submit

if (!$id) {

// print the list if there is not editing
 echo "<table border=1>\n";

echo "<tr><td>Company Name</td><td>First Name</td><td>Last Name</td><td>Sales</td><td>Date</td>\n";

$result = mysql_query("SELECT * FROM contacts",$db);

while ($myrow = mysql_fetch_array($result)) {

  printf("<tr><td><a href=\"%s?id=%s\">%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td>", $PHP_SELF, $myrow["id"], $myrow["company"], $myrow["first"], $myrow["last"], $sales["$sales"], $date["$date"]);

---

This is all it displays
Company Name First Name Last Name Sales Date
cxzXZXC ZXCzXC ZXCZXCZX

sdfsdaf sadfsdaf sadfsdaf

jkjlkjlkj jlk;jlkjl;k jl;kjlk;j

[jamie_webstart]

You've typed '$sales["$sales"]' and '$date["$date"]' when it looks like you meant '$myrow['date']' and '$myrow['sales']'.

[stardock]

That part dose not make a difference in the last to rows sale date or vice versa it display nothing nota.