Showing Visitor Messages 1 to 1 of 1
-
Warning: mysql_num_rows(): supplied argument is not a valid MySQL
below is showing my coding....please help me how to find the solution for error above
<?php
if (isset($_REQUEST["submit"]))
{
$Id=$_REQUEST['Id'];
$NAMA=$_REQUEST['NAMA'];
$NOMBOR_ID=$_REQUEST['NOMBOR_ID'];
$JURUSAN=$_REQUEST['JURUSAN'];
$dbhost="localhost";
$dbuser="root";
$dbpass="";
$db_name="jmti";
$connect = mysql_connect($dbhost,$dbuser,$dbpass);
$selectdb = mysql_select_db($db,$connect);
$checkid = mysql_query("select * from daftar where NAMA = '$NAMA'");
if(mysql_num_rows($checkid)==0)
{
$save = "insert into daftar(Id,NAMA,NOMBOR_ID,JURUSAN) values
('$Id','$NAMA','$NOMBOR_ID','$JURUSAN')";
mysql_query($save) or die ("query error!");
echo "<p>Thank you for using our service, <b>$NAME</b>,your are choosed JURUSAN <b>$JURUSAN</b>";
}
else
echo"<br>Duplicate Food ID";
}
?>