trying to retrieve variable from db not working

fahyp

Hey guys,

I'm not sure what im doing wrong. It may be something simple and im overlooking it, because I am trying to do something simple.

I am storing a value in a database. It gets stored fine. I checked in mysql command line. All the values are correct in the database.

Then I do this to access it:

$Query = "SELECT curBid FROM tickets WHERE id=". $SESSION['tid'];
$dbResult = mysql_query($Query, $dbLink);
$row = mysql_fetch_array($dbResult, MYSQL_BOTH);
$curBid = $row["curBid"];
$maxBid = $row["maxBid"];
$bidAmt = $SESSION['bidAmt'];

i have the rest of the database access code above in an include, that's not the point. curBid gets accessed from db fine. maxBid is the problem. I am typing everything correctly. I just dont get it. maxBid is getting no value. I am drawing a big blank on this one. Anyone have any ideas?

Weedpacket

You're drawing a blank on maxBid because you're not drawing it from the database! Check your SELECT!

fahyp

oh jesus
god im an idiot!!!
thats what happens in late night programming!

Weedpacket

Hey, I've got a small space marked out on my desk, labelled "strike forehead here".

fahyp

hahah
ill have to make one of those!

kappaluppa

I have no shame. (No coding skills either for that matter....) I will reveal my lack of knowledge for all the world to see....

I am having the same problem, but unlike fahyp I'M NOT GETTING IT!

It pains me to ask, but what is missing? Perhaps I am missing the same thing and if I fix it, mine will work too!

Thanks!
K

PS - Please keep the ridicule down to a minimum. ;o)