Chris FR wrote:
when I execute it via Internet Explorer , sometimes the source is
complete (no problem), sometimes the source is incomplete (the html
page is cutted), and sometimes the browser doesn't display anything
and wait and wait and wait ....
It looks like a typical M$ problem ;-)
most developers use Linux
SELECT a.* FROM a WHERE a.idf = b.id
I solved the problem by modifying the request :
SELECT a.* FROM a, b WHERE a.idf = b.id
Now the script works.
But I don't understand why the first request causes those problems ?
Is the first request has a correct syntax ? ( when submitted to
Postgres, there is no error message , and the results are displayed)
Is it due to PHP ? or PostgreSQL?
have you set
error_reporting = E_ALL & ~E_NOTICE
in your php.ini ? and no error-output in a bad sql-statement?then i
don't know, but i think it's better to make joint-select with ...from
'all joint tables' where ...
bye, Gerd
--
--------------------------------------------------------
# Gerd Terlutter | Mueller+Blanck Software GmbH #
# gerd@xxxxxxxxx | Gutenbergring 38 #
# gerd.terlutter@xxxxxx | D-22848 Noderstedt #
# tel:0171/6992579 | tel:+49 40 500 171-1 #
# Buero:040/500171-17 | fax:+49 40 500 171-71 #
--------------------------------------------------------
