[Resolved] Pass fetch result to included file?

[mOk]

Hi,

If someone wants to update their personal data, I can retrieve their record. I would like to pass that row of data to an included php file and build a form for them to edit. Is that possible?

Rephase:
$getinfo = mysql_fetch_array($result, MYSQL_ASSOC);
if ($getinfo)
{
$tname = $getinfo['name'];
if ($tname == $name)
{
require_once('listedit.php');

Is $getinfo NOT available to listedit.php ?

[tekky]

after you require it, I believe you can make a function call after the require using the functions in that include...

I would try that... I dont often use require's but I recall that being a working method (if you already tested and just straight using the varname didnt work)

[mOk]

I have no functions in that include. It is basically HTML to display a form. It needs to be filled with their data ($getinfo=fetched in listadd.php) so that they can edit and update.

include (listedit.php)

<?php
$fields = mysql_list_fields($db, "contacts", $link);
$rows = mysql_num_fields($fields);

print "<form action='listupdate.php' method='POST'>\n";
print "<table width=80% border=1>\n";

//Spew out each field name and data in a row
for ($i = 0; $i < $rows; $i++)
{
$sid = $getinfo[id];
print "<tr>\n";
$fname = mysql_field_name($fields, $i);

$field = $getinfo[$i];
if (is_null($field))
$field = "x";
print "\t<td><font face=arial size=2/>".$fname."</font></td>\n";
print "\t<td><font face=arial size=2/><input type='text' size=20 value=\"".$field."\" name=$fname></td>\n";
// print "\t<td><font face=arial size=2/>$field</font></td>\n";
print "</tr>\n";
}

print "</table>\n";
print "<BR>";
print "\t&nbsp;<input type='submit' value='Update' name='submit'>";print "</form>\n";
mysql_close($link);
?>

UPDATE: The problem was that I was enumerating through the array but had only pulled it as ASSOC (instead of the default both). I changed my
$getinfo = mysql_fetch_array($result, ASSOC);
TO
$getinfo = mysql_fetch_array($result);