ziedinjsh Posted February 2, 2011 Report Share Posted February 2, 2011 Sveiki! Vēlos izveodt user talk system.. nekā tur daudz nebūs tikai messige teksts. jautājums man ir par datu ievadīšanu mysql un pēc tam nolasīšanu. no talk ievadīsies: id, user_id, message, date, time. kā pēc tam izvadīt no datu bāzes papildus vēl user_name, user_photo kas atrodas citā tabula? Link to comment Share on other sites More sharing options...
labaiss Posted February 2, 2011 Report Share Posted February 2, 2011 inner join - ja nekļūdos Link to comment Share on other sites More sharing options...
forSilence Posted February 2, 2011 Report Share Posted February 2, 2011 Es izmantotu LEFT JOIN Link to comment Share on other sites More sharing options...
ziedinjsh Posted February 2, 2011 Author Report Share Posted February 2, 2011 (edited) es īsti nestādos priekšā kā tas izkatās pilnā kodā $data=mysql_fetch_array(mysql_query("SELECT * FORM talk WHERE id='$id' LEFT JOIN users WHERE user_id='$user_id'")); Edited February 2, 2011 by ziedinjsh Link to comment Share on other sites More sharing options...
Recommended Posts