wisewood
30-05-03, 05:19 PM
HELP ME!!!
I am trying to get this to work - http://www.wisew.com/tests/update2.php
So far it works right up to the point where it has to update the database and then it takes me back to the list as it should do, but doesnt alter the entry on the database.
Here is the code:
<form action="<? echo $PHP_SELF ?>" method="post">
<?
mysql_pconnect("localhost","db_username","db_password");
mysql_select_db("db_name");
if(!$cmd)
{
$result = mysql_query("select * from table_name");
while($r=mysql_fetch_array($result))
{
$who=$r["who"];
$email=$r["email"];
$title=$r["title"];
$body=$r["body"];
$id=$r["ID"];
?>
<INPUT TYPE="RADIO" NAME="id" VALUE="<?php echo $id;?>"><? echo $id;?> <? echo $title ?>
<? } ?>
<input type="submit" name="cmd" value="edit"></form>
<? } ?>
<?
if($cmd=="edit")
{
if (!$submit)
{
$sql = "SELECT * FROM table_name WHERE ID=$id";
//replace news with your table name above
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
?>
<input type=hidden name="ID" value="<?php echo $myrow["ID"] ?>">
Who:<INPUT TYPE="TEXT" NAME="who" VALUE="<?php echo $myrow["who"] ?>" SIZE=30>
email:<INPUT TYPE="TEXT" NAME="email" size="30" VALUE="<? echo $myrow["email"] ?>">
title:<INPUT TYPE="TEXT" NAME="title" VALUE="<?php echo $myrow["title"] ?>" SIZE=30>
body:<TEXTAREA NAME="body" ROWS=10 COLS=50><?php echo $myrow["body"] ?>
</TEXTAREA>
<input type="hidden" name="cmd" value="edit">
<input type="Submit" name="submit" value="Post Comment">
</form>
<? } ?>
<?
if($submit)
{
$sql = "UPDATE table_name SET who='$who',email='$email',title='$title', body='$body' WHERE ID=$id";
$result = mysql_query($sql);
echo "Thank you! Information updated.";
}
}
?>
I have been trying for a couple of days to figure this out, but i just cant make it work and its doing my head in!!!
I have checked more times than i could count that i am using the right username/password/database/table/field names... someone must be able to make this code work for me... PLEASE!!!
I am trying to get this to work - http://www.wisew.com/tests/update2.php
So far it works right up to the point where it has to update the database and then it takes me back to the list as it should do, but doesnt alter the entry on the database.
Here is the code:
<form action="<? echo $PHP_SELF ?>" method="post">
<?
mysql_pconnect("localhost","db_username","db_password");
mysql_select_db("db_name");
if(!$cmd)
{
$result = mysql_query("select * from table_name");
while($r=mysql_fetch_array($result))
{
$who=$r["who"];
$email=$r["email"];
$title=$r["title"];
$body=$r["body"];
$id=$r["ID"];
?>
<INPUT TYPE="RADIO" NAME="id" VALUE="<?php echo $id;?>"><? echo $id;?> <? echo $title ?>
<? } ?>
<input type="submit" name="cmd" value="edit"></form>
<? } ?>
<?
if($cmd=="edit")
{
if (!$submit)
{
$sql = "SELECT * FROM table_name WHERE ID=$id";
//replace news with your table name above
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
?>
<input type=hidden name="ID" value="<?php echo $myrow["ID"] ?>">
Who:<INPUT TYPE="TEXT" NAME="who" VALUE="<?php echo $myrow["who"] ?>" SIZE=30>
email:<INPUT TYPE="TEXT" NAME="email" size="30" VALUE="<? echo $myrow["email"] ?>">
title:<INPUT TYPE="TEXT" NAME="title" VALUE="<?php echo $myrow["title"] ?>" SIZE=30>
body:<TEXTAREA NAME="body" ROWS=10 COLS=50><?php echo $myrow["body"] ?>
</TEXTAREA>
<input type="hidden" name="cmd" value="edit">
<input type="Submit" name="submit" value="Post Comment">
</form>
<? } ?>
<?
if($submit)
{
$sql = "UPDATE table_name SET who='$who',email='$email',title='$title', body='$body' WHERE ID=$id";
$result = mysql_query($sql);
echo "Thank you! Information updated.";
}
}
?>
I have been trying for a couple of days to figure this out, but i just cant make it work and its doing my head in!!!
I have checked more times than i could count that i am using the right username/password/database/table/field names... someone must be able to make this code work for me... PLEASE!!!