have issues with my code

AfterAlot · October 7th, 2012, 06:24 PM

Code:

$dbc =  mysql_connect('localhost', 'root', '72031118311')
//if(!$dbc)
//{ unable to connect
or die('could not connect to the requested database'. mysql_error());
//
echo "connection successful"; 
mysql_close($dbc); 
echo "<br />";
	//create a query and store it as a string in a php variable
$query = "INSERT INTO contacts(first,middle,surname,email, phone,home,office) 
VALUES('$first','$middle','$surname','$phone','$email','$home','$office')";
$result = mysql_query($dbc,$query)
or die('Error querying database');
mysql_close();

The error message"Warning: mysql_query() expects parameter 1 to be string, resource given in C:\wamp\www\Nexus\contact.php on line 19" what is wrong with this code?

UseLess · October 8th, 2012, 03:59 AM

Greetings,

This;

Code:

$result = mysql_query($dbc,$query)
or die('Error querying database');

should be;

Code:

$result = mysql_query($query,$dbc)
or die('Error querying database');

because like the error message is telling you the command 'mysql_query' expects the 1st parameter to be a string (which contains the SQL query) and the optional 2nd parameter is the db link identifier.