Frenske123
Terugkerende gebruiker
- Lid geworden
- 2 jul 2007
- Berichten
- 1.267
Is deze laatste post verkeerd geplaatst ?
Bekijk de onderstaande video om te zien hoe je onze site als een web app op je startscherm installeert.
Opmerking: Deze functie is mogelijk niet beschikbaar in sommige browsers.
<select id="selectweeknummer">
<option value="">Selecteer weeknummer</option>
<option value="41">41</option>
<option value="42">42</option>
<option value="43">43</option>
<option value="44">44</option>
</select>
<?php
$query = mysql_query ('select id aantal_personen, week_num, message from test WHERE week_num = 44 ') ;
?>
$query = "SELECT id, aantal_personen, week_num, message FROM test";
if (isset($_GET['weeknummer'])) {
$query .= " WHERE weeknummer = ". mysql_real_escape_string($_GET['weeknummer']);
}
$result = mysql_query($query);
// etc
<form action="" method="GET">
<select name="weeknummer">
<option>45</option>
<option>46</option>
<option>47</option>
</select>
<input type="submit" value="Wijzig weeknummer" />
</form>
if (isset($_GET['weeknummer')) {
$query = mysql_query ('select id, name, email, DATE_FORMAT(date, "%d-%M-%Y") as formatdatum, telefoonnummer, geslacht, aantal_personen, optellen, week_num, message from test ORDER BY date ') ;
"%d-%M-%Y"
while ($rows = mysql_fetch_assoc($query)) {
echo '<tr>
<td>'. $rows['formatdatum'] .'</td>
<td>'. $rows['week_num'] .'</td>
<td>'. $rows['name'] .'</td>
<td><a href="mailto:'. $rows['email'] .'">'. $rows['email'] .'</a></td>
<td>'. $rows['aantal_personen'] .'</td>
<td>'. $rows['geslacht'] .'</td>
<td>'. $rows['telefoonnummer'] .'</td>
<td>'. $rows['message'] .'</td>
</tr>';
}
?>
$sql = "
SELECT
id,
name,
email,
DATE_FORMAT(date, '%d-%M-%Y') AS formatdatum,
telefoonnummer,
geslacht,
aantal_personen,
optellen,
week_num,
message
FROM
test
ORDER BY
date";
<?php
$mail=$email;
while ($rows = mysql_fetch_assoc($query)) {
echo '<tr>
<td>'. $rows['date'] .'</td>
<td>'. $rows['week_num'] .'</td>
<td>'. $rows['name'] .'</td>
<td>".<a href="mailto:'. $rows['email'] .'">'. $rows['email'] .'</a>."</td>
$query = mysql_query( "select DATE_FORMAT(date, '%d-%M-%Y') as formatdatum , id, name, email, telefoonnummer, geslacht, aantal_personen, optellen, week_num, message from test ORDER BY date ") ;
if (isset($_GET['week_num'])) {
$query .= " WHERE week_num = ". mysql_real_escape_string($_GET['weeknummer']);
if (isset($_GET['week_num'])) {
$query .= " WHERE week_num = ". mysql_real_escape_string($_GET['weeknummer']);
}
$result = mysql_query($query);
// etc
$result = mysql_query($query);
echo '<td><a href="mailto:'. $rows['email'] .'">'. $rows['email'] .'</a></td>';
echo '
<tr>
<td>'. $rows['id'] .'</td>
<td>'. $rows['formatdatum'] .'</td>
<td>'. $rows['tijd'] .'</td>
<td>'. $rows['week_num'] .'</td>
<td><a href="mailto:'. $rows['email'] .'">'. $rows['email'] .'</a></td>
<td>'. $rows['message'] .'</td>
</tr>';
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';'
echo "<tr>
<td>". $rows['id'] ."</td>
<td>". $rows['datum'] ."</td>
//enz
echo '<tr>
<td>'. $rows['id'] .'</td>
<td>'. $rows['datum'] .'</td>
date_default_timezone_set('Europe/Amsterdam');
We gebruiken essentiële cookies om deze site te laten werken, en optionele cookies om de ervaring te verbeteren.