MySQL Error
Posted: Wed Jan 20, 2010 4:22 am
Hai Iam facing a problem with this mysql query ............
$sqlinsert="insert into quitstudents value('$regdid','$subjectid','$remarks','L','$cdate')";
echo $sqlinsert;
$rs=mysql_query($sqlinsert) or die("Error: ". mysql_error(). " with query ". $sqlinsert);
$countinsert=mysql_num_rows($sqlinsert);
data is insert into database but giving error.
insert into quitstudents value('8009','4','fgf','L','2010-01-20')
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/iiewscom/public_html/PHP/ClientEntry/quitstudententry.php on line 41
$sqlinsert="insert into quitstudents value('$regdid','$subjectid','$remarks','L','$cdate')";
echo $sqlinsert;
$rs=mysql_query($sqlinsert) or die("Error: ". mysql_error(). " with query ". $sqlinsert);
$countinsert=mysql_num_rows($sqlinsert);
data is insert into database but giving error.
insert into quitstudents value('8009','4','fgf','L','2010-01-20')
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/iiewscom/public_html/PHP/ClientEntry/quitstudententry.php on line 41