[RESOLVED] Two DB query strings

[NZ_Kiwis]

$result45 = mysql_query ("SELECT * From results_players_data where result_id = $Result_ID and position = 'team1_wing2'");
$row45 = mysql_fetch_array($result45);
$playerid = $row43[player_id];

$result46 = mysql_query ("SELECT * From results_players where player_id = $playerid");
$row46 = mysql_fetch_array($result46);

I have two questions relating to this code, one - how would i make this one query??

Second. if playerid = nothing ie: there is no record found how can i stop it from doing the second search?

I guess the first part of this post may answer the second!!

[nnichols]

The following query is the simple join of your two previous queries -

SELECT *
FROM results_players_data
INNER JOIN results_players USING (player_id)
WHERE results_players_data.result_id = $Result_ID
AND results_players_data.position = 'team1_wing2'

I suggest you read the JOIN Syntax section in the manual.

Hope this helps 😉