splitting up returned results.

[paddycallaghan]

Hi All,

I have a sight display issue that is bugging me. I am querying three tables at once using JOINs on a unique shared id.

When i get my results i am getting 5 returned rows, this is fine. The only problem is that the first table has only one row so it is getting duplicated each time so i have 5 of the same information.

How can i get around this so that when i display it, i only display this information once and then loop through the remaining info where it differs

Thanks
Paddy

[leatherback]

Add an if statement:
If($i<>true)
{
// display data from table 1
$i == true;
}
// display the rest