php-db | 2001062

[PHP-DB] Variable Variables in PHP From: Morgan Tocker (morgan.tocker <email protected>)
Date: 06/26/01

I am having trouble with variable variables;

I want to create a form as follows :-

<?

$result = mysql_query("SELECT * FROM name_and_email");
$num = mysql_numrows("$result");
if ($num!="0") {
    $i = 0;
    PRINT "<FORM action='test.php'>";
    WHILE ($i < $num) {
        $name = mysql_result($result,$i,name);
        $email = mysql_result($result,$i,email);
        $id = mysql_result($result,$i,id);
        PRINT "<INPUT type='text' name='name$id' value='$name'>";
        PRINT "<INPUT type='text' name='email$id' value='$email'><BR>";
        
        $i++;
    }
    PRINT "<INPUT type='submit'></FORM>";
}

?>

## THIS SHOULD SUBMIT SOMETHING LIKE THIS >>>>

test.php?name1=avalue&email1=avalueagain&name2=secondname&email2=secondemail

THE PROBLEM:
>From PHP with variable variables, how do I change $name1 and $email1 into -

## for all $name.$x values do this......
$sql = "UPDATE name_and_email SET name = '$name1', email = '$email1' WHERE
id = '$id'";

Many thanks if someone can help,
Morgan Tocker. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>