wantabe2
asked on
PHP Form/Mysql Issues
Okay,
I've taken some of your advice, example codes, read some URLs & have build the following but it is not pulling the data from my mysql database so I can see it to edit it. Can soomeone take a look at this to see where my mistake is? I've also attached a photo of the fields I'm trying to edit to help you better understand what I am doing. Thanks
I've taken some of your advice, example codes, read some URLs & have build the following but it is not pulling the data from my mysql database so I can see it to edit it. Can soomeone take a look at this to see where my mistake is? I've also attached a photo of the fields I'm trying to edit to help you better understand what I am doing. Thanks
<?php
$con = mysql_connect("localhost","uname","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("mydb", $con);
$result = mysql_query("SELECT * FROM mytable ");
$i=0;
while ($i < $num) {
$due_ge=mysql_result($result,$i,"due_ge");
$due_rk=mysql_result($result,$i,"due_rk");
$due_ny=mysql_result($result,$i,"due_ny");
?>
<form action="updated.php">
<input type="hidden" name="id" value="<? echo "$id"; ?>">
DATE1: <input type="date" name="due_ge" value="<? echo "$due_ge"?>"><br>
DATE2: <input type="date" name="due_rk" value="<? echo "$due_rk"?>"><br>
DATE3: <input type="date" name="due_ny" value="<? echo "$due_ny"?>"><br>
<input type="Submit" value="Update">
</form>
<?php
++$i;
}
?>
editeditedit.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've noticed that there is no $id declared and for each record there is a form generated - is that correct thing to do ?
add
error_reporting(E_ALL);
to the top of the script and this will tell you more.
add
error_reporting(E_ALL);
to the top of the script and this will tell you more.
$con = mysql_connect("localhost",
mysql_select_db("mydb", $con) or die(mysql_error());;
$result = mysql_query("SELECT * FROM mytable ") or die(mysql_error());;