Tijden veranderen
Keuzelijst met mySql
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?php
$result = mysql_query("select * from users");
if ($result)
{
echo "<select name=\"ae\">";
while ($row = mysql_fetch_array($result))
{
echo "<option>";
print $row["aecode"];
echo "</option>";
}
echo "</select>";
// mysql_free_result($result);
}
?>
$result = mysql_query("select * from users");
if ($result)
{
echo "<select name=\"ae\">";
while ($row = mysql_fetch_array($result))
{
echo "<option>";
print $row["aecode"];
echo "</option>";
}
echo "</select>";
// mysql_free_result($result);
}
?>
Sjaan
<option value="1">abc</option>
<option value="2">def</option>
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
<?php
// wat Burdy zei, maar dan in een scriptvoorbeeld:
if (!($result = mysql_query ("select * from users"))) {
trigger_error (mysql_error ());
}
else {
echo '<select id="ae" name="ae">';
while ($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['aecode'] . '">' . $row['aecode'] . '</option>';
}
echo '</select>';
}
?>
// wat Burdy zei, maar dan in een scriptvoorbeeld:
if (!($result = mysql_query ("select * from users"))) {
trigger_error (mysql_error ());
}
else {
echo '<select id="ae" name="ae">';
while ($row = mysql_fetch_array($result)) {
echo '<option value="' . $row['aecode'] . '">' . $row['aecode'] . '</option>';
}
echo '</select>';
}
?>
edit: haakje toegevoegd :-)
Gewijzigd op 17/12/2005 13:16:00 door Jan Koehoorn
Niet dit
if (!($result = mysql_query ("select * from users"))
Maar
if (!($result = mysql_query ("select * from users")))