I would check the value of $position to make sure it's what you want. Mike ----- Original Message ----- From: "Alex Behrens" <[EMAIL PROTECTED]> To: "Ron Jamison" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, March 27, 2002 9:14 PM Subject: Re: SELECT frmo two tables
> hey guys, > > this mysql line doesn't seem to work: > > SELECT SUM(s.groundballs) AS grounders FROM stats s LEFT JOIN rahs r ON > s.name = r.name WHERE (s.position = '$position') > > why not? is there somethign wrong with my syntax? it says this error: > "Supplied argument is not a valid MySQL result resource" > > Thanks! > -------------------------------------------- > -Alex "Big Al" Behrens > E-mail: [EMAIL PROTECTED] > Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) > Phone: 651-482-8779 > Cell: 651-329-4187 > Fax: 651-482-1391 > ICQ: 3969599 > Owner of the 3D-Unlimited Network: > http://www.3d-unlimited.com > Send News: > [EMAIL PROTECTED] > ----- Original Message ----- > From: "Ron Jamison" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, March 27, 2002 6:21 PM > Subject: RE: SELECT frmo two tables > > > > If you need to do a join: > > http://www.mysql.com/doc/J/O/JOIN.html > > > > However I don't see much logic in what you're doing. Stats should not > > include information that exists in another table, such as name and team. > > You need to decide what information will be unique (such as player > > number) or come up with a new field such as player ID to be used in > > associating tables with one another. > > > > E.g., associating by player number: > > > > Database.players: > > player_name, player_number, team, position > > > > Database.stats: > > player_number, penalty, groundballs, shots, faceoffs_won, > > faceoffs_lost, date > > > > SQL: SELECT SUM(stats.groundballs) AS grounders FROM players LEFT > > JOIN stats ON stats.player_number=players.player_number WHERE > > players.player_name='$name' > > > > > > -----Original Message----- > > From: Alex Behrens [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, March 27, 2002 4:00 PM > > To: [EMAIL PROTECTED] > > Subject: SELECT frmo two tables > > > > > > Hey All, > > > > I am having problems working on a script and need some advise. Here's my > > problem. I have two tables with teh following variables: > > > > rahs table: > > name, number, team, position > > > > stats table: > > name, team, penalty, groundballs, shots, faceoffs_won, faceoffs_lost, > > date > > > > and I need to make it so using a pulldown menu I can select player stats > > by their position but since the position variable isnt in both tables is > > it possbile to do a select command using a variable from one table for > > another table? > > > > Here's my syntax, but i dont know if it works: > > > > $groundballsquery = mysql_query("SELECT SUM(groundballs) AS grouders > > FROM stats WHERE (position = '$position') FROM rahs"); > > > > is it possible to do a WHERE command with a FROM command? > > > > Thanks! > > -------------------------------------------- > > -Alex "Big Al" Behrens > > E-mail: [EMAIL PROTECTED] > > Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) > > Phone: 651-482-8779 > > Cell: 651-329-4187 > > Fax: 651-482-1391 > > ICQ: 3969599 > > Owner of the 3D-Unlimited Network: > > http://www.3d-unlimited.com > > Send News: > > [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
