0

navigation.php

<div id="navigation">

<div id="logo"><img src="images/logo2.png" width="160" height="60"></div>

<?php

include('include/con_database.php');

$result2 = mysql_query("SELECT menu_name FROM menu_order WHERE menu_id='1'");

while ($data2 = mysql_fetch_array($result2)){

echo '<td>'.$data2['menu_name'].'</td>'.'<br>';

}
?>

<div id='cssmenu'>
  <ul>
     <li class='active'><a href='index.php'>|&nbsp&nbsp&nbsp&nbspHome&nbsp&nbsp&nbsp&nbsp|</a></li>
     <li class='has-sub'><a href='index.php'>&nbsp&nbsp&nbsp&nbspProduct & Services&nbsp&nbsp&nbsp&nbsp|</a>
        <ul>
           <li class='onelayer'><a href='connection.php'>&nbsp&nbsp&nbsp&nbspConnection &nbsp&nbsp&nbsp&nbsp&nbsp <img src="images/arrow.png"></a>
              <ul>
                 <li class='onelayer'><a href='vsat.php'>&nbsp&nbsp&nbsp&nbspVSAT</a></li>
                 <li class='onelayer'><a href='terestrial.php'>&nbsp&nbsp&nbsp&nbspTerestrial</a></li>
              </ul>
           </li>
           <li class='onelayer'><a href='collaboration.php'>&nbsp&nbsp&nbsp&nbspCollaboration&nbsp&nbsp&nbsp <img src="images/arrow.png"></a>
              <ul>
                 <li class='onelayer'><a href='cloud.php'>&nbsp&nbsp&nbsp&nbspCloud</a></li>
                 <li class='onelayer'><a href='ucom.php'>&nbsp&nbsp&nbsp&nbspUnified &nbsp&nbsp&nbspCommunication</a></li>
                 <li class='onelayer'><a href='cc.php'>&nbsp&nbsp&nbsp&nbspContact Center</a></li>
                 <li class='onelayer'><a href='surveillance.php'>&nbsp&nbsp&nbsp&nbspSurveillance Center</a></li>
              </ul>
           </li>
           <li class='onelayer'><a href='solution.php'>&nbsp&nbsp&nbsp&nbspSolution&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp <img src="images/arrow.png"></a>
                <ul>
                </ul>
           </li>
        </ul>
     </li>
     <?php /* <li><a href='agent.php'>&nbsp&nbsp&nbsp&nbspAgent&nbsp&nbsp&nbsp&nbsp|</a></li> */ ?>
     <li><a href='aboutus.php'>&nbsp&nbsp&nbsp&nbspAbout Us&nbsp&nbsp&nbsp&nbsp|</a></li>
     <li><a href='contactus.php'>&nbsp&nbsp&nbsp&nbspContact Us&nbsp&nbsp&nbsp&nbsp|</a></li>
  </ul>
</div>


<div id="search">
<input type="text" name="search" placeholder="search.." value=""></div>
<div id="sbutton"><img src="images/search button.jpg"></div>
</div>

</div>

hello, I am trying to make this code shorter:

<?php

include('include/con_database.php');

$result2 = mysql_query("SELECT menu_name FROM menu_order WHERE menu_id='1'");

while ($data2 = mysql_fetch_array($result2)){

echo '<td>'.$data2['menu_name'].'</td>'.'<br>';

}
?>

so that I can place it in between the navigation. Is there any way to do so?

2
Contributors
5
Replies
20
Views
3 Years
Discussion Span
Last Post by Tpojka
0

Firstly, you should use padding. Now it is unreadable. Example:

<!DOCTYPE html>
<html>
<head>
<style>
li {
  display: inline;
}
a {
  padding-left: 25px;
  padding-right: 25px;
}
</style>
</head>
<body>
<ul>
<li>
<a href="http://www.w3schools.com">Visit W3Schools.com!</a>
</li>
<li>
<a href="http://www.w3schools.com">Visit W3Schools.com!</a>
</li>
<li>
<a href="http://www.w3schools.com">Visit W3Schools.com!</a>
</li>
</ul>

</body>
</html>

Secondly, your table is incorrect. You don't have at least <table> tags and <tr> tags which are required. Make code correct to avoid some bugs.

Still don't know what are you trying.
And I don't think there is shorter way you can grab data from DB.

Post print screen of what you get and describe what would you like because this incorrect code can't be followed.

0

okay, besides the padding. what about the connection to the database.

I mean this code:

    <?php
    include('include/con_database.php');
    $result2 = mysql_query("SELECT menu_name FROM menu_order WHERE menu_id='1'");
    while ($data2 = mysql_fetch_array($result2)){
    echo '<td>'.$data2['menu_name'].'</td>'.'<br>';
    }
    ?>

That code retrieve "Home". how to make it shorter since it's too long.

0

Is my code already the shortest code to retrieve and print the data from DB ?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.