wrom toon hij mijn formulier niet?
Ik heb een klein probleempje hij toont het formuliertje niet?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?
$query2 = "SELECT * FROM links WHERE id = '".$_GET['pagina']."'";
$sql2 = mysql_query($query2);
while($record = mysql_fetch_object($sql2)) {
echo'<form method="post">';
echo'Linknaam:<br>';
echo'<input name="naamlink" size=50 value="'.$record->linknaam.'" </font></p><br /></br>';
echo 'Naar welke pagina:<br>';
echo '<select name="product">';
echo'<option value="'.$record->id.'">'.$record->paginanaam.'</option>';
echo '</select>';
echo '<br>';
echo 'Hoeveelste plaats:<br>';
echo'<input name="hoeveelste" size=50 value="'.$record->plaats.'" style="border: 1px solid #000000; background-color: #FFFFFF; font-family:Verdana; font-size:8 pt" ></font></p><br />';
echo '</select>';
echo '<font face="Verdana" size="1">';
echo '<input name="hidden" size=50 value="'.$record->id.'" style="border: 1px solid #000000; background-color: #FFFFFF; font-family:Verdana; font-size:8 pt" >';
echo '<input type="submit" Value="Toevoegen" name="voeglink" float: right; font-family:Verdana; font-size:8 pt"></font></p>';
echo '</form>';
}
?>
$query2 = "SELECT * FROM links WHERE id = '".$_GET['pagina']."'";
$sql2 = mysql_query($query2);
while($record = mysql_fetch_object($sql2)) {
echo'<form method="post">';
echo'Linknaam:<br>';
echo'<input name="naamlink" size=50 value="'.$record->linknaam.'" </font></p><br /></br>';
echo 'Naar welke pagina:<br>';
echo '<select name="product">';
echo'<option value="'.$record->id.'">'.$record->paginanaam.'</option>';
echo '</select>';
echo '<br>';
echo 'Hoeveelste plaats:<br>';
echo'<input name="hoeveelste" size=50 value="'.$record->plaats.'" style="border: 1px solid #000000; background-color: #FFFFFF; font-family:Verdana; font-size:8 pt" ></font></p><br />';
echo '</select>';
echo '<font face="Verdana" size="1">';
echo '<input name="hidden" size=50 value="'.$record->id.'" style="border: 1px solid #000000; background-color: #FFFFFF; font-family:Verdana; font-size:8 pt" >';
echo '<input type="submit" Value="Toevoegen" name="voeglink" float: right; font-family:Verdana; font-size:8 pt"></font></p>';
echo '</form>';
}
?>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2
3
4
5
6
7
8
9
10
11
12
13
14
15
<?
$sql = 'SELECT veld FROM tabel WHERE veld ="voorwaarde"';
$res = mysql_query($sql,$link);
if ($res && mysql_num_rows($res) >=1)
{
while ($row = mysql_fetch_array($res))
{
echo 'Rij<br>';
}
} else {
echo 'Geen rijen gevonden!';
}
?>
$sql = 'SELECT veld FROM tabel WHERE veld ="voorwaarde"';
$res = mysql_query($sql,$link);
if ($res && mysql_num_rows($res) >=1)
{
while ($row = mysql_fetch_array($res))
{
echo 'Rij<br>';
}
} else {
echo 'Geen rijen gevonden!';
}
?>
maar ik zou willen dat hij bij die select option die paginanaam niet van tabel links maar van tablen paginas haalt hoe is da mogelijk?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?
$query2 = "SELECT * FROM links WHERE id = '".$_GET['edit']."'";
$sql2 = mysql_query($query2)or die(mysql_error());
while($record = mysql_fetch_object($sql2)) {
echo'<form method="post">';
echo'Linknaam:<br>';
echo'<input name="naamlink" size=50 value="'.$record->linknaam.'" </font></p><br /></br>';
echo 'Naar welke pagina:<br>';
echo '<select name="product">';
echo'<option value="'.$record->id.'">'.$record->paginanaam.'</option>';
echo '</select>';
echo '<br>';
echo 'Hoeveelste plaats:<br>';
echo'<input name="hoeveelste" size=50 value="'.$record->plaats.'" style="border: 1px solid #000000; background-color: #FFFFFF; font-family:Verdana; font-size:8 pt" ></font></p><br />';
echo '</select>';
echo '<font face="Verdana" size="1">';
echo '<input type="hidden" name="hidden" size=50 value="'.$record->id.'" style="border: 1px solid #000000; background-color: #FFFFFF; font-family:Verdana; font-size:8 pt" >';
echo '<input type="submit" Value="Toevoegen" name="voeglink" float: right; font-family:Verdana; font-size:8 pt"></font></p>';
echo '</form>';
}
?>
$query2 = "SELECT * FROM links WHERE id = '".$_GET['edit']."'";
$sql2 = mysql_query($query2)or die(mysql_error());
while($record = mysql_fetch_object($sql2)) {
echo'<form method="post">';
echo'Linknaam:<br>';
echo'<input name="naamlink" size=50 value="'.$record->linknaam.'" </font></p><br /></br>';
echo 'Naar welke pagina:<br>';
echo '<select name="product">';
echo'<option value="'.$record->id.'">'.$record->paginanaam.'</option>';
echo '</select>';
echo '<br>';
echo 'Hoeveelste plaats:<br>';
echo'<input name="hoeveelste" size=50 value="'.$record->plaats.'" style="border: 1px solid #000000; background-color: #FFFFFF; font-family:Verdana; font-size:8 pt" ></font></p><br />';
echo '</select>';
echo '<font face="Verdana" size="1">';
echo '<input type="hidden" name="hidden" size=50 value="'.$record->id.'" style="border: 1px solid #000000; background-color: #FFFFFF; font-family:Verdana; font-size:8 pt" >';
echo '<input type="submit" Value="Toevoegen" name="voeglink" float: right; font-family:Verdana; font-size:8 pt"></font></p>';
echo '</form>';
}
?>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
<?php
$sql = "
SELECT
links.id,
links.linknaam,
links.plaats,
paginas.naam
FROM links, paginas
WHERE id = '".$_GET['edit']."'
AND links.pagina_id = paginas.id";
?>
$sql = "
SELECT
links.id,
links.linknaam,
links.plaats,
paginas.naam
FROM links, paginas
WHERE id = '".$_GET['edit']."'
AND links.pagina_id = paginas.id";
?>
$record->link.id??
AND links.pagina_id = paginas.id";