Display Results from SQL with a foreach loop

Hey Guys,

I am having an issue with the following SQL Statement. I want to populate my drop down form box with information from my database.

Pretty much I want to have as many options as there are rows in my <select> drop down </select>

What I need pulled from the database is the following <option value="$rows['page_id']>' . $rows['page_title'] . '</option>";

Here is my code:
$sql = "Select * from content";
	//echo $sql . "<br>";
	
	$result= mysql_query($sql);
	
	$num_rows = mysql_num_rows($result);
	$rows = mysql_fetch_array($result);
	//echo "Total rows found is : " . $num_rows;
	
	for($i = 1; $i <= $num_rows; $i++) {
		echo $i;
		foreach ($rows as $page) {
			//echo $page;
			$cmspages = '<option value="' . $rows['page_id'] . '">' . $rows['page_title'] . '</option>';
		}
	}

Open in new window

George-TCCAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
this should do better:
$sql = "Select * from content";
      //echo $sql . "<br>";
      
      $result= mysql_query($sql); 
      $i = 0;
      
      $num_rows = mysql_num_rows($result);
      //echo "Total rows found is : " . $num_rows;
      
      while ($row = mysql_fetch_assoc($result))
      {
         $i++;
         $cmspages = '<option value="' . $row['page_id'] . '">' . $rows['page_title'] . '</option>';
         echo $cmspages;
      }

Open in new window

0
 
szewkamCommented:
well, the easiest way to loop through data set from db is while.
I'm not pretty sure this is what you want, but try :)
<?
$sql = "Select * from content";
        //echo $sql . "<br>";
        
        $result= mysql_query($sql);
        
        $num_rows = mysql_num_rows($result);
        //echo "Total rows found is : " . $num_rows;
        
        while ($rows = mysql_fetch_array($result)
                        //echo $page;
                        $cmspages = '<option value="' . $rows['page_id'] . '">' . $rows['page_title'] . '</option>';
        }

Open in new window

0
 
George-TCCAuthor Commented:
Great it works perfectly!

Thanks for that! Enjoy the points - Well earned! :)
0
All Courses

From novice to tech pro — start learning today.