Posted by Stefan Rybacki on 06/28/05 22:00

Domestos wrote:
> Hi,
>
> TIA...
>
> 1) Need to select all rows from table called fixtures where home_team and
> away_team is equal to team_code. What SQL select statement would do this?


What about reading SQL basics?

SELECT * FROM fixture WHERE away_team=team_code OR home_team=team_code

>
> 2) I have a variable called fixture_date in the format dd-MMM-yy (i.e.
> 02-Mar-05) how do I select the day/month/year into thier own variables using
> PHP?

Have a look at strtotime() in the php manual.

Regards
Stefan

>
> Thanks
> Andy Mak
>
>

[Back to original message]