Help...please

[sara123]

I am trying to create user accouts, I recieve the following error message:

Warning: mysql_real_escape_string() expects parameter 2 to be resource, null given in

mysql-connect.php on line 19

below is my connection code, where the error is showing...not sure what it means..can someone help please I am new to this.

function escape_data ($data) {
global $dbc;
if (ini_get('magic_quotes_gpc')) {
$data = stripslashes($data);

}
	return mysql_real_escape_string()
	($data, $dbc);
	}

[Horizon88]

return mysql_real_escape_string()
($data, $dbc);

should be:

return mysql_real_escape_string($data, $dbc);

[sara123]

thanks for your reply, I have changed it to what you suggested, but it is still giving me same error message:

function escape_data ($data) {
global $dbc;
if (ini_get('magic_quotes_gpc')) {
$data = stripslashes($data);

}
	return mysql_real_escape_string($data, $dbc);
	}

Warning: mysql_real_escape_string() expects parameter 2 to be resource, null given in /home/vol1/public_html/old-CD/mysql-connect.php on line 19

is there anything else which i could change..?

[Horizon88]

$dbc isn't being set properly, wherever it is initially set.

[sara123]

i have changed some bits..now its giving me a different error:

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/vol1/public_html/old-CD/user_registeration_php.php on line 288

line 288 is: mysql_close($mysql_connect);

below is my connection code:

<?php
// This file contains the database access information. */

$username="";
$password="";
$database="";

$dbc = mysql_connect("",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

//function for escaping data.

function escape_data ($data) {
global $dbc;
if (ini_get('magic_quotes_gpc')) {
$data = stripslashes($data);

}
	return mysql_real_escape_string($data, $dbc);
	} // end of escape_data() function.

?>

[Horizon88]

Is line 288 in a different file? You don't show where $mysql_connect is defined in the current file, and .... yeah, what? :S

[sara123]

yeh, tht is a different file....and my connection code is in a seperate file...im not quite sure how to define it...i thought i had already :S

[Horizon88]

The reason it's throwing that error is because you don't have a valid database resource inside $dbc - you're not connecting right. From the looks of things you've got your flow all wrong - you're including functions and stuff within your database connection file, but they reference things that aren't included yet? You ought to go through and double check that all your variables are being set correctly and your includes are in a logical order.