Forum Moderators: coopster

Message Too Old, No Replies

update script

trying to update fields in a table from a form

         

YnotInTX

7:31 pm on Mar 27, 2005 (gmt 0)

10+ Year Member



The page below just comes up blank where did I go wrong? I hope this isn't to dumb of a question.

<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM todo WHERE id='$id'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
$item=mysql_result($result,$i,"item");
$description=mysql_result($result,$i,"description");
$category=mysql_result($result,$i,"category");
$priority=mysql_result($result,$i,"priority");

?>

<form action="updated.php">
<input type="hidden" name="ud_id" value="<? echo "$id";?>">
Item: <input type="text" name="ud_item" value="<? echo "$item"?>"><br>
Description: <input type="text" name="ud_description" value="<? echo "$description"?>"><br>
Category: <input type="text" name="ud_category" value="<? echo "$category"?>"><br>
Priority: <input type="text" name="ud_priority" value="<? echo "$priority"?>"><br>
<input type="Submit" value="Update">
</form>

<?
++$i;
}
?>

wrightee

11:40 pm on Mar 27, 2005 (gmt 0)

10+ Year Member



Is there data being returned from the query?

When you view source of the resulting page does it look like it's tried to create output but a missing > or quote mark might've bust it?

YnotInTX

11:42 pm on Mar 27, 2005 (gmt 0)

10+ Year Member



The file below is supposed to bring up a form with the fields for a user inserted into it for editing. "edit.php?id=83" is an example of the link to it. When that link is clicked the page is empty and the is no code in the source view.

<?
include("dbinfo.inc.php");
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="select from todo where id='".$_GET['id']."' LIMIT 1";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();

$i=0;
while ($i < $num) {
$item=mysql_result($result,$i,"item");
$description=mysql_result($result,$i,"description");
$category=mysql_result($result,$i,"category");
$priority=mysql_result($result,$i,"priority");

?>

<form action="updated.php">
<input type="hidden" name="ud_id" value="<? echo "$id";?>">
Item: <input type="text" name="ud_item" value="<? echo "$item"?>"><br>
Description: <input type="text" name="ud_description" value="<? echo "$description"?>"><br>
Category: <input type="text" name="ud_category" value="<? echo "$category"?>"><br>
Priority: <input type="text" name="ud_priority" value="<? echo "$priority"?>"><br>
<input type="Submit" value="Update">
</form>

<?
++$i;
}
?>