newbietech

<?php $query_getf = "select ci.tb_ci_id, concat(ci.tb_ci_fname, ' ', ci.tb_ci_lname),ci.tb_ci_city, ct.tb_ct_desc, md5(ci.tb_ci_id), s.tb_s_name_full, case ci.tb_ci_addr_2 when '' then ci.tb_ci_addr_1 else concat(ci.tb_ci_addr_1, ', ', ci.tb_ci_addr_2) end, ci.tb_ci_phone_1, ci.tb_ci_phone_2, ci.tb_ci_fax, ci.tb_ci_email FROM tb_contact_info ci, tb_contact_type ct, tb_states s WHERE md5(ci.tb_p_id)='".$fd_p_d['md5_id']."' AND ci.tb_ct_id=ct.tb_ct_id AND ci.tb_s_id=s.tb_s_id ORDER BY ct.tb_ct_desc, ci.tb_ci_date_added"; //print $query_getf; $sth_getf = mysql_query($query_getf); …

Hey guys I need some help with sorting under headers, Suggestion was made by Professor PC but keep getting errors. I hope to get this solved. I couldn't figure it out. I just keep getting some error messages. I don't know what you're talking about when you mention "><a href="thispage.php?sort=1">Notice …

Sorry, me again. Is it possible to help me with being able to sort by clicking on column headers. And the code again: [code=php]$query = "SELECT firstname, lastname, pilotid1, pilotid2, COUNT(flight_time) AS flights, SUM(block_time) AS block, SUM(flight_time) AS ftime, MAX(date_of_flight) AS date FROM members, pireps WHERE members.pilotid1 = pireps.pilotid2 GROUP …