Rabu, 30 Juni 2010

cara penggunaan inner join

buat tanda php dulu kaya gini ya
kalo udah tulu script ini di dalam nya

$qry= mysql_query("select tabel_1.*, table_2.field_2, table_3.field_3 from table_1 left join table_2 on table_1.field=table_2.field left join table_3 on table_1.field=table_3.field");

while($sql= mysql_fetch_array($qry))
{
echo "field_1.field_2.field_3";

}

gitu deh trus di save dengan extention .php

gampang kan ..... slamat mencoba...^_^