problem with form

amar3d

Hi i am trying to output a query on a form so that users may edit it once the query has found the record, but i keep on getting an error message saying Undefined index: dvd_id, does anyone know what i am doing wrong.....thanking u in advance.....amar

w_geoghegan

The message is telling you that the index dvd_id is not present in the $_POST array.

Do a

print_r($_POST);

to see ALL data within $_POST.

Hope this helps.

Cheers.

William Geoghegan
GEOTEK Computer Services
- www.geotekcs.co.uk -

amar3d

hi, thanks for the reply...while it now shows my data...it still shows the error Undefined index: dvd_id ...i have put the print_r in like this

<html><head><title></title></head>
<body>
<?
$dvd_id=print_r($_POST['dvd_id']);
$db = mysql_connect("localhost","username");
$link = mysql_select_db("test",$db);

$result=mysql_query(" SELECT * FROM dvds WHERE dvd_id='$dvd_id'");

$num=mysql_num_rows($result);
$i=0;
while ($i < $num) {
$dvd_name=mysql_result($result,$i,"dvd_name");
?>
<table width="300" cellpadding="3" cellspacing="0" border="2">
<tr align="center" valign="top">
<td align="center" colspan="1" rowspan="1" bgcolor="#5FACD6">
<form action="change_details.php" method="post">
<input type="hidden" name="dvd_id" value="<? echo "$dvd_id" ?>">
DVd name: <input type="text" name="dvd_name" value="<? echo "$dvd_name"?>"><br>
<input type="Submit" value="Update">
</form>
</td></tr></table>
<?
++$i;
}
?>
</body>
</html>
print_r

I apprciate the help, i'm still very new to PHP so forgive me if my question i at all trivial.

amar3d

hi, thanks for the reply...while it now shows my data...it still shows the error Undefined index: dvd_id ...i have put the print_r in like this

<html><head><title></title></head>
<body>
<?
$dvd_id=print_r/COLOR;
$db = mysql_connect("localhost","username");
$link = mysql_select_db("test",$db);

$result=mysql_query(" SELECT * FROM dvds WHERE dvd_id='$dvd_id'");

$num=mysql_num_rows($result);
$i=0;
while ($i < $num) {
$dvd_name=mysql_result($result,$i,"dvd_name");
?>
<table width="300" cellpadding="3" cellspacing="0" border="2">
<tr align="center" valign="top">
<td align="center" colspan="1" rowspan="1" bgcolor="#5FACD6">
<form action="change_details.php" method="post">
<input type="hidden" name="dvd_id" value="<? echo "$dvd_id" ?>">
DVd name: <input type="text" name="dvd_name" value="<? echo "$dvd_name"?>"><br>
<input type="Submit" value="Update">
</form>
</td></tr></table>
<?
++$i;
}
?>
</body>
</html>

I apprciate the help, i'm still very new to PHP so forgive me if my question i at all trivial.

w_geoghegan

OK.

I'll try to explain it this way.

PHP is telling you $_POST['dvd_id'] is not set or does not have a value.


<?

print $_POST['dvd_id']; // would show 1000

?>

E-mail me the script and I will fix it for you if you still don't understand.

Cheers.

William Geoghegan
GEOTEK Computer Services
- www.geotekcs.co.uk -