Posted by Toby Inkster on 01/10/07 23:28
webhead74 wrote:
> $myresult = pg_exec($connection, "SELECT * FROM
> public.archived_with_photos
> WHERE identification_no = '$id_no'");
Could be something funny going on with the variable interpolation. Try:
$myquery = "SELECT *
FROM public.archived_with_photos
WHERE identification_no = '$id_no'";
$myresult = pg_query($connection, $query);
var_dump(array('Q'=>$query, 'R'=>$myresult));
Does the var_dump reveal the query you expected?
--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact
Navigation:
[Reply to this message]
|