Extract a row but without any rows to exract

[agmorgan]

Hi..

I have written a fine program that retrieves a row from my db, however, when ther isn't a row to rerieve I get the followng message

Warning: extract(): First argument should be an array in /home/myourm/public_html/shoppingbasket.inc on line 60

(I am assuming that this is coming up as the program works when I have a data in a row).

How can I stop this? My current script is :

while ($row = mysql_fetch_array($result))

{
extract($row);
echo "<table border='1' width '100%'>

  	   <td width ='10%'>$SCcode</td>\n
       <td width ='50%'>$SCprodName</td>\n
       <td width ='10%'>$SCprodPrice</td>\n
       <td width ='20%'>$SCcolour</td>\n
       <td width ='10%'>$SCweight</td>\n
      </td>\n

</tr>\n";

thanks
Andy

[barand]

A strange one. If there are no rows then mysql_fetch_array() should return false and then the extract() does not execute. Do you have another extract() nearby in the code

[devinemke]

$result = mysql_query('SELECT * FROM table') or exit(mysql_error());
if (mysql_num_rows($result))
{
	// display the data
}
else
{
	echo 'no records found';
}