OK I've changed my program a bit, so disregard my previous message. I got a query to run in mysql that is exactly what I want. But when I try to run the query from php it errors out. So I'm thinking I'm not using the right function. Here's the incorrect thing that I'm using:
----------------------------------------
$result = mysql("hlstats",
SELECT
"hlstats_PlayerUniqueIds.uniqueId, hlstats_PlayerNames.name
FROM
hlstats_PlayerUniqueIds, hlstats_PlayerNames
WHERE
hlstats_PlayerUniqueIds.playerId = hlstats_PlayerNames.playerId
ORDER BY
hlstats_PlayerUniqueIds.uniqueId"))
-------------------------------------------
This is the error I receive:
Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/html/hl/test2.php on line 33
-------------------------------------------
I assume I would then do a mysql_result with the result, and somehow narrow it down to row I want. Let me explain this as I see it, and please tell me how off I am.
I'm selecting two fields from 2 different tables, and joining them using the 'playerId' field. This gives me a virtual table of 'uniqueId' and 'name' sorted by uniqueId. I could then search the result for one uniqueId and get the name associated with it, of course I haven't got that far...so any help with that are would also be very much appreciated. TIA!
-Mike
----------------------------------------
$result = mysql("hlstats",
SELECT
"hlstats_PlayerUniqueIds.uniqueId, hlstats_PlayerNames.name
FROM
hlstats_PlayerUniqueIds, hlstats_PlayerNames
WHERE
hlstats_PlayerUniqueIds.playerId = hlstats_PlayerNames.playerId
ORDER BY
hlstats_PlayerUniqueIds.uniqueId"))
-------------------------------------------
This is the error I receive:
Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/html/hl/test2.php on line 33
-------------------------------------------
I assume I would then do a mysql_result with the result, and somehow narrow it down to row I want. Let me explain this as I see it, and please tell me how off I am.
I'm selecting two fields from 2 different tables, and joining them using the 'playerId' field. This gives me a virtual table of 'uniqueId' and 'name' sorted by uniqueId. I could then search the result for one uniqueId and get the name associated with it, of course I haven't got that far...so any help with that are would also be very much appreciated. TIA!
-Mike