RE: Passing a query string as a single url variable

Funny but when I mouse over it has it encoded. Here's the source of my output page. Here is the qrystr encoded: name%3DJane%26eyes%3Dbrown%26hair%3Dblond%26number%3D2125551234 http://www.hfdkldf.com/main.cfm?action=saveinfo&qrystr=name%3DJane%26eyes% 3Dbrown%26hair%3Dblond%26number%3D2125551234">

RE: Having problem with query and multiple tables.

You would have to do a left join. Now this Is untested and it's been a long time since I've written one of these but it's something like SELECT p.name, p.product_id, p.content_id, p.creationdate, h.hits AS hits, h.clickthroughs AS clicks, s.pagetitle, s.parent, c.pagetitle AS category FROM