Populating Drop Down Menu from MySql

Anon

Hi, i am trying to populate a drop down menu with data from a mysql table. I have a table called 'country' which contains a list of countries. I want a script that will select these countries from the mysql tale, and popluate them into a drop down menu. I have tried the following but it doesnt seem to work? Can anyone see whats wrong? Or has anyone have any better ways of doing such a thing?

Many thanks

Jonathan

=======

<SELECT NAME='country'>");

$result = mysql_query("SELECT * FROM country",$cn);
while (list($id, $country) = mysql_fetch_row($result)){
echo "<option value=$id>$country</option>";
}
mysql_free_result($result);

print("</select>");

Anon

Hallo Jonathon,

The following script is what I have been using assuming that CountryID is the primary key in my country table. Of course, you can use another variable:

echo "<select name = CountryID'>
$query = "select * from country";
$result = mysql_query($query);
while ($rec = mysql_fetch_object($result)){
if($rec->CountryID == $CountryID){$sel = "Selected";}
if($rec->CountryID != $CountryID){$sel = "";}
print "<option value='$rec->CountryID' $sel>$rec->CountryName </option>";
}
print "</select>";

Solomon

Anon

Still doesnt work... brings up this error inside the code;

Warning: Access denied for user: 'apache@localhost' (Using password: NO) in /usr/local/psa/home/vhosts/pagadoo.com/httpdocs/php/pagadoo_job_seeker_register.php on line 75 
 
Warning: MySQL Connection Failed: Access denied for user: 'apache@localhost' (Using password: NO)
in /usr/local/psa/home/vhosts/*.com/httpdocs/php/pagadoo_job_seeker_register.php on line 75 
 
Warning: MySQL: A link to the server could not be established in /usr/local/psa/home/vhosts/.com/httpdocs/php/pagadoo_job_seeker_register.php on line 75 
 
Warning: Supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/****.com/httpdocs/php/pagadoo_job_seeker_register.php on line 76

Anon

What did you write in mysql_connect()?

$connect = mysql_connect("localhost", "username", "password")

if you don't have password, leave it blank like "".

Anon

I include the details from a config.php file like this;

<?php
$title = "The Pagadoo! Job & Recruitment Network";
$DBhost = "localhost";
$DBuser = "username";
$DBpass = "password";
$DBname = "pagadoo";
$dt = date("m d y HⓂs");
$Header = "http://www.pagadoo.com/header.php";
$Footer = "http://www.pagadoo.com/footer.php";
$Start_Page = "http://www.pagadoo.com/php/index.php";
$log_ip = $REMOTE_ADDR;
$page = $PHP_SELF;
$to = "j.dunn5@ntlworld.com";

include($Header);

$cn = mysql_connect($DBhost,$DBuser,$DBpass) or die("Error Connecting To Database!");
mysql_select_db ($DBname);