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

johnchooiyoke

Hi there

The application accepts a 'no' (a number) from a HTML form and takes the number to retrieve the relevant record from a database table. However, the error appears (as stated below):

This is the snippet of code that I think is causing the problem.

    $no = $_POST['no'];

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

    $result2 = mysqli_query($cxn, $sql2)
        or die("Could not execute query: ".mysqli_error($cxn));

    $row = mysql_fetch_assoc($result2);

The error message is:

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

I know that either I type the SQL wrong but I can't see anything in it that is wrong or that MySQL fails to retrieve the relevant record. But why. Pls assist.

leatherback

Basic query debugging: You should
- Echo the SQL and look at the output
- Echo the mysql error (Add or die(mysql_error()) at the end of your mysql_query() statement
- You could even try and place the query into phpadmin directly, and check the error there.

You will probably find that
deleteforwww
is not a colum in your table

eatmypiano

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

Change your quotes around. "$no" won't work. The query you're passing to MySQL is SELECT region, type, job, location, designation, description, wwwreg, wwwdesc, datecreated, datemodified, deleteforwww, moreinformation FROM openings where no = "$no" so you're getting back an empty result set, hence the error. Try this:

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