twee keer data uit database halen
ik heb een pagina die data via deze code uit de database haalt
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
2
3
4
5
6
7
8
9
10
11
12
13
<?php
$pid = is_int($_GET['id']) ? $_GET['id'] : 1;
$sql = "SELECT titel, content FROM pagina WHERE id = " . $pid . " LIMIT 1;";
$res = mysql_query($sql) or trigger_error(mysql_error());
$row = mysql_fetch_assoc($res);
?>
$pid = is_int($_GET['id']) ? $_GET['id'] : 1;
$sql = "SELECT titel, content FROM pagina WHERE id = " . $pid . " LIMIT 1;";
$res = mysql_query($sql) or trigger_error(mysql_error());
$row = mysql_fetch_assoc($res);
?>
//menu
<a href="id=1">link 1</a>
<a href="id=2">link 2</a>
Nu wil ik als je bijv. link 1 opent dat er nog een menu komt die ook weer data uit een andere tabel uit de database haalt...
dan krijg je zoiets
/index.php?id=2&menu2=1
Weet iemand hoe dat moet?
alvast heel erg bedankt!
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
<?php
$query='
SELECT *
FROM cms_pages';
$result=mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_array($result)){
if($_GET['navpage'] == $row['page']){
$style = 'open';
}else{
$style = 'closed';
}
if(!$_GET['navpage'] || $_GET['navpage'] != $row['page']){
echo '<a href="?navpage='.$row['page'].'"><img src="images/nav_'.$style.'.jpg" border="0"></a> '.$row['page'].'<br>';
}else{
echo '<a href="cms_index.php" target="_self"><img src="images/nav_'.$style.'.jpg" border="0"></a> '.$row['page'].'<br>';
}
if($_GET['navpage'] == $row['page']){
echo '<font face="Arial, Helvetica, sans-serif" size="1" color="#000000">';
$subj = explode(',', $row['subj']);
for($i=0; $i<count($subj); $i++){
if($subj[$i]!=''){
echo ' <font color="#000000">- <a href="?action=update&page='.$row['page'].'&subj='.$subj[$i].'" class="navlink">'.$subj[$i].'</a></font><br>';
}
}
echo '</font>';
}
}
echo '<br> <a href="?action=home" class="back">Return to index</a>';
?>
$query='
SELECT *
FROM cms_pages';
$result=mysql_query($query) or die(mysql_error());
while($row=mysql_fetch_array($result)){
if($_GET['navpage'] == $row['page']){
$style = 'open';
}else{
$style = 'closed';
}
if(!$_GET['navpage'] || $_GET['navpage'] != $row['page']){
echo '<a href="?navpage='.$row['page'].'"><img src="images/nav_'.$style.'.jpg" border="0"></a> '.$row['page'].'<br>';
}else{
echo '<a href="cms_index.php" target="_self"><img src="images/nav_'.$style.'.jpg" border="0"></a> '.$row['page'].'<br>';
}
if($_GET['navpage'] == $row['page']){
echo '<font face="Arial, Helvetica, sans-serif" size="1" color="#000000">';
$subj = explode(',', $row['subj']);
for($i=0; $i<count($subj); $i++){
if($subj[$i]!=''){
echo ' <font color="#000000">- <a href="?action=update&page='.$row['page'].'&subj='.$subj[$i].'" class="navlink">'.$subj[$i].'</a></font><br>';
}
}
echo '</font>';
}
}
echo '<br> <a href="?action=home" class="back">Return to index</a>';
?>
zo heb ik et in mijn pagina gedaan...
Voorbeeld
Gewijzigd op 01/01/1970 01:00:00 door Niek Berckmans