Here is my query
SELECT hlp_hed_key, hlp_chan_num, hlp_callsign, FullName FROM gn_stage.stg_stations, gn_config.cfg_headend_lineup WHERE hlp_callsign=Call_Sign AND hlp_hed_key='$h' ORDER BY hlp_chan_num + 0 ASC
I display the results of this query in my webpage. The problem is that if hlp_callsign does not match a field in Call_Sign then the row doesn't display at all. I would like to display all of the other data and perhaps show hlp_callsign in red indicating it is bad and needs edited.
Thanks for the help on this.