code help

[Anon]

I have referred to the PHP manual, php forums, and every source I can think of and cannot find the information I need. Please dont refer me to another source, but have pity on me and help me develop the code I need.

I'm trying to write code that figures out how many records are in a SQL query. The query finds a distinct value in a db. Then, later in the page there is a drop box. I need a loop that displays thses distinct values in an <option>$value</option>. Please help a beginning coder. Thanks in advance!

[Anon]

$checkrows = $sql->rows;
echo"$checkrows";

[Anon]

Here is an example of doing that with mysql. If you are using another db you will have adjust it to your database.

<?
mysql_connect ($host, $user, $password);
mysql_select_db($your_db);
$result = mysql_query("select your_value from your_table");
echo "<select name=\"your_select\">";
while ($row = mysql_fetch_assoc ($result))
{
&nbsp;&nbsp;&nbsp;echo "<option>".$row["user_id"]."</option>";
}
echo "</select>";
mysql_free_result ($result);
?>

[Anon]

Oops the line to echo the column value should be:

echo "<option>".$row["your_value"]."</option>";

[Anon]

and because there is always more than one solution, here comes my prefered one :-))

<?
if (! $link_id=mysql_pconnect($MySQL_Host, $MySQL_User, $MySQL_Passw))
{
echo "No Connection made to the DB Server";
exit;
}
if (!mysql_query("use " . $db_name, $link_id))
{
echo "The DB requested does not exist";
}

$query = "Select whatever you want";
$select_id = mysql_query($query, $link_id);
// Here comes what you need
$number_of_results = mysql_num_rows($select_id);

...

cya Rob