selection

[ecabrera]

how do i make it so that all the items appear on eventname

 

<?php

require "scripts/connect.php";

$query = mysql_query("SELECT eventname FROM events");
while ($row = mysql_fetch_array($query)){

$eventname = $row['eventname'];

$form = "<form action='addcat.php' method='post'>
<table>
<tr>
<td>SELECT EVENT</td>
<td>
<select value='$eventname'>
<option value='$eventname'>$eventname</option>
</select>
</td>
</tr>
<tr>
<td>SELECT VENUE</td>
<td>
<select>
<option></option>
</select>
</td>
</tr>
<tr>
<td>SELECT CATEGORY</td>
<td>
<select>
<option>FOOTBALL</option>
<option>BASKETBALL</option>
<option>HOCKEY</option>
<option>DRAMA</option>
<option>MUSIC</option>
<option>DANCE</option>
<option>VISUAL ARTS</option>
</select>
</td>
</tr>
</table>
</form>";
echo "$form";
}
?>

[scootstah]

Come on, did you even try?

[ecabrera]

yes but it doesnt work i dont hat else to do

[scootstah]

I'll give you a hint:

$events = '';
while ($row = mysql_fetch_array($query)){
     $events .= '<option value="' . $row['eventname'] . '">' . $row['eventname'] . '</option>';
}

[ecabrera]

it triples my tables

[scootstah]

Because you have the tables inside the while loop.

[ecabrera]

thanks it works but what does .= mean you i know that what '. .' means but not .= is it need for this

[scootstah]

It means "append the stuff on the right to the variable on the left".

 

$foo = 'foo';
// $foo is "foo"

$foo .= 'bar';
// $foo is "foobar"

[ecabrera]

thanks