php_dave

Is this what you mean? select p.PlayerFirstName, p.playerLastname, count(t.playerID) from players p, tries t where p.playerid = t.playerid group by p.PlayerFirstName, p.playerLastname edit - bug!! Squashed!

What is this? phpbb3_('forum', 'table_prefix') a function?? Just as a guess i think you are just wanting to do phpbb3_forum as the table name no?

Hi, Something like this maybe? Not tested but along the right idea i think.. $group = ""; while ($data = dbFetchAssoc($result)) { if ($data['Item_Name'] != $group) { Echo header detail here $group = $data['Item_name']; } Echo mutilple details here... }

Hi, is the string size and position constant? If so I would do something like: $string = "Call Out Fee for 10:00 on 20/8/2007"; array[1] = substr($string, 17, 5); array[2] = substr($string, 26, 9); As i say this will only work if the string is consistant in length and there is probably a better way Cheers Dave

I knew it would be easy - I always overthink stuff!! Cheers mate

Hi all, Im struggling with something probably really easy!! but just cant work it out! I have an array that is populated like so 1, 1, 2007-08-16, 1, 2, 1 2, 1, 2007-08-16, 2, 2, 1 3, 1, 2007-08-16, 5, 6, 1 4, 2, 2007-08-16, 1, 3, 1 5, 2, 2007-08-16, 1, 5, 6 im trying cycle through this array and use the 2nd value as a group or header like below 1: 1, 2, 1 2, 2, 1 5, 6, 1 2: 1, 3, 1 1, 5, 6 I cant get close - any ideas? Cheers Dave