Say I have this SQL that joins two tables. When I print out the table those fields that are matching in the join query are printing out twice. Is their a way to only get them to print once since twice is redundant?
$result3 = mysql_query( "SELECT * FROM test LEFT JOIN login ON test.id = login.id WHERE test.registration = '49878sd'" );
$result3 = mysql_query( "SELECT * FROM test LEFT JOIN login ON test.id = login.id WHERE test.registration = '49878sd'" );