zoekresultaten geeft hij onder de pagefooter weer
alvast bedankt!
code:
<div id="content_wrapper">
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
if($_POST['submit'])
{
include "connect.php";
$woord = $_POST['zoek'];
$woord = strtoupper($woord);
$woord = strip_tags($woord);
$woord = trim ($woord);
$query = "SELECT * FROM producten WHERE nl LIKE '%$woord%' ORDER BY id";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr><td><strong>Nederlands</strong></td><td><strong>Engels</strong></td><td><strong>Frans</strong></td><td><strong>Duits</strong></td><td><strong>Spanje</strong></td><td><strong>Italiaans</strong></td><td><strong>Omschrijving</strong></td></tr>";
// 1 voor 1 de rijen tonen
while($record = mysql_fetch_object($sql)){
echo"<tr><td><a href=\"view.php?id=".$record->id."\">".$record->nl."</a></td><td> ".$record->en."</td><td> ".$record->fr."</td><td> ".$record->du."</td><td> ".$record->sp."</td><td> ".$record->it."</td><td> ".$record->omschrijving."</td></tr>";
}
}
?>
if($_POST['submit'])
{
include "connect.php";
$woord = $_POST['zoek'];
$woord = strtoupper($woord);
$woord = strip_tags($woord);
$woord = trim ($woord);
$query = "SELECT * FROM producten WHERE nl LIKE '%$woord%' ORDER BY id";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr><td><strong>Nederlands</strong></td><td><strong>Engels</strong></td><td><strong>Frans</strong></td><td><strong>Duits</strong></td><td><strong>Spanje</strong></td><td><strong>Italiaans</strong></td><td><strong>Omschrijving</strong></td></tr>";
// 1 voor 1 de rijen tonen
while($record = mysql_fetch_object($sql)){
echo"<tr><td><a href=\"view.php?id=".$record->id."\">".$record->nl."</a></td><td> ".$record->en."</td><td> ".$record->fr."</td><td> ".$record->du."</td><td> ".$record->sp."</td><td> ".$record->it."</td><td> ".$record->omschrijving."</td></tr>";
}
}
?>
</div>
<div id="page_footer2">
<script type="text/javascript"><!--
google_ad_client = "pub-9090824956837967";
//banner onder
google_ad_slot = "5036984600";
google_ad_width = 468;
google_ad_height = 60;
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>
<div id="page_footer">
<p>© 2008 <A HREF="http://www.horeca-unlimited.nl">horeca-unlimited</A>
<p><img src="logo horeca-unlimited.JPG" width="125" height="34" /></p></div>
</div>
Omdat je de <table> niet afsluit?
hoe sluit ik die?
</table>
Maar hij geeft de resultaten nu goed weer!!! Bedankt!!!