Unicode or Ascii Problem

[djkast]

What I'm trying to do is turn the output:

firstlastemailcountryaddressgender

into a MySQL INSERTable statement... Here is my code so far

if ($newuser) {

$query = mysql_query("select * from reg") or die (mysql_error());
$num = mysql_num_fields($query);
$num = $num - 1;
$i=1;
while ($i <= $num) {
$output = mysql_field_name($query, $i);
$extra1 = "$output, ";
$extra2 = "'\$$output', ";
$i++;
$output1 = $output1.$extra1;
$output2 = $output2.$extra2;
}
$extra2 = "--";
$output1 = $output1.$extra2;
$output2 = $output2.$extra2;
$output1 = ereg_replace(", --", " ", $output1);
$output2 = ereg_replace(", --", " ", $output2);

$sql= "INSERT INTO reg ($output1) VALUES ($output2)";
$query = mysql_query($sql) or die (mysql_error());

if ($query) {
echo "Registration Successful";
exit;
} else {
echo "Registration could not finish";
exit;

}

if i echo all my strings during the process i get these:

$sql = INSERT INTO reg (first, last, email, country, address, gender ) VALUES ('$first', '$last', '$email', '$country',
'$address', '$gender' )
$output1 = first, last, email, country, address, gender
$output2 = '$first', '$last', '$email', '$country', '$address', '$gender'

If i take the echod $sql from my html browser and paste it into my
code instead of... $sql= "INSERT INTO reg ($output1) VALUES ($output2)";
everything works! but my current code write to the database like this:

          id  first  last  email  country  address  gender

Edit Delete 29 $first $last $email $c $address $gend

So after countless hours of messing around with quotes and .'s I
believe that my $'s are not recognized as real variables but maybe
under some other ascii code or somethin (dont know to much about it)

[lostcarpark]

Try changing the line:

$extra2 = "'\$$output', ";

to:

$extra2 = "'".$$output."', ";

Hope this helps,

James

[djkast]

That turns my INSERT statement into:

INSERT INTO reg (first, last, email, birthdate, country, address, gender ) VALUES ('', '', '', '', '', '', '' )

[lostcarpark]

Hmmm, I'm not sure why that didn't work, but not to worry, I have another idea...

Change:

$sql= "INSERT INTO reg ($output1) VALUES ($output2)";

to:

$sql= eval("INSERT INTO reg ($output1) VALUES ($output2)");

James

[djkast]

Ok, here is my new code:

$sql= eval("INSERT INTO reg ($output1) VALUES ($output2)");
echo "<br>$sql<br>$output1<br>$output2<br>";
$query = mysql_query($sql) or die (mysql_error());

and here is my output

Parse error: parse error in /www/register.php(20) : eval()'d code on line 1

first, last, email, birthdate, country, address, gender
'$first', '$last', '$email', '$birthdate', '$country', '$address', '$gender'
Query was empty

[lostcarpark]

You know, I'm really not paying attention today...

eval("$sql=\"INSERT INTO reg ($output1) VALUES ($output2)\";");

James

[djkast]

same error as above,
thanx for the effort tho...
anything else you can think of?