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
