Problem with mysql_query() ;Says resource expected .

Answer 1

$result2=mysql_query($sql2,$conn);

$conn is not defined in the scope of your function (even if you're including the connect.php file before that.

although you can use the suggestion to make $conn global, it's usually better practice to not make something global just for the sake of globalizing it.

i would instead pass $conn to the function as a parameter. this way, you can reuse the same function you wrote with different connections.

Answer 2

$conn isn't declared as a global so the function cannot access it, as it is not defined within it.

Either simply add

global $conn;

To the top of the function to allow it to access the $conn.

Or you can remove $conn from the mysql_query() statement. By default it will use the current connection (as mentioned in the comments below).

Answer 3

Where do you set $conn? It doesn't look like you set a connection within that function