[RESOLVED] Error Extract() Should Be in An Array

[cybersurfur]

Hi all, Im trying to put togeather a shopping basket but keep getting this error: :glare:

Warning: extract() [function.extract]: First argument should be an array in c:\wamp\www\website\cart.php on line 53

The code looks like this:

<?php
$total = 0;
while ($row = mysql_fetch_array($results)) {
echo "<tr>";
extract($row);
$prod = "SELECT * FROM products " .
"WHERE product_id='$carttemp_prodnum'";
$prod2 = mysql_query($prod);
$prod3 = mysql_fetch_array($prod2);
extract($prod3);

Where like 'extract($prod3);' is line 53.

But its all ready set as an Array... i originally thought it may be becoz its not returning any results... but thats SHOULD NOT be the case there should definately be a result returned. :bemused:

Any ideas as to what i may be doing wrong? :mad:

[hessian]

Are you sure it is returning a result?

<?php
$total = 0;
while ($row = mysql_fetch_array($results)) {
echo "<tr>";
extract($row);
$prod = "SELECT * FROM products " .
"WHERE product_id='$carttemp_prodnum'";
$prod2 = mysql_query($prod);
if(mysql_num_rows($prod2))
{
$prod3 = mysql_fetch_array($prod2);
extract($prod3);
}
else
echo mysql_error();

[cybersurfur]

Im certain that something SHOULD be returning results.

The previous page sends the item selected as:

<form method="POST" action="modcart.php?action=add">

to modcart which stores it in the database and gets cart.php to display it

Now with the above alterations you've suggested the browser doesnt display the error anymore BUT it still wont display the items information... which is why im not sure if it is infact returning a result.

hhhhhmmmmmm this is getting confusing even for me 😕

[hessian]

Well if you aren't getting a the error, you are getting zero results from your query, that and if mysql_error() isn't spitting anything out, this make me think there is nothing matching in your query. Maybe you are looking at the wrong script, perhaps you should check the INSERT SQL.