mysql_query(): supplied argument is not a valid MySQL-Link resource

[ultimachris]

Hello all, im going round the bend wondering whyyy im getting a mysql query error on this code:

 

<?php

$mysql = mysql_connect("*******", "**********", "*******", "********");

 

if (mysql_errno()) {

printf("Connect Failed: %s\n", mysql_connect_error());

exit();

} else {

$sql = "INSERT INTO tickets (testfield) VALUES ('".$_POST["testfield"]."')";

$res = mysql_query($mysql, $sql);

 

if ($res === TRUE) {

echo "A new ticket has been added.";

} else {

printf("could not insert record: %s\n", mysql_error($mysql));

 

}

mysql_close ($mysql);

}

?>

 

What on earth am i doing wrong???

Hope you can help me guys, you rule!

 

Chris

[Mchl]

resource mysql_query  ( string $query  [, resource $link_identifier  ] )

 

As you can see, query goes first, then the connection resource. You have it the other way round.

[ultimachris]

thanks MCHL, will try this out! so it should be ($sql, $mysql)

 

hmmm....now it says

 

"could not insert record: No database selected "

[Mchl]

No wonder. You did not use mysql_select_db