Pass variable from PHP to mysql

[gw32]

You guys are great, thanks again for the help last week.

 

Now I almost got this working but a small hiccup.

 

here is my code:

<?php 
include("config.php");
$my_t=getdate(date("U"));
$my_t1=$my_t[weekday];
$result = mysql_query("SELECT * FROM tourney where day_of_week = '$my_t1'") or die(mysql_error()); 
if ($result == '') echo "<br>Empty Set\n";
print_r ($my_t1);

This prints correctly

 

while ($result = mysql_fetch_array($result,MYSQL_ASSOC)) {

This is my error. "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web017/b172/ipg.dswdesignsnet/pp4c/charity1.php on line 8"

 

print "<b>Starting Time: <br></b>".$row{'start_time'}."<br><b>Tournament: </b><br>".$row{'tourney'}."<br><b>Buy-in: <br>".$row{'buy_in'}."<br><b>Starting Chips: <br>".$row{'start_chips'}."</font><p>";

This prints headers correctly, but no variables.

 

}
mysql_close($dbh);
?>

 

What did I forget to do or what did I do wrong.

 

I'm still learning mysql and php.

[spiderwell]

change this

while ($result = mysql_fetch_array($result,MYSQL_ASSOC)) {

to this

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

[gw32]

Thanks. It worked.

 

I just did what was in my book on how to pass variables.

 

Gotta get a different book!

 

Thanks again

[spiderwell]

I'd like to hope your book doesn't have errors like that in it! i'd ask for my money back if it did!