Re: Query problems with PostgreSQL
- From: Toby Inkster <usenet200701@xxxxxxxxxxxxxxxxx>
- Date: Wed, 10 Jan 2007 23:28:33 +0000
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
.
- References:
- Query problems with PostgreSQL
- From: webhead74
- Query problems with PostgreSQL
- Prev by Date: Re: Getting an included PHP script to to include a file in the same directory.
- Next by Date: Re: Simple PHP script doesn't work with new web host
- Previous by thread: Re: Query problems with PostgreSQL
- Next by thread: zip_read strangeness
- Index(es):
Relevant Pages
|
|
