How to store data from one db in hidden fields and enter in a second db

[uranuskid]

Hey guys,

I need help with following issue: I have a db where userinfos are stored. The script connects to this db in order to check whether the user is logged in. Then I have a from where people enter s.th to be stored in another db. The form transports the username as a hidden field. That's all fine, but once I want to store more info in hidden fields I somehow can't get that.Here is the code:

<?

	include_once ("auth.php");
	include_once ("authconfig.php");
	include_once ("check.php");	
	
	$username = $check["uname"];	
	
	$result = mysql_query("SELECT email, phone, mobile FROM signup WHERE uname= '[$username]'")
                        or die("SELECT error: ".mysql_error());     // catch any error
	$row = mysql_fetch_array($result);
                $email = $row["email"];
	
?>

Later I want to get these results and use them in a hidden field like that:

<input type="hidden" name="username" value="<? print $username ?>">
<input type="hidden" name="email" value="<? print $email ?>">

The username is fine, but nor the email.

[code green]

[PHP]$email = $row["email"];[/PHP]Does the $email variable actualy contain a value?

[uranuskid]

[PHP]$email = $row["email"];[/PHP]Does the $email variable actualy contain a value?

Hey there,

Yeah, the $email variable should contain the value mailadress from the respective db.
Is it that I have to write the query and the the print in one php quote?

Thx,
Frank

[code green]

Yeah, the $email variable should contain the value mailadress from the respective db

No. I asked DOES it contain a value. Without any debugging you have no idea what is happening. .[PHP]echo $email;[/PHP]Anyway I have spotted a syntax [HTML]<input type="hidden" name="username" value="<? print $username ?>">
<input type="hidden" name="email" value="<? print $email ?>">[/HTML]There is no semi-colon after the php lines.

[uranuskid]

Yeah, the $email variable should contain the value mailadress from the respective db

No. I asked DOES it contain a value. Without any debugging you have no idea what is happening. .[PHP]echo $email;[/PHP]Anyway I have spotted a syntax [HTML]<input type="hidden" name="username" value="<? print $username ?>">
<input type="hidden" name="email" value="<? print $email ?>">[/HTML]There is no semi-colon after the php lines.

hey there,

I solved the issue:
I did a general query instead of a column query. Seelct *
Also,Instead of mysql_fetch_row I used mysql_fetch_ass oc($result)
and returned the email variable as
[PHP]$email = $row['email'][/PHP]

Thanks for advising me to debugg!

Frank