register form

[aaronbosco]

hey all
I have built a register page from beginnerphp/wrox and I have a little problem saving the data to the database. The whole form shows up but when I submit it I get the contents of my form but 2 error messages as well. Can anyone help?

function in_use($userid) {
global $user_tablename;

$query = "SELECT userid FROM $user_tablename WHERE userid = '$userid'";
$result = mysql_query($query);
if(!mysql_num_rows($result)) return 0;
else return 1;

}

[[deleted]]

Q: What are the error messages?

[Anon]

did you open the databse connection ??

[aaronbosco]

Warning: MySQL: Unable to save result set in /home/oricle/youngcanadian-www/register.php on line 18

Warning: Supplied argument is not a valid MySQL result resource in /home/oricle/youngcanadian-www/register.php on line 19

[aaronbosco]

include "common_db.inc";

$db = db_connect();
mysql_select_db("youngcanadian_com");
$country_array = enum_options('usercountry', $db);
mysql_close($db);

[aaronbosco]

the error msg is(Warning: MySQL: Unable to save result set in /home/oricle/youngcanadian-www/register.php on line 18

Warning: Supplied argument is not a valid MySQL result resource in /home/oricle/youngcanadian-www/register.php on line 19 )

I have recalled data from my db on a previous script but can't seem to insert data.

if you want to see it in action the url is:
http://www.youngcanadian.com/register.php