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

• Next in forum: Re: Simple PHP script doesn't work with new web host
• Prev in forum: Re: Getting an included PHP script to to include a file in the same directory.
• Thread view: Re: Query problems with PostgreSQL

[Reply to this message]