list

[simjay]

Im not that good at PHP, have a look at this and i think ul find it funny but i aint got a clue. How would i make it list all the usernames?


<?php

$sql = "SELECT * FROM ALS_signup";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result)) {

$username = $newArray['username'];

echo" <select name='test'>
<option>$username</option>
</select>
";

}

?>

[SocoNaTromba]

You're missing the mysql_connect and database selection procedures.

[simjay]

I have that,

I just need to know how to get the list menu working

[firepages]

assumin you have a field in your database called 'username' then your code should work as-is , whats the problem you are having ?

[simjay]

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/****/public_html/members/messages.php on line 508

[firepages]

so $conn is not valid , do other queries fail or just this one ?

how do you connect to the database ? try just using
$result = mysql_query($sql) ;//without the $conn
if that fails show us your mysql_connect(); statement

[Rich Pedley]

after you have sorted out the mysql problem you may want to redo things slightly:

PHP Code:

<?php    
$sql = "SELECT * FROM ALS_signup";
$result = mysql_query($sql, $conn) or die(mysql_error());
echo "<select name='test'>";
while ($newArray = mysql_fetch_array($result)) {
    $username = $newArray['username'];
    echo" <option>$username</option>";
}
echo "</select>";
?>

otherwise you will be creating a select box for each username.

[degsy]

http://www.zend.com/php/beginners/php101-8.php#Heading5