Jump to content

dynamic navigation with php from mysql


williamh69

Recommended Posts

hi guys i have the following db table  called topnavigation

id

name

url

title

 

this is the code to get the navigation from mysql

<?php
           include("mylibrary/login.php");
           $sql = mysql_query("SELECT  * FROM topnavigation");

           while($row = mysql_fetch_array($sql)){

           $id = $row['id'];
           $name = $row['name'];
           $url = $row['url'];
           $title = $row['title'];


           echo"<li>";
           echo"<a href='$url' title='$title'>$name</a>";
           echo"</li>";


          }
?>

But i have this error:

atal error: Cannot redeclare login() (previously declared in C:\wamp\www\sparklenshine\mylibrary\login.php:3) in C:\wamp\www\sparklenshine\mylibrary\login.php on line 7

 

thank your for help

Link to comment
Share on other sites

Looks like the problem is not with the quoted code, but that you've got two login() functions in one of the files or you're importing mylibrary\login.php twice. Try include_once() or require_once instead of include(). Also (has nothing to do with the issue at hand, but needs to be said), switch from the mysql library to mysqli() or pdo() - the mysql lib has been deprecated for quite a while and will be removed soon if it hasn't been already.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.