Jump to content

How can i display three tables contents ??

yami007

By yami007
in PHP Coding Help

Recommended Posts

yami007 Regular Member

yami007

Posted
  • Author
Posted

sorry about that...

well, here is my page...

 

 

<?php include("connection.php"); ?>
<?php include("functions.php"); ?>

<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

	<?php if (!is_null($sel_subject)) { // subject selected ?>
		<title><?php echo $sel_subject['menu_name']; ?></title>
	    <?php } elseif (!is_null($sel_page)) { // page selected ?>
		<title><?php echo $sel_page['menu_name']; ?></title>
		<?php } elseif (!is_null($sel_link)) { // Song selected ?>
		<title><?php echo "<{$sel_link['menu_name']}"; ?></title>
		<?php } else {?>
		<title><?php echo "Welcome to Japan POP Site"; }?></title>

	<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
	<link href="stylesheets/public.css" media="all" rel="stylesheet" type="text/css" />
</head>
<body>
	<div id="header">
		<h1>POP !!</h1>
	</div>
	<div id="main">
<table id="structure">
<tr>
	<td id="navigation">
		<ul>
<?php // Navigation always displayed .
    $subject_set = get_all_subjects();
    while ($subject = mysql_fetch_array($subject_set)) {
    	echo "<li><a href=\"index.php?page=" . urlencode($subject["id"]) . "\">{$subject["menu_name"]}</a></li>";
    }
    ?>
    	</ul>
	</td>
	<td id="page">
		<?php if (!is_null($sel_subject)) { // subject selected ?>
		<h2><?php echo $sel_subject['menu_name']; ?></h2>
	    <?php } elseif (!is_null($sel_page)) { // page selected ?>
		<h2><?php echo $sel_page['menu_name']; ?></h2>
		<?php } elseif (!is_null($sel_link)) { // Song selected ?>
		<h2><?php echo $sel_link['menu_name']; ?></h2>
		<?php } else {?>
		<h2><?php echo "Welcome to Japan POP Site"; }?></h2>

<?php // Singers ..
    if (isset($_GET['page'])) {
    	$subject_pages = get_pages_for_subject($sel_subject['id']);
    	echo "<table border=\"3\"><tr>";
    	$rows = 0;
    while($page = mysql_fetch_array($subject_pages)) {
    	
	  	// echo "<table border=\"3\">";
	  		// $rows = 0;
	  		$rows++;
	  		   echo "<td align=\"center\"><a href=\"index.php?singer=" . urlencode($page["id"]) . "\"><img src=\"{$page["image"]}\"/><br />
	  		   	{$page["menu_name"]}</a><br />
	            </td>";
	            if ($rows %4 == 0) {
	            	echo "</tr><tr>";
	            }
	  		  
    }
     echo "</tr></table>";

?>
<?php  // Songs = Links
} elseif (isset($_GET['singer'])) {
        $page_links = get_links_for_page($sel_page['id']);
    while($link = mysql_fetch_array($page_links)) {
	  echo "<li><a href=\"index.php?song=" . urlencode($link["id"]) . "\">{$link["menu_name"]}</a></li>";
   }
    
?>
<?php // Songs = Content
     } elseif (isset($_GET['song'])) {
    $sub_pages = get_sub_pages_for_links($sel_link['id']);
    while($sub_page = mysql_fetch_array($sub_pages)) {
	   echo "<p>{$sub_page["content"]}<p/>";
   }
?>
<?php
   } else {
   	echo "<p>The website is under construction, come back later please !!</p>";
   }
?>	

	</td>
</tr>
</table>
</div>
	<div id="footer">Copyright 2008...</div>
</body>
</html>
yami007 Regular Member

yami007

Posted
  • Author
Posted

now here where i want to display three tables before that...

 

<?php // Songs = Content
     } elseif (isset($_GET['song'])) {
    $sub_pages = get_sub_pages_for_links($sel_link['id']);
    while($sub_page = mysql_fetch_array($sub_pages)) {
	   echo "<p>{$sub_page["content"]}<p/>";
          // Something here like echo "{$subject["menu_name"]} / {$page["menu_name"]} / {$link["menu_name"]}";
   }
?>

 

I hope you understand now, please help me with this..

thanks in advance

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.