Search option in my data table

thempower · March 25, 2012

I have made a data table out of my mySQL table and I should have a search option.

Lik where you have 3 boxes on one line :

Naam - Date1 - Date2

Naam is just searching results with that value

You can insert Date1 and Date 2 and then it must search between those dates.

But what will it do if i only put 1 date ? Like 2011-12-23 and date2 open

will it then only show the dates from 2011-12-23 ? <html>

<body>

<?php

$username="";

$password="";

$database="";

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query = "SELECT middenoosten2.*, users.naam ".

"FROM middenoosten2, users ".

"WHERE middenoosten2.speler = users.inlog order by id asc";

$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

?>

Scores middenoosten : Zee en rivieren

<tr>

<th>Score 11/...</th>

<th>datum</th>

<th>percent</th>

</tr>

<?php

$i=0;

while ($i < $num) {

$f1=mysql_result($result,$i,"id");

$f2=mysql_result($result,$i,"naam");

$f3=mysql_result($result,$i,"score");

$f4=mysql_result($result,$i,"datum");

$f5=mysql_result($result,$i,"tijd");

$f6=mysql_result($result,$i,"percent");

$f7=mysql_result($result,$i,"crono");

?>

<tr>

</tr>

<?php

$i++;

}

?>

</body>

</html>

Thank you

thempower · March 25, 2012

<html>
<body>
<?php
$username="";
$password="";
$database="";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT middenoosten2.*, users.naam ".
"FROM middenoosten2, users ".
"WHERE middenoosten2.speler = users.inlog order by id asc";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<p><b>Scores middenoosten : Zee en rivieren</b></p>
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Id</font></th>
<th><font face="Arial, Helvetica, sans-serif">Naam</font></th>
<th><font face="Arial, Helvetica, sans-serif">Score 11/...</font></th>
<th><font face="Arial, Helvetica, sans-serif">datum</font></th>
<th><font face="Arial, Helvetica, sans-serif">uur</font></th>
<th><font face="Arial, Helvetica, sans-serif">percent</font></th>
<th><font face="Arial, Helvetica, sans-serif">duur</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"id");
$f2=mysql_result($result,$i,"naam");
$f3=mysql_result($result,$i,"score");
$f4=mysql_result($result,$i,"datum");
$f5=mysql_result($result,$i,"tijd");
$f6=mysql_result($result,$i,"percent");
$f7=mysql_result($result,$i,"crono");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
</tr>

<?php
$i++;
}
?>
</body>
</html>

excuse me for the wrong tag

Sign In

Search option in my data table

Recommended Posts

thempower

Link to comment

Share on other sites

thempower

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information