plz help me here !!!

[webtuto]

hi

here im trying to post the outputs from the database in a <select>

here is the code --->

 

<?php 
$query="select * from groups order by id";  
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$cat=$row[group];
?>
<option name="<?php echo $cat; ?>"><?php echo $cat; ?></option>
<tr><td><input type="submit" value="Send" name="send"></tr>
</select></tr>

but it gives just 1 output from the table , i want it to list me all the results !!!! *!*

[revraz]

Use a while loop

[adam291086]

<?php 
$query="select * from groups order by id";  
$result=mysql_query($query);

while($row=mysql_fetch_array($result))
{
$cat=$row[group];

?>
<option name="<?php echo $cat; ?>"><?php echo $cat; ?></option>
<tr><td><input type="submit" value="Send" name="send"></tr>
</select></tr>
<?php
}
?>

 

I think that will work

[webtuto]

no it didnt work

and how to do that loop it tried but i failed

[revraz]

You want to put the OPTION tag in the while loop, but leave the SELECT and SUBMIT button out of it so it only gets placed once.

[Lumio]

<?php 
$query="select * from groups order by id";  
$result=mysql_query($query);

while($row=mysql_fetch_array($result))
{
$cat=$row[group];

?>
<option name="<?= $cat ?>"><?= $cat ?></option>
<?php
}
?>
<tr><td><input type="submit" value="Send" name="send"></tr>
</select></tr>

[webtuto]

thanks it works thanks a lot

[revraz]

Should change

 

<option name="<?= $cat ?>"><?= $cat ?></option>

 

to

 

<option name="<?php echo $cat ?>"><?php echo $cat ?></option>

 

[Lumio]

but use htmlentities() or htmspecialchars() for that category output.

 

@revraz

Why? <?= is nearly the same as <?php echo ...

[revraz]

If short tags are enabled, but too many posts here are solved just by telling them to use the full <?php

 

So assume short tags support is off.

 

 

 

@revraz

Why? <?= is the same as <?php echo ...

[Lumio]

Oh... okay thx for that... I didn't know that