Menunaam ophalen uit de DB

Lid · Topicstarter
Berichten: 1.561
Reputatie: 0
Punten: 0,00
Lid sinds: 2009
Laatst gezien: 12 jun 2025
13 mrt 2010, 15:40
Hallo,

Ik wil graag de menunamen ophalen uit de database. Hier kun je zien welke namen verandert moeten worden. De naam moet worden opgehaald uit de tabel users en de kolom titel 1 en titel 2. Ik gebruik de volgende code:
<a href="[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"$siteurl"[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700]];[/COLOR] ?>/home.dg">Home</a></li>
<li><a href="[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"$siteurl"[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700]];[/COLOR] ?>/top100.dg">Top 100</a></li>
[COLOR= #0000BB]<?php
    $sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `pagina1` FROM `users` WHERE `username` = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]pagina1[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700])
    {[/COLOR]
        [COLOR= #0000BB]$pagina1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<li><a href="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$siteurl[/COLOR] [COLOR= #007700].[/COLOR]  [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]/pagina1.dg">Extra Pagina 1</a></li>[/COLOR][COLOR= #007700];
    }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
        [COLOR= #0000BB]$pagina1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
    }[/COLOR]
?>
[COLOR= #0000BB]<?php
    $sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT `pagina2` FROM `users` WHERE `username` = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]pagina2[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700])
    {[/COLOR]
        [COLOR= #0000BB]$pagina2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]<li><a href="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$siteurl[/COLOR] [COLOR= #007700].[/COLOR]  [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]/pagina2.dg">Extra Pagina 2</a></li>[/COLOR][COLOR= #007700];
    }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
        [COLOR= #0000BB]$pagina2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700];
    }[/COLOR]
?>
[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$pagina1[/COLOR][COLOR= #007700];[/COLOR] ?>
[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$pagina2[/COLOR][COLOR= #007700];[/COLOR] ?>
<li><a href="[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"$siteurl"[/COLOR][COLOR= #007700];[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700]];[/COLOR] ?>/contact.dg">Contact</a>
Alvast bedankt!