Re: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

[Jeff Li]

hello,

have you tried feeling the $sql2 statement directly to the MySQL interface to validate it?

i am asking because i have spot some syntax errors in the statement that assigns $sql2 the SQL query, which can cause the error message.
try echo-ing the query and feed the output to the MySQL interface to hunt for SQL statement syntax errors.

the statement with the syntax errors corrected is

$sql2 = "SELECT region, type, job, location, designation, description, wwwreg, wwwdesc, datecreated, datemodified, deleteforwww, moreinformation FROM openings where no = '".$no."';";

hth

Jeff