xxreenaxx1 Posted February 14, 2011 Share Posted February 14, 2011 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>";// ?> Quote Link to comment Share on other sites More sharing options...
Skylight_lady Posted February 14, 2011 Share Posted February 14, 2011 try: echo "<option value='$nt["Sub_ID"]'>$nt["Sub_Name"]</option>"; don't forget the ' and " Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted February 14, 2011 Share Posted February 14, 2011 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"); Quote Link to comment Share on other sites More sharing options...
MatthewJ Posted February 14, 2011 Share Posted February 14, 2011 I also think you would want to quote the attribute echo "<option value='".$nt['Sub_ID']."'>$nt['Sub_Name']</option>"; Quote Link to comment Share on other sites More sharing options...
Skylight_lady Posted February 14, 2011 Share Posted February 14, 2011 yep.... mattew corrected my little error in my above code. Quote Link to comment Share on other sites More sharing options...
xxreenaxx1 Posted February 14, 2011 Author Share Posted February 14, 2011 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>"; } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.