$query = "SELECT Q.callsign, M.qsl_ort FROM qsl_reg AS Q, qsl_mottagare AS M WHERE Q.m_id = M.id AND Q.m_id = 15 AND Q.medlem='JA' ORDER BY Q.callsign"; $result = mysql_query($query) or die(mysql_error()); $antal = mysql_num_rows($result); while (list ($call, $qsl_via) = mysql_fetch_row ($result)) { echo $call." "; } ?>
Lista med radioamatörer med markeringen Okänd qslmottagare:$query = "SELECT `callsign` FROM `qsl_reg` WHERE `medlem` LIKE 'JA' AND `m_id` = 76 ORDER BY `callsign`"; $result = mysql_query($query) or die(mysql_error()); $antal = mysql_num_rows($result); while (list ($call) = mysql_fetch_row ($result)) { echo $call." "; } db_close(); ?>