Drop Down box using Session

[xxreenaxx1]

How would you do a drop down box using session

 

So far I have

 

<?php 

$_SESSION['username']; 



$query="SELECT DISTINCT u.Use_Name, u.Use_ID, u.Use_Name, us.Sub_ID, s.Sub_Name
FROM user u, user_x_subject us, subject s
WHERE u.Use_Name = '$username'
AND u.Use_ID = us.Use_ID
AND s.Sub_ID = us.Sub_ID";



$result = mysql_query($query);


while($nt=mysql_fetch_array($result)){
echo "<option value=$nt[sub_ID]>$nt[sub_Name]</option>";

}
echo "</select>";// 
?>

[Skylight_lady]

try:

 

echo "<option value='$nt["Sub_ID"]'>$nt["Sub_Name"]</option>";

 

don't forget the ' and "

[BlueSkyIS]

this line does nothing. what are you trying to do?

 

$_SESSION['username']; // does nothing.

 

and unless there is some code you aren't showing, $username is empty here:

 

$query="SELECT DISTINCT u.Use_Name, u.Use_ID, u.Use_Name, us.Sub_ID, s.Sub_Name
FROM user u, user_x_subject us, subject s
WHERE u.Use_Name = '$username'
AND u.Use_ID = us.Use_ID
AND s.Sub_ID = us.Sub_ID";

 

... and you should check for query errors by updating the code as so:

 

$result = mysql_query($query) or die(mysql_error() . " IN $query");

 

[MatthewJ]

I also think you would want to quote the attribute

 

echo "<option value='".$nt['Sub_ID']."'>$nt['Sub_Name']</option>";

[Skylight_lady]

yep.... mattew corrected my little error in my above code.

[xxreenaxx1]

I want to use a session to get information from mySql.

 

Say Username and use this to do a query

SELECT DISTINCT u.Use_Name, u.Use_ID, u.Use_Name, us.Sub_ID, s.Sub_NameFROM user u, 
user_x_subject us, subject sWHERE u.Use_Name = '[b][size=14pt]$username'   [/size]  [/b] AND u.Use_ID = us.Use_ID
AND s.Sub_ID = us.Sub_ID

 

Now the code work

 

<?php 

MYSQL_CONNECT(localhost,'root','') OR DIE("Unable to connect to database"); 
@mysql_select_db(Examination) or die( "Unable to select database");

$query=("SELECT * FROM subject");

$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() ); 

while($row=mysql_fetch_array($result)){ 

echo "<OPTION VALUE=".$row['Sub_ID'].">".$row['Sub_Name']."</OPTION>";
}
?>