why am i not getting a result?

[mattsolomon]

at the moment i have my page:

 

addevent.php

 

i have written:

   $q = "SELECT username "
       ."FROM ".TBL_USERS." ORDER BY ASC";
   $result = $database->query($q);

 

on the database.php page here is what query looks like:

  /**

    * query - Performs the given query on the database and

    * returns the result, which may be false, true or a

    * resource identifier.

    */

  function query($query){

      return mysql_query($query, $this->connection);

  }

 

then i want to display $result in a drop down menu so i wrote back on addevent.php:

 

<select name="Select1">
<option value="<? echo("$result"); ?>"><? echo("$result"); ?></option>
</select>

 

[flolam]

<select name="Select1">
<?php
while ($row = mysql_fetch_assoc($result)) 
{ 
echo '<option value="'.$row["column_name"].'">'.$row["column_name"].'</option>';
}
?>
</select>

 

of course you need to replace column_name with the name of the db column from which you want to insert the value.

 

[mattsolomon]

im still not getting a result?

 

 

i've echo'd $q and i get: SELECT * FROM client_details ORDER BY ASC

 

but $result is brining nothing?

[flolam]

Shouldn't your sql "order by" clause include a column?

like this: SELECT * FROM client_details ORDER BY column ASC

[mattsolomon]

thank you

 

[solved]