How can I loop the db, and make a list of all values of a certain field?

zoobooboozoo

Hi... the title is a bit clumsy...
I'll give an example...

say I have a table:

[b]Name		Last Name	Grade[/B]
Jhon		dunno		100
Paul		semil		95
Sean		carnos		67

I want to make a loop that will basiclly take all values of the Name field and make them a list in a HTML-dropdown-box

any ideaS? :rolleyes:

devinemke

$result = mysql_query('SELECT name FROM table') or exit(mysql_error());
echo '<select name="name">';
while ($row = mysql_fetch_assoc($result))
{
	echo '<option>' . $row['name'] . '</option>';
}
echo '</select>';

zoobooboozoo

I want to send it to a form that will process it...
and will take other values out of the table that are related to the Specific name chosen...

I don't understand how to do it with the dropdown box

thanks in advance

Houdini

Well you could use sessions. First make sure that you start the session with a session_start() call then you send the drop down to the $SESSION array like this.

echo '<select name="name">'; 
while ($row = mysql_fetch_assoc($result)) 
{ 
    echo '<option>' . $row['name'] . '</option>';
   $_SESSION['name'][]= $row['name'] 
} 
echo '</select>';

Then on your form pase remember to start a session at the beginning of the script before you output anything and the $SESSION['name'][0] would have the first result from the dropdown box and then $SESSION['name'][1] would have the next and so on, does that help you any?

zoobooboozoo

I don't realy understand what you mean 🙁

anyways, I will make my objective more clear.

I want the processing page to output all the info out of all the fields of the name row.

🙂

Houdini

The above addition to your code will assign $SESSION variables to those values that are also going into the $row[] array, so it is an array of values that is indexed 0- ever how many values are returned from the query on the 'name' field. So on the next page you would start a session so you can use these values by using session_start() then the values that were placed into $SESSION[name'][0] would be the same as you saw in your drop down box, then $SESSION['name'][1] would now have the second $row['name'] value and you can do whatever you want to with them in this new or other scripts where you want to use them provided that you start a session in the other pages as well, to use $SESSION variables you must first start a session and to read session variables you must also first start a session.

Houdini

Take this code;

echo '<select name="name">';
while ($row = mysql_fetch_assoc($result))
{
    echo '<option>' . $row['name'] . '</option>';

}
echo '</select>';

and change it to

session_start();
while ($row = mysql_fetch_assoc($result))
{
    $_SESSION['name'][]= $row['name'] ;
header("nextpage.php");
}

Then create a new page called nextpage.php that looks like this

<?php
session_start();
print_r($_SESSION['name']);
?>

Then run the script and when the database has processed the data it will go to nextpage.php and print out all the values of $_SESSION['name'}.

zoobooboozoo

Did that, got errors

connected successfully to MySQL server.

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at c:\program files\easyphp1-8\www\main.php:9) in c:\program files\easyphp1-8\www\presentact.php on line 3

Warning: Cannot modify header information - headers already sent by (output started at c:\program files\easyphp1-8\www\main.php:9) in c:\program files\easyphp1-8\www\presentact.php on line 8

Warning: Cannot modify header information - headers already sent by (output started at c:\program files\easyphp1-8\www\main.php:9) in c:\program files\easyphp1-8\www\presentact.php on line 8

Houdini

Then on your form pase remember to start a session at the beginning of the script before you output anything and the $SESSION['name'][0] would have the first result from the dropdown box and then $SESSION['name'][1] would have the next and so on, does that help you any?

What does your form look like or the page where you are getting your data?

zoobooboozoo

I've completely lost you 🙁 🙁 🙁
maybe i'm just too dumb 🙁

I've tried changing the location of session start, and other pieces of code you gave me,
nada works, damn it ...

lost...

Houdini

Post the page presentact.php at least from the very start to line 15 or so at least to line 8 because that is where you errors are first showing up.

jazz_snob

zoobooboozoo wrote:
I want to send it to a form that will process it...
and will take other values out of the table that are related to the Specific name chosen...

I don't understand how to do it with the dropdown box

thanks in advance

use devinemke's code to populate the select element, then on the page that process the form you get the user name from $_POST and a query to get the info about that user:

$name = $_POST['name'];
$sql = "select * from table where name like '" . mysql_real_escape_string($name)  . "'";
$res = mysql_query($sql);
//etc

I hope I understood your question correctly...