Need help correcting query

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
calvinmicklefinger
Forum Newbie
Posts: 10
Joined: Thu May 03, 2007 2:50 pm

Need help correcting query

Post by calvinmicklefinger »

Hello,

I am practicing with the following code. It crashes when I insert the SELECT statement. I am thinking I am not connecting to the database, but am not sure. Can someone please advise?

Many thanks.

Kirk

**********************

Code: Select all

<?php
$usr = $_SERVER['PHP_AUTH_USER'];

$link = mysql_connect('mysql_host', 'mysql_dbusername', 'mysql_dbpassword');

$fields = mysql_list_fields("my_database", "my_table", $link);
$columns = mysql_num_fields($fields);

for ($i = 0; $i < $columns; $i++) {
	$var1 = mysql_field_name($fields, $i);

	// Page crashes when I introduce this line
	$var2 = SELECT $var1 FROM my_table WHERE my_fieldname = "'" . $usr . "'";

	echo "<input type='hidden' name=" . "'" . $var1 . "'" . " value=" . "'" . $var2  . "'" . "><br />" . "/n";
}
?>
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

Code: Select all

$var2 = SELECT $var1 FROM my_table WHERE my_fieldname = "'" . $usr . "'";
should be

Code: Select all

$var2 = "SELECT $var1 FROM my_table WHERE my_fieldname = '$usr'";
:wink: Might want to brush up on strings
calvinmicklefinger
Forum Newbie
Posts: 10
Joined: Thu May 03, 2007 2:50 pm

Post by calvinmicklefinger »

Thanks Jcart,

I am actually trying to perform the query and have the result assigned to $var2

The page no longer crashes, but $var2 is receiving the query as a string rather than the results of the query.

Code: Select all

$var2 = "SELECT $var1 FROM my_table WHERE my_fieldname = '$usr'";
echo "<input type='hidden' name=" . "'" . $var1 . "'" . " value=" . "'" . $var2  . "'" . "><br />" . "/n";
yields something like ...

Code: Select all

<input type='hidden' name='my_fieldname1' value='SELECT my_fieldname1 FROM my_table WHERE my_fieldname2 = 'auth_user_name''>
where I am actually expecting ...

Code: Select all

<input type='hidden' name='my_fieldname1' value='my_filedname1_value'>


What else am I missing?

Kirk
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Post by Weirdan »

Post Reply