[RESOLVED] Dropdown from MySQL

[jnkwebdesignz]

I seem to be missing something, I've tried searching but after working on this all day without anything positive, I need help.

I am trying to pull from MySQL and create a dropdown to select from, my table is "agents" and the field I'm trying to get results from is "folder".

I am getting the dropdown but no results, I have tried numerous ways but nothing!

Here is what I have, please tell me where I've gone wrong.

<select name='folder'><option>Select Folder</option>

<?php
   // Retrieve all records and folders

   //Database Connection
   include ("db.inc.php");

   $query = "SELECT * FROM 'agents' ORDER BY folder ASC";

   $results = mysql_query( $query );

   while( $contact = mysql_fetch_object( $results ) )
      {
         // print out the info
         $id = $contact -> id;
         $agent = $contact -> agent;
         $folder = $contact -> folder;
         $filename = $contact -> filename;

   echo "<option value=\"{$row['folder']}\">{$row['folder']}</option>\n";

   }

   ?>
</select>

This is my complete page as I'm trying to "include" to another page.

[suntra]

First of all, where does $row come from ?

Shouldn't it be $contact ?

Second, you use extracted values, i.e. you defined $is, $folder, ...

So ...

echo "<option value=\"{$row['folder']}\">{$row['folder']}</option>\n"; 

Should be :

echo "<option value=\"$folder\">$folder</option>\n"; 
// OR
echo "<option value=\"" . $folder . "\">" . $folder . "</option>\n"; 
// OR
printf("<option value=\"%s\">%s</option>\n", $folder, folder); 

I've given up double quotes a while ago... I always (or almost) use single quotes... so, in my case, I would write :

echo '<option value="' . $folder . '">' . $folder . '</option>' . "\n"; 

Finally, when developping, I strongly suggest setting error_reporting (in php.ini) to E_ALL (by default it is E_ALL & ~E_NOTICE). That way, you will see error when you want to use an unset variable...

[jnkwebdesignz]

Well I made changes but its still not pulling the "options" from the database.

Here is what shows when viewing the source file

<select name='folder'><option value="folder">Select Folder</option>

</select>

And here is the changed code

<select name='folder'><option value="folder">Select Folder</option>

<?php 
   // Retrieve all records and folders 

   //Database Connection 
   include ("db.inc.php"); 

   $query = "SELECT * FROM 'agents' ORDER BY folder ASC"; 

   $results = @mysql_query( $query ); 

   while( $contact = @mysql_fetch_object( $results ) ) 
      { 
         // print out the info 

     $folder = $contact -> folder; 


     echo '<option value="' . $folder . '">' . $folder . '</option>' . "\n"; 
 }
   ?> 
</select>

[jnkwebdesignz]

Thanks Suntra for your guidance

It works now with the following script:

<select name='folder'><option value="folder">Select Folder</option>

<?php 
   // Retrieve all records and folders 

   //Database Connection 
   include ("db.inc.php"); 

   $query = "SELECT * FROM agents ORDER BY folder ASC"; 

   $results = mysql_query( $query );

   // print out the results
   if( $results )
   {
      while( $contact = @mysql_fetch_object( $results ) )
      {

     // print out the info 

     $folder = $contact -> folder; 

     echo '<option value="' . $folder . '">' . $folder . '</option>' . "\n"; 
 }
   }
   else
   {
      die( "Trouble getting contacts from database: " . mysql_error() );
   }

?>

</select>