why im having an error in php?

S

samuel101

New member
im having this error:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\update.php on line 65... why?

<?php

include 'conn.php';

$flag=$_GET["flag"];

if ($flag=="1")
{
$studnum = $_GET["studnum"];
$del = "DELETE FROM newdbase WHERE studnum='$studnum'";
$nres = mysql_query($del);
if(!$nres) {
echo " Failed to delete: ".mysql_error();
} else {
echo " Deleting successful";
}
}


if ($flag=="2")
{
$lname = $_POST["lname"];
$fname = $_POST["fname"];
$mname = $_POST["mname"];
$sex = $_POST["sex"];
$course = $_POST["course"];

$ans = "INSERT INTO update VALUES ('$studnum','$lname', '$fname', '$mname' ,'$sex',

'$course')";
$result = mysql_query($ans);

if($result!="")
{
echo "<br>Saving Successful";
}
else
{
echo "<br>Failed". mysql_error();
}
}

?>
<HTML>
<BODY>
<FORM METHOD = "get" ACTION = "update.php?flag=2">
<PRE>
<FONT SIZE = 5><B>EDITING INFO</B></FONT>


<B>NAME:</B> <input type = text name = lname size = 25 maxlength = 20> <input type = text

name = fname size = 25 maxlength = 20> <input type = text name = mname size = 3 maxlength

= 3>
Lastname Firstname Middle
<B>AGE: </B><input type = text name = age size = 3 maxlength = 3>
<B>SEX: </B><input type = radio name = sex value = M> MALE <input type = radio name = sex

value = F> FEMALE
<TABLE>
<B>COURSE:</B> <TR><TD><input type = radio name = course value = CBA>CBA</TD><TD><input

type = radio name = course value = CEA>CEA</TD><TD><input type = radio name = course value

= CICT>CICT</TD></TR><TR><TD><input type = radio name = course value =

CAS>CAS</TD><TD><input type = radio name = course value = CHM>CHM</TD><TD><input type =

radio name = course value = CON>CON</TD></TR>
</TABLE>
<input type = submit name = submit value = SAVE><input type = reset name = clear value =

CANCEL>

<?php

$result2 = mysql_query("SELECT * FROM update");
echo '<table border ="1">';
echo '<th>ACTION</th><th>NAME</th><th>SEX</th><th>COURSE</th>';
if (count($result2)>0)
{
while ($a = mysql_fetch_array($result2))
{
echo "<tr>";
echo "<td><a href=\"update.php?studnum=".$a["studnum"]."&flag=1\"> DELETE

</a></td>";
echo "<td>".$a["lname"]."-".$a["fname"]."-".$a["mname"]."</td>";
echo "<td>".$a["sex"]."</td>";
echo "<td>".$a["course"]."</td>";
echo "<td>".$a["age"]."</td>";
echo "</tr>";
}
}
echo "</table><br>";

?>
</PRE>
</FORM>
</BODY>
</HTML>
 
Back
Top