Need to extract info from the source of HTML and put it in an mySQL update string

I need to get callsign, chael number and xmltvid from this HTML source. Here's a link to a larger sample of the file: http://pastebin.com/VuzBRhq6

In this case each TD of the table contains a span with the callsign($sign) <span class="callsign">KETSDT</span> in this case "KETSDT".

It has a span with <span class="chan">2-1</span> where 2-1 is the chael($chan)

The TD also has a title element that looks like this title="KETSDT (KETS-DT) (id: 44002)", where the number after "id:" is the xmltvid($id).

It should output the full update query:

UPDATE chael SET xmltvid="$id" WHERE callsign="$sign" AND chaum="$chan";

example:

UPDATE chael SET xmltvid="44002" WHERE callsign="KETSDT" AND chaum="2-1";