mysql/php loop on date ...

pepelepew1962 · 04-10-2011, 08:31 PM

//
Hello, I am in great need for a loop on a group of records. Basically I need a loop on the date field and pull all those records for that date, then loop onto the next date in the table. If I had 3 records for 04/03/2011, dispaly them, then grab the next date, say 04/06/2011 and display all of those records. It is probably very simple, but not simple enough for me, can anyone help with this please.
//
//
tblTable02.fldName2 // Date Field
//
//
$result = mysql_query('SELECT tblTable01.fldName1, tblTable01.fldName2, tblTable01.fldName3, tblTable02.fldName1, tblTable02.fldName2 FROM tblTable01, tblTable02 WHERE (tblTable01.fldName1 = tblTable02.fldName1) ORDER BY tblTable01.fldName1, tblTable02.fldName2');
//

maeltar · 04-10-2011, 08:41 PM

could use a bit more info on the tables, can you give a better overview of the schema..

mjwalsh · 04-11-2011, 12:45 AM

I don't understand the need for this, can you explain it more? The way you explained it, you could just select all of them from the table and display them by order of the date field, IE:

SELECT * FROM tblTable01 ORDER BY fldName2 ASC

Assuming the dates are in proper formate and the field is set to date or datetime it will work fine and display in the dates order.

maeltar · 04-11-2011, 05:14 AM

If you look close there are 2 tables... thats why I asked form more info...

mjwalsh · 04-11-2011, 04:57 PM

I wish the fields and tables were named relevant to what they actually are, it'd be much easier.