tpc at csua.berkeley.edu
tpc at csua.berkeley.edu
Mon Oct 27 11:20:10 EST 2003
fingers crossed, here's hoping the bug doesn't rear its creepy head again, can't really say wherefore the bug but I found a workaround, I changed the basic MySQL statement below: SELECT url, title FROM URLs, URLs_WITH_MATCHES WHERE URLs.id = URLs_WITH_MATCHES.url_id; to: SELECT title, url from URLs INNER JOIN URLs_WITH_MATCHES ON URLs.id = URLs_WITH_MATCHES.url_id; and voila ! I am a complete idiot.
|