php / mysql list function not returning anything! help!

Question

Is there any reason why this would not return anything?

list($price) = mysql_query(sprintf("select price from product where productid_FK = ".$productid"));

I have used the list function on another page and is working fine, not sure why it is not returning anything on this page.

I have outputted the sql code and ran it in mysql and it worked fine. Please note that this query is in a while loop.

Thanks

Not exactly sure how efficient it is, but is a quick way of getting the result of the query to the var $price. — Dino
– Dino, Commented Jul 12, 2011 at 1:40
you should provide more complete code... this one line would not only fail to work, but also is very wrong application of list() function. — Gelmir
– Gelmir, Commented Jul 12, 2011 at 2:35

Dr.Molle · Accepted Answer · 2011-07-12 01:24:40Z

1

mysql_query() returns a ressource, not an array.
You need to use mysql_fetch_array() or similar to get something that list() can work with.

edited Jul 12, 2011 at 1:24

answered Jul 12, 2011 at 1:18

Dr.Molle

117k16 gold badges200 silver badges206 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dino Over a year ago

My apologies I have actually been using mysql_fetch_row around the code which I omitted when copying and pasting. Also tried mysql_fetch_array with no success.

Dino Over a year ago

Arrrghhhhhhh my mistake sorry all I made a mistake and put productid_FK instead of productid in my query. Thanks

Dino Over a year ago

Here's the code that I am using: list($price) = mysql_fetch_row(mysql_query(sprintf("select price from product where productid = ".$productid"))); Thanks Dr. Molle

Collectives™ on Stack Overflow

php / mysql list function not returning anything! help!

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related