mysql_fetch_assoc() expects parameter 1 to be resource, boolean given. What gives?

Question

Possible Duplicate:
PHP Error: mysql_fetch_array() expects parameter 1 to be resource, boolean given

I am trying to insert data from submitted form into database. The data is being successfully inserted into the DB but I keep getting this error message:

mysql_fetch_assoc() expects parameter 1 to be resource, boolean given

And here's the code:

function senddata () {
    $con = mysql_connect("localhost","XXX","XXX");
    if (!$con)
        {
    die('Could not connect: ' . mysql_error());
        }
        mysql_select_db("user", $con);
        $sql="INSERT INTO Employment (CollegeMajor) VALUE('$_POST[collegemajor]')";
        $result=mysql_query($sql) or die(mysql_error());
        $row = mysql_fetch_assoc($result);


    if (!mysql_query($sql,$con))
        {
    die('Error: ' . mysql_error());
        }


    mysql_close($con);
    }

The error message is referring to this line:

$row = mysql_fetch_assoc($result);

**WARNING** your code is susceptible to sql injection attacks. — Daniel A. White, Dec 13 '11 at 21:25
Why all the downvotes on this question? Get an upvote just to ease the abuse. — Charles Sprayberry, Dec 13 '11 at 22:15

score 3 · Accepted Answer · answered Dec 13 '11 at 21:26

3

http://de2.php.net/manual/en/function.mysql-query.php

This is expected behavior. INSERT statements return a boolean value, true on success and false on failure.

However, you really should look at mysqli or PDO.

answered Dec 13 '11 at 21:26

Charles Sprayberry

7,741
3
41
50

I just deleted the row variable and it's all good now. – Matthieu McLaren Dec 13 '11 at 22:56

score 2 · Answer 2 · edited Dec 13 '11 at 21:54

2

Please use the function mysql_affected_rows() to get the result of an INSERT operation.

edited Dec 13 '11 at 21:54

Brian

15,599
4
46
63

answered Dec 13 '11 at 21:42

Andries Louw Wolthuizen

124
1
2

score 0 · Answer 3 · edited Dec 13 '11 at 22:30

0

what sort of result are you expecting after inserting a row into mysql?

if you want to obtain auto-increment-id - run mysql_insert_id($con).

edited Dec 13 '11 at 22:30

Kevin

53,822
15
101
132

answered Dec 13 '11 at 21:28

pQd

116
4
20

mysql_fetch_assoc() expects parameter 1 to be resource, boolean given. What gives?

3 Answers3