[RESOLVED] Help adding column value

[tbuzz]

I have a recordset displayed on a page and have added a form to filter those results. When I make a drop down filled from the recordeset it shows every value from that recordset but if a value is present multiple times it shows multiple times. I snagged a bit of code from a demo that shows the value only once but it shows the value I want passed (id) not the value I want to show in the dropdown (name)

<select name="cid" size="1" id="cid">
<option value="">All</option>
<?php
$cidUnique = array();
do {

$cidUnique[].=$row_Recordset1['course_id']; ?> <?php
}
while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
$cidUnique=array_unique($cidUnique);
sort($cidUnique);
foreach ($cidUnique as $value) echo "<option value=" . "\"" . $value ."\"" . ">" . $value ."</option>";
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
mysql_data_seek($Recordset1, 0);
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select>

can someone help me add course.name so that is what shows in the dropdown.
I'm still learning and this wasn't explained well when I got it
Thanks

[djjjozsi]

if your only aim to display a dopdown list,
i share with you a little function which can make it:

<?php

function make_roll($table,$var,$field_)
{
	$fields=explode(",",$field_); /* Lets explode the third parameter using "," as a separator*/

	print '<select name="'.$var.'" size="1" id="'.$var.'">
		<option value="">All</option>';
	/*Lets create the mysql query, fo select the fields from the table using GROUP to make 
	the second field as unique*/
	$sql="SELECT $field_ FROM $table GROUP BY {$fields[1]} ORDER BY {$fields[1]} ASC";

	$r=mysql_query($sql);

	while ($res = mysql_fetch_assoc($r))  
	{
	/* its useful to use htmlspecialchars where you print the list's value*/
	echo "<option value=\"" .$res[$fields[0]] ."\">" . htmlspecialchars($res[$fields[1]]) ."</option>\r";
	}

	print '</select>';

}
?>

first parameter is the table name of your database, second will be the variable name of your list.

The third parameter contains two field name separated with a , sign :
-The first of this is the id usually, and the second is the value.

<?php
//an example
make_roll("courses" , "cid" , "course_id,course_name");
?>

of course you can use this function to make another dropdown's:

<?php
//an example
make_roll("persons" , "pid" , "person_id,person_name");
make_roll("cars_type" , "cars_id" , "car_id,car_type");
ect...
?>

[tbuzz]

Thanks for that, but I want to populate the dropdown from the query that is already displaying data on the page so that users can filter from relevant values. If I use another query the user can select values that aren't present in the original result set. If I use group by in the original query it loses a lot of the results that I want to show in the original result set.
I hope that makes sense

[djjjozsi]

Of course it has a sense. i like the normal while rather then do while.
As you can see, your ID field takes into the value part in your dropdown list,
and the content field takes as an option

<select name="cid" size="1" id="cid">
<option value="">All</option>
<?php

while ($row_Recordset1 = mysql_fetch_assoc($Recordset1))
{

/*....   after you print these values, you can make an array from it like this*/
$cidUnique[$row_Recordset1['course_id']]=$row_Recordset1['course_name'];
}

$cidUnique=array_unique($cidUnique);
sort($cidUnique);

foreach ($cidUnique as $value => $key) echo "<option value=" . "\"" . $value ."\"" . ">" . htmlspecialchars($key) ."</option>";

$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
	mysql_data_seek($Recordset1, 0);
	$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select>

[tbuzz]

Thanks again, this is very much appreciated. This works on the form but now it passes a differant course_id. eg the course_id should be 9 and it passes 3

[djjjozsi]

Hello,

sorry, but i did not see how the indexes changing after the sort.

asort could solve this problem.

<?php
	while ($row_Recordset1 = mysql_fetch_assoc($Recordset1))
	{
		$cidUnique[$row_Recordset1['course_id']]=$row_Recordset1['course_name'];
	}

$cidUnique=array_unique($cidUnique);
asort($cidUnique);
foreach ($cidUnique as $value => $key) echo "<option value=" . "\"" . $value ."\"" . ">" . htmlspecialchars($key) ."</option>";
$rows = mysql_num_rows($Recordset1);
if($rows > 0) {
	mysql_data_seek($Recordset1, 0);
	$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
?>
</select>

original
Array
(
    [1] => a
    [2] => a
    [3] => b
    [4] => c
    [5] => a
)

unique
Array
(
    [1] => a
    [3] => b
    [4] => c
)
after a asort:
Array
(
    [1] => a
    [3] => b
    [4] => c
)

Hello,
jjozsi.

[tbuzz]

Thank you so much for this, you're a superstar. Extra thanks for explaining it to me as well

[djjjozsi]

Your welcome 🙂