[Resolved] not so simple select

[keithjasper]

Making a delete script for a shopping basket i though would be semi easy however i have come accross a snag..

the below code produces this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/keith/public_html/shop/basket.php on line 135

this cannot be from past experience on this project.

am i asking for the information in the wrong way?.

Thanks

Keith Jasper

<?

	include "../includes/dbconnect.php.inc";

?>
<form action="basketdelete.php" method="post" name="delete" class="style1" id="delete">
<center> <table border="1">

<?
$query = mysql_query("SELECT * FROM hvgBasket WHERE username = $hvgLogins");
while ($rows = mysql_fetch_array($query))
{
echo "<tr><td><input type=radio name=select value=".$rows[2]."></td><td>".$rows[3]."</td><td>" .$rows[5]. "</td></tr>" ;
}
?>
</table>
<br>
<input type="submit" name="Submit" value="Submit">

</form>

[Weedpacket]

Originally posted by keithjasper

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/keith/public_html/shop/basket.php on line 135

The usual way to debug these sorts of problems is to put some debugging code into the script:

 $query = mysql_query("SELECT * FROM hvgBasket WHERE username = $hvgLogins")
    or die(mysql_error());

for example.

In this case, my guess would be that the error is because username is a character field but $hvgLogins is not in 'quotes'.

[keithjasper]

Your guess would be correct.

Thank you another thing to add to the check before asking list...

Thanks