PHP show results on web page

[jetpacmidge]

Hi,

I am new to using PHP and MYSQL with Apache Web Server and am creating an interactive webiste for a local football team.

I have a table called members which is as follows :-
memberID
name
status
position

and on the php page wrote the following script :-

<?php
$query"SELECT * FROM members WHERE position='Under 12 Manager' ";

$result=mysql_query($query)
or die ("Couldn't execute query")
while ($row=mysql_fetch_array($result,MYSQL_ASSOC) )
{
echo"<p>Under 12s Managers are :- {$row['name']}</p>";
}
?>

webpage looks like :-

Under 12s Managers are :- Joe Blogs

Under 12s Managers are :- Fred Flintstone

How can I show the results from the query to show the following :-

Under 12s Managers are Joe Blogs and Fred Flintsone.

Thanks for any help to my problem.

Regards,

Andy M.

[TheDefender]

Something to this effect...

$mgrs = array();
while ($row=mysql_fetch_array($result,MYSQL_ASSOC) ) 
{ 
$mgrs[] = $row['name'];
}
$mgrsout = implode(" and ", $mgrs);
echo "Under 12s Managers are: ".$mgrsout;

[jetpacmidge]

Hi,

Thanks very much to help in resolving my problem.

Rgds,

Andy M.