Anyone know WHY this wouldn't work?

Anon

Here's what I'm trying to do... on another page, I have a product listing with a query that passes only ONE variable, ProductCode to the details.php page (snippet below)

When executing the link, the following code displays only this:

------------------result------------------
You chose Item Number: 30207
The price is only:
------------------result------------------

Obviously there is no price, so before going on and coding the rest, I want to make sure I can use the code and it works properly. The connection to the database is working fine from what I can tell, but WHY can't I get it to print out any OTHER information than just what was sent in the passing of the variable, ProductCode? Ideas? Resolutions?

------------------snippet------------------
$x = mysql_query("select * from Products where ProductCode = '$ProductCode'");
$y = mysql_fetch_row($x);
$z = $y["DiscountPrice"];
echo "You chose Item Number: $ProductCode";
echo "The price is only: $DiscountPrice";
------------------snippet------------------

Thanks to anyone and everyone....am I overlooking something?
Matt

brandonschnell

echo "The price is only: $z";

Anon

Still the same thing...even after making the change to:

------------------snippet------------------
echo "The price is only: $z";
------------------snippet------------------

Am I "not" connected to my database then?

Thanks

Anon

Still the same thing...even after making the change to:

------------------snippet------------------
echo "The price is only: $z";
------------------snippet------------------

Am I "not" connected to my database then?

Thanks

mithril

The short description of mysql_fetch_row() from the manual:

"mysql_fetch_row -- Get a result row as an enumerated array"

Key word here is "enumerated". You're trying to access the results using associative keys, but the keys are numeric. Use mysql_fetch_array() if you want an associative array index returned. For more info:

http://www.php.net/manual/en/function.mysql-fetch-array.php

-geoff

Anon

Jeff...

Thanks, I didn't know what else to do... it seems to be the fix!

Thanks again for your help!

Matt