Hi. I have this code:
CODE
<?php
$note = mysql_fetch_row(mysql_query("SELECT MAX(id) FROM note"));
if ($note[0] == NULL)
{
echo "Brak notek do modyfikacji!";
}
else
{
echo '<form action="admin.php?x=edit" method="post">';
echo "\n<select>\n";
for($i = 1; $i <= $note[0]; $i++)
{
$title = mysql_fetch_row(mysql_query("SELECT title FROM note WHERE id = $i"));
echo '<option name="'.$i.'">'.$title[0].'</option>'."\n";
}
echo '</select><br /><button type="submit">Wyślij</button><br />';
}
?>
I want to send $i [value of message ID] via this form, but I get errors, when I try to use it:
CODE
<?php
$edited = $_POST['i'];
$title = mysql_fetch_row(mysql_query("SELECT title FROM note WHERE id = $edited"));
$content = mysql_fetch_row(mysql_query("SELECT content FROM note WHERE id = $edited"));
$content = mysql_fetch_row(mysql_query("SELECT date FROM note WHERE id = $edited"));
if(isset($title) && isset($content))
{
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">
<div>
<table>
<tr><td><input type="text" name="title" value="'.$title[0].'" size="40" /></td></tr>
<tr><td><textarea name="content" cols="50" rows="15">'.$content[0].'</textarea></td></tr>
<tr><td><input type="hidden" name="title" value="'.$date[0].'" size="19" /></td></tr>
<tr><td><button type="submit">Wyślij</button></td></tr>
</table>
</div>
</form>'."\n";
}
?>
My errors are:
CODE
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\wamp\www\blog\admin\edit.php on line 3
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\wamp\www\blog\admin\edit.php on line 4
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\wamp\www\blog\admin\edit.php on line 5
I don't know what's wrong
Thanks in advance for help
This post has been edited by k0b13r: 10 Aug, 2007 - 04:45 PM
10 Aug, 2007 - 04:45 PM
| 