[Resolved] MySQL Fetch Array warning

[badgoat]

Hi! I am getting the below warning:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\phpdev5\www\damndiw4.php on line 331

and only when there is an apostrophe in the variable being compared. The query is:

$get_depsite_info = mysql_query("SELECT * FROM depsite WHERE depsitename = '".$row['dropdowndeposite']."'");

What can I do to prevent this from happening?

[paulnaj]

The trick is to use the addslashes() to escape (add a \ in front of ) the quotes.

Paul 🙂

[badgoat]

Thank you Paul, that's the fix..

Now to figure out how to make it work where the variables are dynamic entries in a drop down list.. =)