why the data can't dispaly in the form???(error-mysql_fetch_array():)
- by shimaTun
I've created a code to view the data. Now it seem contain an error.
When I run this page this error display:
Warning: mysql_fetch_array(): supplied
argument is not a valid MySQL result
resource in C:\Program
Files\xampp\htdocs\e-Complaint(FYP)\userView.php
on line 93
the code :
<?php //======================================================================================================================= PROCESS DATA ======================================================= START.
include "connectioncomplaint.php";
?>
<?php
$subject = $_GET['type'];
$comment = $_GET['id'];
//echo 'test : ' . $name;
//Tarik data dari sini
$queryDetail = " SELECT * FROM campuscomplaint " . " WHERE subject = '" . $subject . "' AND comment = '" . $comment . "' ";
//echo 'QUERY DETAIL :' . $queryDetail . '<br>' ;
$resulDetail = mysql_query($queryDetail);
//echo 'RESULT DETAIL :' . $resultDetail + 0 . '<br>' ;
$detail = mysql_fetch_array($resultDetail);
//echo $detail . '<br>';
//echo 'detail subject is : ' . $detail['subject'] . '<br>';
//echo 'detail comment is : ' . $detail['comment'] . '<br>';
//echo $detail[$x] . '<br>';
?>
code for form:
<tr>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="register style5">From:</td>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="register style5"><input type="text" name="to"
size="40" maxlength="80" value="<?php echo $detail['userid']; ?>"/></td>
</tr>
<tr>
<td width="38%" bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="register style5">Subject:</td>
<td width="62%" bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="register style5"><input type="text" name="subject" size="40" maxlength="80" value="<?php echo $detail['subject']; ?>"/></td>
</tr>
<tr>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="register style5">Comment:</td>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="register style5"><textarea name="comment" rows="5" cols="40"><?php echo $detail['message']; ?></textarea></td>
</tr>
<tr>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="register style5"><p> </p>
<p> </p></td>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="register style5"><input type="submit" name="submit" value="Submit Comment" onClick="return OnButton1();"/></td>
</tr>
