|
|
Posted by Wendy Hoovens on 09/29/13 11:32
Hello everybody!
I'n new to PHP, did an Access course, but this is quite new. I'm not
planning todo alot of programming in the future but I like to finish
things, so here I go :)
From another script i took the date code to put this in a variable for
the select statement.
Unfortuneatly it does'nt give me the result, a row with the amount of
magazines per location.
After some googling this has probably something todo with fetch_rows but
I can't figure it out myself :(
Thannks alot for the advice and sorry for my bad English :)
Greetings, Wendy
<HTML>
<HEAD><TITLE>Overzicht films</TITLE></HEAD>
<BODY>
<h1 align=center>Overzicht</h1>
<?
require ('connect.inc');
?>
<form method=post>
Begindatum:
<select name=dag1>
<?
$i=0;
while ($i<31){
$i++;
echo "<option value=$i>$i</option>";
}
?>
</select>
<select name=maand1>
<?
$i=0;
while ($i<12){
$i++;
echo "<option value=$i>$i</option>";
}
?>
</select>
<select name=jaar1>
<?
$i=2004;
while ($i<2007){
$i++;
echo "<option value=$i>$i</option>";
}
?>
</select><br>
Einddatum
<select name=dag2>
<?
$i=0;
while ($i<31){
$i++;
echo "<option value=$i>$i</option>";
}
?>
</select>
<select name=maand2>
<?
$i=0;
while ($i<12){
$i++;
echo "<option value=$i>$i</option>";
}
?>
</select>
<select name=jaar2>
<?
$i=2004;
while ($i<2007){
$i++;
echo "<option value=$i>$i</option>";
}
?>
</select>
<input type=submit value=opvragen>
<input type=hidden value=1 name=opgevraagd>
</form>
<?
$start="$_POST[jaar1]"."-"."$_POST[maand1]"."-"."$_POST[dag1]";
$eind="$_POST[jaar2]"."-"."$_POST[maand2]"."-"."$_POST[dag2]";
?>
<hr>
<?
$result = mysql_query("SELECT location, COUNT(type) FROM bib WHERE type
=\"magazine\" AND datum>=\"$start\" AND datum<=\"$eind\" GROUP BY locatie");
echo "$result";
?>
</BODY>
</HTML>
[Back to original message]
|