PHsG Posted May 18, 2009 Report Share Posted May 18, 2009 (edited) Sveiki, tātad man ir problēma ar datu izvilkšanu ar vienu vaicājumu. Es vēlējos izvilkt datus no divām tabulām ar vienu vaicājumu, bet diemžēl man tas nesanāk... $res = mysql_query("SELECT tourneys.*, teams.id AS team_id,teams.name AS team_name FROM tourneys WHERE teams.userid = '$uid' and tourneys.id = '$id'"); $row = mysql_fetch_row($res); Edited May 18, 2009 by PHsG Quote Link to comment Share on other sites More sharing options...
Gints Plivna Posted May 18, 2009 Report Share Posted May 18, 2009 Tabulu savienojumu veidi Konkrēti Inner join droši vien būs tas, kas Tev nepieciešams. Gints Plivna http://datubazes.wordpress.com Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.