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

<?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;
} 
?>

Open in new window

editeditedit.JPG
LVL 15
wantabe2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
Lukasz ChmielewskiConnect With a Mentor Commented:
Aso, there is no $num variable

<?php
$con = mysql_connect("localhost","uname","password") or die(mysql_error());
mysql_select_db("mydb", $con) or die(mysql_error());;
$result = mysql_query("SELECT * FROM mytable ") or die(mysql_error());;
$num = mysql_num_rows($result);
$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;
}

Open in new window

0
 
Lukasz ChmielewskiCommented:
Use this at the top to see what's wrong

$con = mysql_connect("localhost","uname","password") or die(mysql_error());
mysql_select_db("mydb", $con) or die(mysql_error());;

$result = mysql_query("SELECT * FROM mytable ") or die(mysql_error());;
0
 
Lukasz ChmielewskiCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.