Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AD70E475AD7 for ; Wed, 25 Dec 2002 21:59:24 -0500 (EST) Received: from kant.catalyst.net.nz (203-79-74-15.adsl.paradise.net.nz [203.79.74.15]) by postgresql.org (Postfix) with ESMTP id 3DC0A4758FE for ; Wed, 25 Dec 2002 21:59:23 -0500 (EST) Received: from 127.0.0.1 (ident=unknown) by kant.catalyst.net.nz with esmtp (masqmail 0.2.16) id 18ROF8-19a-00; Thu, 26 Dec 2002 15:59:30 +1300 Subject: Re: table not showing in explorer From: Andrew McMillan To: Bruce Young Cc: PostgresPHP In-Reply-To: <20021226023148.91850.qmail@web10405.mail.yahoo.com> References: <20021226023148.91850.qmail@web10405.mail.yahoo.com> Content-Type: text/plain Organization: Message-Id: <1040871569.19185.59.camel@kant.mcmillan.net.nz> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.0 Date: 26 Dec 2002 15:59:30 +1300 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/56 X-Sequence-Number: 1731 On Thu, 2002-12-26 at 15:31, Bruce Young wrote: > i have a php script that searches a column and prints it out. > the table appears fine in mozilla, but dont show in Explorer. > if i change the variable in the search script to a literal value, it > works fine. i have tried alternatives, and it seems that the problem > is in the variable. here is the script: > any help appreciated. If it works in Mozilla but not in IE, your problem will most likely be in the form or the javascript. I recommend you use the phpinfo() function to display all of the PHP variables (and other information) in the page and go from there. When you do that it will probably become obvious exactly what difference there is between the two browsers. The problem will have nothing to do with PostgreSQL, of course. Cheers, Andrew. > > > > Code Search > > > > $dbconnect = pg_connect("dbname=campus user=apache"); > ?> >
>
> bgcolor="green">
> bgcolor="#f6f6f5">
> > "> > > > >
Search:
>
>

> //$code_query = $code; > if($submit) { > > //THIS IS THE PROBLEM I THINK > $qry_get_camp_codes = "select id, id, name from list where name > ~* '$code'"; > $result = pg_exec ($dbconnect, $qry_get_camp_codes); > if (!$result) {printf ("Error\n"); exit;} > if (!pg_numrows($result)) { echo "no > result"; exit;} > printf ("
> "); > printf (" > "); > printf (" bgcolor=\"lightblue\"> > "); > while($myrow = pg_fetch_row($result)) { > > printf ("" > , $myrow[0], $myrow[1], $myrow[2]); > } > printf ("
IDCollege
href=\"javascript:setCampCode('%s')\">%s%s
> "); > } > pg_close($dbconnect); > ?> > > -- --------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 Survey for nothing with http://survey.net.nz/ ---------------------------------------------------------------------