[SOLVED] Pulling from database in a form, beginner

[tj71587]

Hey Im very new to php, and I am trying to make a select menu in php, where the select menu pulls fields from a database.  Heres what I am using, can anyone tell me if I am even close?

 

include 'includes/config.php'
		include 'includes/opendb.php'

		$query = "Select * FROM Companies";
		$result = mysql_query($query);

		while($r=mysql_fetch_array($result))
			{	
				//the format is $variable = $r["nameofmysqlcolumn"];
				//modify these to match your mysql table columns
  
				$company=$r["Company"];
   
				//display the row
				echo "<option value="$company">$company</option>";
			}

		include 'includes/closedb.php'

 

I also tried removing the quotes around company in the value field and that didnt help.

[Jessica]

You're going to get errors with that.

Try:

echo "<option value=\"$company\">$company</option>";

Or:

echo '<option value="'.$company.'">'.$company.'</option>';

[tj71587]

Thanks, Notepad ++ recognized it in its syntax coloring, but I still get nothing in the web browser.  Any other suggestions?

[uwannadonkey]

include 'includes/config.php'

include 'includes/opendb.php'

 

 

both of those, have no ; at the end

[tj71587]

Thanks for the help, I feel like an idiot.