[Resolved] Dropdown help again ....

rathersurf

Sorry to post on this again. I posted on doing a drop down list using oracle functions some time ago. Now i need to make the drop down, a single drop down for mysql. I have started to change some of the oracle in the following code, but i still dont know what alot of the functions do yet. Can anyone help or point me in the right direction. I just need to change the functions from oracle to mysql ...

<form method="GET" action="list.php"> 
<select name="schoolchoice"> 
<? 
$conn = mysql_connect("localhost", "root", "password");
$sql = "Select * FROM book_list";
$result = mysql_query($sql, $conn);

if(OCIExecute($result)) 
{ 
while(OCIFetchInto($result, $row, OCI_ASSOC)) 
{ 
printf("<option value='%s'>%s</option>\n", htmlentities($row['SCHOOL']), htmlentities($row['NAME'])); 
} 
} 
?> 
</select> 
<input type="submit" /> 
</form>

Thanks in advance

kburger

I'd suggest starting here .

rathersurf

I dont see where there is a mysql statement for

OCIExecute

I assume that OCIFetchinto can be replaced with mysql_fetch_array

OCI_ASSOC can be replaced with MYSQL_ASSOC ..

Any more help or comments ???

Thanks once again... Its not that i dont look , its that i dont know what i am looking for.

kburger

Try this:

<form method="GET" action="list.php">
<select name="schoolchoice">
<? 
$conn = mysql_connect("localhost", "root", "password");
$sql = "Select * FROM book_list";
$result = mysql_query($sql, $conn);

while ($row = mysql_fetch_array($result)) {
	printf("<option value='%s'>%s</option>\n", htmlentities($row['SCHOOL']), htmlentities($row['NAME'])); 
}
?> 
</select>
<input type="submit" />
</form>

rathersurf

Thanks for the response kburger... I tried that and my list is still empty. Im not sure why. I have this to display it static in a table and the data showed with no problem.

//make the database connection
$conn = mysql_connect("localhost", "root", "password");
mysql_select_db("arlist", $conn);
//create a query
$sql = "Select * FROM schools";
$result = mysql_query($sql, $conn);
print "<table border='1' align='center' width='80%'>\n";
//get field names
print "<tr>\n";
while ($field = mysql_fetch_field($result))
	{
	print " <th>$field->name</th>\n";
	} //end while
print "</tr>\n\n";
//get row data as an associative array
while ($row = mysql_fetch_assoc($result)){
	print "<tr>\n";
	//look at each field
	foreach ($row as $col=>$val){
		print " <td>$val</td>\n";
		} //end foreach
		print "</tr>\n\n";
		}//end while
print "</table>\n";

Thanks Again

kburger

Your original post shows you selecting from a table named 'book_list'. Your most recent post shows you selecting froma table named 'schools'. I'm now assuming it should be 'schools', but all I had to go on was your original post.

I'm also assuming you have a couple of fields in that table named 'SCHOOL' and 'NAME'. If that's the case, just change book_list to schools in my code.

rathersurf

That is what i did. I have two tables in the database ... One is book_list and the other is schools. I ment for the first to be schools. Its not working with either table in the code. I posted the other code to show that when i display the data in a table it shows fine (from both tables) but when i try to put either tables data into a ddlist then nothing appears.

Thanks Again for you help

kburger

Let me know the EXACT structure of your tables. This is a simple problem to solve, but I need more info.

kburger

Oops. My bad. Forgot one line.

mysql_select_db("arlist");

Put this line after the mysql_connect() line.

Sorry about that.

rathersurf

arlist is the db.

here is the query i ran to create the schools table...

create table schools (
school varchar(4),
name varchar(40)
);

the book_list table data is going to eventually be filtered based on the school selection and some other selected criteria ...

kburger

This should work.

<form method="GET" action="list.php">
<select name="schoolchoice">
<? 
$conn = mysql_connect("localhost", "root", "password");
mysql_select_db("arlist");
$sql = "Select * FROM schools";
$result = mysql_query($sql);

while ($row = mysql_fetch_array($result)) {
    echo "<option value=\"" . htmlentities($row['school']) . "\">" . htmlentities($row['name']) . "</option>\n"; 
}
?> 
</select>
<input type="submit" />
</form>

rathersurf

Hey i really appreciate that. You are awesome... for future reference can you explain to me why it would work one way and not the other..

old
printf("<option value='%s'>%s</option>\n", htmlentities($row['SCHOOL']), htmlentities($row['NAME']));

new
printf("<option value='%s'>%s</option>\n", htmlentities($row['SCHOOL']), htmlentities($row['NAME']));

Thanks again :p

kburger

That actually wasn't the problem. I just changed it because of my personal preferences. The problems were

not selecting the database
querying the wrong table
using $row['FIELD'] when it was $row['field']
[/list=1]

rathersurf

cool ... i just looked back over the code and saw the differences ...

Thanks for the help .. it is much appreciated. Hopefully one day soon i will have enough php knowledge to contribute to the board...