Jquery Tabs With Php & Mysql

[bravo14]

I am trying to build some jQuery tabs using PHP & MySQL so it has the following layout

 

<div id="tabs">
<ul>
	<li><a href="#tabs-1">Tab 1</a></li>
	<li><a href="#tabs-2">Tab 2</a></li>
	<li><a href="#tabs-3">Tab 3</a></li>
</ul>
<div id="tabs-1">
   tab 3 content
</div>
<div id="tabs-2">
	tab2 content
</div>
<div id="tabs-3">
	tab3 content
</div>
</div>

I can get the tabs, I just can't figure out the content

<?php
//get menu options from database
$menus_sql=mysql_query("SELECT * FROM `tbl_menus`");
if(mysql_num_rows($menus_sql)>0){
echo('<ul>');
while($menus_row=(mysql_fetch_assoc($menus_sql)){
 echo('<li><a href="#tabs-'.$menus_row['id'].'">'.$menus_row['menu_title'].'</a></li>');
}
echo('</ul>');
}
?>

 

Any idea how I can create the content

 

The table has the following layout

 

id

menu_title

menu_content

Edited October 25, 2012 by bravo14

[Jessica]

Where you previously wrote the word content? You'll put the content in there.

 

Rather than echo'ing in your loop, assign the information to various variables you can echo later.

[bravo14]

Don't want to sound stupid, how do you mean?

[Jessica]

<?php
$menu = '<ul>';
$content = '';

$menus_sql=mysql_query("SELECT * FROM `tbl_menus`");
if(mysql_num_rows($menus_sql)>0){
$menu .= '<ul>';
while($menus_row=(mysql_fetch_assoc($menus_sql)){
        $menu .= '<li><a href="#tabs-'.$menus_row['id'].'">'.$menus_row['menu_title'].'</a></li>';
 $content .= ' <div id="tabs-'.$menus_row['id'].'">'.$menus_row['menu_content'].'</div>';
}
$menu .= '</ul>';
}

echo "<div id="tabs">$menu $content</div>";
?>

 

not tested.

Edited October 25, 2012 by Jessica

[bravo14]

Thanks, took a bit tweaking, but all done