[Resolved] Query SQL line help

[NZ_Kiwi]

What's this line all about, what does all this mean , resultgroup g where r.group_id = g.group_id

$result = mysql_query ("SELECT * from result r, resultgroup g where r.group_id = g.group_id and r.comp_id = $comp_id and g.regular_yesno = '0' and r.game_played = '1'");

this is the sql table for 'results'

result_id int(10) NOT NULL auto_increment,
group_id int(10) NOT NULL default '0',
comp_id int(10) NOT NULL default '0',
team1_id int(10) NOT NULL default '0',
team2_id int(10) NOT NULL default '0',
game_played int(2) NOT NULL default '0',
team1_score int(10) default NULL,
team2_score int(10) default NULL,
list_order int(10) default NULL,
weekday char(3) default NULL,

[planetsim]

Ok this is a MySQL Query what you see is SQL (Structure Query Language)

the r represents result
the g represents resultgroup

So this query if it wasnt shortened would look something like this

SELECT * from result, resultgroup where result.group_id =  resultgroup.group_id and result.comp_id = $comp_id and  resultgroup.regular_yesno = '0' and result.game_played = '1'"

Basically what its doing is gettings results from two tables.

[NZ_Kiwi]

as easy as that!!!

thanks