|
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
>
>
Navigation:
[Reply to this message]
|