Well, not really, I'm afraid - the plain $id takes the visitor to the next page with the correct POSTed value in the URL. Alas, alas, adding single or double quotes doesn't solve things.> $Query="SELECT properties.area, images.image_filename FROM > properties, > images WHERE properties.reference_number=images.reference_number AND > properties.area=$id"; > > but it doesn't work - I get the usual "...not a valid MySQL > result resource" > If you can help, thanks in advance.
If $id is a string and not an int, then you need to single- or double-quote it.
Try this:
$Query="SELECT properties.area, images.image_filename FROM properties, images WHERE properties.reference_number=images.reference_number AND properties.area='$id'";
HTH!
I've shuffled/altered names around in a (fruitless) attempt to correct things but still, clicking on the hyperlink for "Spain" and echoing the $Query and the $Result to screen I get -
Query= SELECT properties.caption AS caption, properties.country, properties.area AS area, images.image_filename AS filename FROM properties, images WHERE properties.reference_number=images.reference_number AND properties.country='Spain'
Result= i.e. No Result. Boo-hoo.
Anything stand out there?
Iain.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]