[SOLVED] hlep with mysql between function

mikejkellyuk · #1 (**permalink**) 11-30-2007, 07:27 AM

can anybody body tell me why this code is not working it is ment to seach between two date and bring back all the data between though dates

PHP Code:

  <?php
$link = mysql_connect("localhost","username","password");
if (!$link)  {  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("mikejkel_addressbook", $link);
$result = mysql_query("SELECT date, firstname, mon, tue, wed, thu, fri, workaweek FROM hoursworked WHERE date BETWEEN '2007/11/04' AND '2007/11/30'");
echo "<table border='1'>
<tr>
<th>date</th>
<th>firstname</th>
<th>mon</th>
<th>tue</th>
<th>wed</th>
<th>thu</th>
<th>fri</th>
<th>hours worked that week</th>
</tr>";
while($row = @mysql_fetch_array($result));  
{  
echo "<tr>";
echo "<td>" . $row['date'] . "</td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['mon'] . "</td>";
echo "<td>" . $row['tue'] . "</td>";
echo "<td>" . $row['wed'] . "</td>";
echo "<td>" . $row['thu'] . "</td>";  
echo "<td>" . $row['fri'] . "</td>";  
echo "<td>" . $row['workaweek'] . "</td>";   
echo "</tr>";
  }echo "</table>";
 
 
mysql_close($link);
?>

any help would be good
thanks
mike

ccoonen · #2 (**permalink**) 11-30-2007, 12:46 PM

What error is it throwing?

TeraTask · #3 (**permalink**) 11-30-2007, 12:49 PM

First, thanks for using code tags. I wish more people did. Second, there is no such statement as "not working" when it comes to programs failing to meet expectations. What is the error? What's happening? Provide details. Third, dates in sql are not of the form yyyy/mm/dd, but yyyy-mm-dd.

With more information on what your definition of "not working" is in this particular case I may be able to provide further assistance.

mikejkellyuk · #4 (**permalink**) 11-30-2007, 01:38 PM

i have got the code working the problem was it was showing the table but no data i fix that there was an error on this line of code
while($row = @mysql_fetch_array($result));
it should have read
while($row = @mysql_fetch_array($result))

thanks for the help it is much appreciated
mike

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

The Following 2 Users Say Thank You to ccoonen For This Useful Post:
mikejkellyuk (11-30-2007), TeraTask (11-30-2007)

The Following User Says Thank You to TeraTask For This Useful Post:
mikejkellyuk (11-30-2007)