nested loop not working (need sort by date)

[catalepticstate]

Hi,
I do not know how to do that

set your check date variable as null
loop here
is check date the same?
yes, continue existing table
no, start a new table
set check date variable to current field value
end loop 

I know there is a if statement in there, but how do I check if the value.
I am a newbie in the world of php and mysql.

[catalepticstate]

so will

$row['date'] = NULL
if $row['date'] = $row['date'] {
Output table
}
else if $row['date'] = $row['date'] {
Output table
}

The problem with that is, its saying the same thing.

So if the date for first block is 2010-01-01 the matches with that date are the same then output table

but will I need a counter to move the date check up to the next one?

[criterion9]

So you would need to create a new variable. Then during your loop check if that variable is the same as your field value. I'm afraid I won't be much help without doing it for you until to grasp some of the basics. Try looking at some of the following tutorials to see if that helps. If you get rolling and get stuck again post back what you have coded and where you need help and I'm sure someone will be able to point you in the right direction.

http://www.w3schools.com/php/default.asp
http://php.net/manual/en/tutorial.php
http://www.tizag.com/phpT/

[catalepticstate]

Could you do it for me? I am not very confidant in doing this or give me a basic code and I could develop on that

[criterion9]

I don't mind helping guide someone towards the answer or assisting on a conceptual level...however, this is my "day job" so I don't generally like to do it for free. Sorry.

[catalepticstate]

:'(

[criterion9]

You could always hire a freelancer if you don't want to take the time to learn to do it yourself.

[catalepticstate]

I have hired someone, but he has not got back to me with this. I dont know what to do.

[criterion9]

HR issues are something I really can't help you with. Maybe check that your contract allows you to refute payment if an adequate solution is not presented.

[catalepticstate]

Hi,
The developer got back to me and fixed the issue.

He says it was the for loop that needed fixing, he did not touch the queries.