Retrieving database problem

[wenxi]

User choose on ID and submit.

 

I use the URL query method to get the ID and rest of the profile like first_name, last_name,

I tried something like this

 

$query = "SELECT * FROM user where user_id= $ID";

echo $_get['first_name'];

 

but it doesnt show, how come?

[r-it]

$query = "SELECT * FROM user where user_id= '$ID'";

[wenxi]

no difference after editing ='$ID'

[r-it]

can you show us more of your code because that single line does not help

[wenxi]

<?php

$ID = $_GET['listing'];

 

echo "You have clicked $ID";

$first = $_GET['first_name'];

?>

 

<?php //connect to database here

$dbhost1 = 'localhost';

$dbuser1 = 'root';

$dbpass1 = '';

 

$conn1 = mysql_connect($dbhost1, $dbuser1, $dbpass1) or die(mysql_error());

 

$dbname1 = 'studportal';

mysql_select_db($dbname1);

 

$query = "SELECT * FROM user where user_id= '$ID'";

 

$result = mysql_query ($query) ;

 

 

echo $_get['first_name'];

//echo $first;

/* You can add order by clause to the sql statement if the names are to be displayed in alphabetical order */

 

?>

 

 

if you need the full page, i can email to you

[r-it]

use this instead of the $_get['first_name']

 

$query = "SELECT * FROM user where user_id= '$ID'";

$result = mysql_query ($query) ;

while($rec = mysql_fetch_array($result))
{
echo $rec['first_name'];
}

[wenxi]

Thanks I've Got IT!

 

Thanks alot

[wenxi]

now having unknown errors, syntax error

[AndyB]

now having unknown errors, syntax error

 

Post your code. Explain exactly what error messages you get.

[wenxi]

its say line 182 syntax error...when my line 182 is blank

 

attached is the file.

 

[attachment deleted by admin]