Member Avatar for davy_yg

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
  • 133 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by Tpojka
Member Avatar for Tpojka

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.

Member Avatar for davy_yg

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.

Member Avatar for Tpojka

It seems shortest way for retrieving data from DB.

Member Avatar for davy_yg

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.