supplied argument is not a valid MySQL result resource? Help

[decneo]

Hello,friends

 

  i got error said : "  supplied argument is not a valid MySQL result resource " like this screenshot

 

 

 

ບໍ່ສາມາດສະໝັກເປັນສະມາຊິກໄດ້ = you can not register to become to be a member.

 

  this is my code,what's wrong with this line : $num=mysql_num_rows($result); it can not insert to tb_member.  :'(

 

<?
$user_reg=$_POST[user_reg];
$pass_reg=$_POST[pass_reg];
$name_reg=$_POST[name_reg];
$sex_reg=$_POST[sex_reg];
$email_reg=$_POST[email_reg];
$tel_reg=$_POST[tel_reg];
$address_reg=$_POST[address_reg];
$date_reg=date("Y-m-d");

if ($user_reg=="" or $pass_reg=="" or $name_reg=="" ) {
echo "<h3>ERROR : ກະລຸນາກຼອກຂໍ້ມູນໃຫ້ຄົບຖ້ວນ<h3>"; exit();
}
include "function.php";
if (!checkemail($email_reg)) {
echo "<h3>ERROR : ຮູບແບບ ອີເມລ ບໍ່ຖືກຕ້ອງ </h3>"; exit();
}
include "connect.php";
$sql="select * from tb_member where username='$user_reg' ";
$result=mysql_db_query($dbname,$sql);
$num=mysql_num_rows($result);
if($num>0) {
echo "<h3>ERROR : Username ມີຢູ່ໃນລະບົບແລ້ວ </h3>"; exit();
}
$sql="insert into tb_member values('','$user_reg','$pass_reg','$name_reg','$sex_reg',
'$email_reg','$tel_reg','$address_reg','$date_reg')";
$result=mysql_db_query($dbname,$sql);
if ($result) {
echo "<h3>ຂໍ້ມູນຂອງທ່ານຖືກບັນທຶກຮຽບຮ້ອຍແລ້ວ</h3>";
echo "<A HREF='index.html'>ຄິຼກເພື່ອເຂົ້າລະບົບສະມາຊິກ</A><BR><BR>";
} else {
echo "<h3>ບໍ່ສາມາດສະໝັກເປັນສະມາຊິກໄດ້</h3>";
}
mysql_close();
?>

 

 

Please help!!

 

best regard,

koko

[PFMaBiSmAd]

If you search for any portion of that error message you will find that it means that your query failed to execute due to an error.

 

For debugging purposes only (remove it after you are done), echo msyql_error(); on the next line right after the line with the mysql_query() statement.

[decneo]

If you search for any portion of that error message you will find that it means that your query failed to execute due to an error.

 

For debugging purposes only (remove it after you are done), echo msyql_error(); on the next line right after the line with the mysql_query() statement.

i'm confusing

Could you please give me some example for my script line? because i'm a newbie,so sorry about this

 

best regard

koko,

 

[fenway]

That was the example.

[decneo]

That was the example.

 

$sql="insert into tb_member values('','$user_reg','$pass_reg','$name_reg','$sex_reg',
'$email_reg','$tel_reg','$address_reg','$date_reg')";
echo msyql_error(); 
$result=mysql_db_query($dbname,$sql);

 

ok,i've added like PFMaBiSmAd's advise and i got this , what does it mean? please recommend .

 

 

[PFMaBiSmAd]

Actually, that means that there was a typo in the post, which you should have been able to figure out because all the mysql functions start with mysql

[decneo]

Actually, that means that there was a typo in the post, which you should have been able to figure out because all the mysql functions start with mysql

 

but i've checked every statement that are correct for the post .

[jeffshen]

 

$sql="insert into tb_member values('','$user_reg','$pass_reg','$name_reg','$sex_reg',
'$email_reg','$tel_reg','$address_reg','$date_reg')";
echo msyql_error(); 
$result=mysql_db_query($dbname,$sql);

 

You typed echo msyql_error();

 

it should be mysql_error();

[decneo]

 

$sql="insert into tb_member values('','$user_reg','$pass_reg','$name_reg','$sex_reg',
'$email_reg','$tel_reg','$address_reg','$date_reg')";
echo msyql_error(); 
$result=mysql_db_query($dbname,$sql);

 

You typed echo msyql_error();

 

it should be mysql_error();

 

ok, i did it and it said no database selected

 

how can i test my connect.php?

 

best regard,

Decneo

[fenway]

mysql_select_d()?

[decneo]

mysql_select_d()?

 

still didnt work  :'(

[fenway]

Then read up on the mysql_* functions in the php refman -- it seems to be igonring you.

[decneo]

Then read up on the mysql_* functions in the php refman -- it seems to be igonring you.

 

where  i could found this..?  sorry to trouble you but i'm a newbie need more explain please please

 

best regards,

Deneo

[fenway]

The refman is your friend.

[decneo]

The refman is your friend.

 

who is the refman ? :-\

[fenway]

See here.

[decneo]

See here.

 

thank you bro , my host website is clear now

 

best regards,

Decneo