Looping Problem

Posted on 16th Feb 2014 07:03 pm by admin

I've got a client that has a database with about 200 events at any given time. I'm trying to loop through the dates based on a form and show the title of the event if the start date of the form matches the start date of the event. My code:

Code: [Select]// dates
$start_date = "2009-10-24";
$end_date = "2009-11-20";

// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to access database!");

// build query
$qry = "SELECT * FROM table ORDER BY start_date asc";
$result = mysql_query($qry) or die("Error during query!");

// loop through every day from $start_date to $end_date
for ($d=strtotime($start_date);$d<=strtotime($end_date);$d+=86400)
{
echo date("Y-m-d", $d) . "
";

while ($row = mysql_fetch_array($result))
{
//echo $row[event_id] . " - ";
if (strtotime($row[start_date]) == $d)
{
echo $row[title] . "
";
}
}
echo "

";
}

I get a list of dates from the start date to the end date but the only titles I see are for the first date even though other titles should be showing. I know this isn't optimal coding - (the record count will never go beyond a few hundred) - but I'm wondering why nothing beyond the first date is outputting. Any help would be appreciated.

Your Answer:

Login to answer

Other forums

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Creating XML with php
I need to creat an XML with php and have successfully produced a valid output.
The problem I hav

"GROUP BY" in arrays
Well i'm looking to do something i usually could do easily using COUNT and GROUP BY if it was a sql

help with image text
Hi ...

see i need the text of the name and number to start in the center and always be in the

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

am I using this for loop correctly
Dear buddies!

Right now I am generating a report with some details for all the dealers.

Help with lottery style system?
I'm working on a currency system for forums and it is going to have a type of lottery system built i

please hep to get values from a table row
can anyone tel me how I can select and get data from one row by pressing an Edit button in that row

error checking breaking my code
Hi there, OK first of all, big apologies for what I assume is really fundamental errors in the struc

user administration
Dear @all,

what I have to do to set the user defaults for new users. At the moment I woul