From the names of your variables, it looks like you are trying to get an array out of your SQL statement and not the result set.
You should be doing something like this:
$result = mysql_query($sql, $db);
if (!$result) echo mysql_error();
else
{
while ($row = mysql_fetch_array($result))
{
// stuff
}
}Smile-Poet wrote:
I have this line
while($row = mysql_fetch_array($sql)){
which gets the error
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
-- :::::::::::::::::::::::::::::: Howard Cheng http://www.howcheng.com/ Wise-cracking quote goes here.
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016
Please include the email address which you have been contacted with.
