Hello, I keep getting the error
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home3/soujiro/public_html/edit4.php on line 30
when I execute my script to edit an entry in my database.
Here is the specific area of my script that the area is refering to...
<?
if($cmd=="id")
{
if (!$submit)
{
$sql = "SELECT * FROM blog WHERE id=$id";
$result = mysql_query($sql);
<!-- line of error-->
$myrow = mysql_fetch_array($result);
<!--end line of error-->
?>
<input type=hidden name="id" value="<?php echo $myrow["id"] ?>">
date:<INPUT TYPE="TEXT" NAME="day" VALUE="<?php echo $myrow["day"] ?>" SIZE=30><br>
time:<INPUT TYPE="TEXT" NAME="oclock" VALUE="<?php echo $myrow["oclock"] ?>" SIZE=30><br>
subject:<INPUT TYPE="TEXT" NAME="subject" VALUE="<?php echo $myrow["subject"] ?>" SIZE=30><br>
content:<TEXTAREA NAME="content" ROWS=10 COLS=30><? echo $myrow["content"] ?></TEXTAREA>
<input type="hidden" name="cmd" value="edit">
<input type="Submit" name="submit" value="Post Comment">
</form>
<? } ?>
And here is the rest of the script just for reference...
<form action="<? echo $PHP_SELF ?>" method="post">
<?
mysql_pconnect("localhost","****","*****");
mysql_select_db("soujiro");
if(!$cmd)
{
$result = mysql_query("select * from blog");
while($r=mysql_fetch_array($result))
{
$day=$r["day"];
$oclock=$r["oclock"];
$subject=$r["subject"];
$content=$r["content"];
?>
<INPUT TYPE="RADIO" NAME="edit" VALUE="<?php echo $id;?>"> <?php echo $day;?> <? echo $oclock;?> <? echo $subject;?> <? echo
$content;?> <br>
<? } ?>
<input type="submit" name="cmd" value="edit"></form>
<? } ?>
<!--part 2-->
<?
if($cmd=="edit")
{
if (!$submit)
{
$sql = "SELECT * FROM blog WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
?>
<input type=hidden name="id" value="<?php echo $myrow["id"] ?>">
date:<INPUT TYPE="TEXT" NAME="day" VALUE="<?php echo $myrow["day"] ?>" SIZE=30><br>
time:<INPUT TYPE="TEXT" NAME="oclock" VALUE="<?php echo $myrow["oclock"] ?>" SIZE=30><br>
subject:<INPUT TYPE="TEXT" NAME="subject" VALUE="<?php echo $myrow["subject"] ?>" SIZE=30><br>
content:<TEXTAREA NAME="content" ROWS=10 COLS=30><? echo $myrow["content"] ?></TEXTAREA>
<input type="hidden" name="cmd" value="edit">
<input type="Submit" name="submit" value="Post Comment">
</form>
<? } ?>
<!--part 3-->
<?
if($submit)
{
$sql = "UPDATE blog SET day='$day',oclock='$oclock',subject='$subject',content='$content' WHERE edit=$edit";
$result = mysql_query($sql);
echo "Thank you! Information updated.";
}
}
?>
I'd really appreciate it if anyone'd be able to tell me how to fix this problem. I think it's just a simple syntax error, but I can't seem to get it.
