doesn't error, I just get 0 results back.
Thanks,
Chad Day
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I had a query that was working fine before for a
sports project .. basically, 3 tables .. one stored
goal data, one stored team data, and the other player
data. To get all the scoring data (player names,
jersey #'s), I left joined to the player table 3
different times (on GOAL, ASSIST1, and
I'm trying to write a polling application and display the results on an
admin screen.. my goal is to show all the answers for the poll questions and
display the # of votes for each. The query I have to do this is:
select pd.ANSWER_TEXT, pr.*, COUNT(*) as NUM from ft_pollresponses as pr
right
I'm trying to remove rows from one table where a column matches another
column in a seperate table..
I have mysql 3.22.32:
DELETE TemporaryUsers_ToMessWith.* FROM TemporaryUsers_ToMessWith,
Advantage_Backup WHERE Advantage_Backup.TempAccountNumber =
TemporaryUsers_ToMessWith.TempAccountNumber
been banging at this for a while, can't get my head around it.
3 tables, one called news that stores news items, one called comments that
stores user comments, one called authors that holds the author of the news
items name. I am trying to display the news item with the authors name, and
count
Sending this out again, haven't gotten any help yet.. anyone?
-Original Message-
From: Chad Day [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 14, 2001 9:38 AM
To: mysql
Subject: problems with a fairly basic join..
been banging at this for a while, can't get my head around it.
3
I have 2 tables:
bases, and properties
base has a ZIPCODE field in the table, as does the properties table.
I'm trying to find all bases that do NOT have a property in that zip code.
What I've tried is:
select distinct cb.*, cp.* from classified_bases as cb left join
classified_properties as
$newgoalquery = mysql_query(select players.PLAYERID, players.FIRSTNAME,
players.LASTNAME, COUNT(goals.SCORER) as TG FROM players, goals where
(goals.SCORER = players.PLAYERID) AND players.TEAMID = '$TEAMID' GROUP BY
PLAYERID ORDER BY players.LASTNAME);
I'm trying to fetch out the number of goals
I have 4 tables, named:
players - stores player id, name, team id
teams - teamid, teamname
goals - goals scored, player id, team id
penalty - penaltys accumulated, player id
What I'm trying to do is write a query to get the top 10 from any category
and display them. I can do them individually