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.
>
>
> <html lang="en">
> <head> <title>Code Search</title>
> <script TYPE="text/javascript" LANGUAGE="JavaScript"><!--
> function setCampCode(code) {
> opener.campcode = code;
> opener.restart();
> self.close;
> }
> //--></SCRIPT>
> </head>
> <body BGCOLOR="white">
> <?php //Database Connection - global
> $dbconnect = pg_connect("dbname=campus user=apache");
> ?>
> <br>
> <center>
> <table width="90%" border="0" cellspacing="1" cellpadding="0"
> bgcolor="green"><tbody><tr><td>
> <table width="100%" border="0" cellspacing="1" cellpadding="8"
> bgcolor="#f6f6f5"><tbody><tr><td>
> <table width="70%" border=0 cellpadding=0 cellspacing=4>
> <form name="campcode" method="post" action="<?php
> print("$PHP_SELF");?>">
>
> <tr><td>Search:</td><td><input type="text" name="code"></td>
> <td><input type="submit" name="submit" value="Search"></td></tr>
> </form></table>
> </td></tr></tbody></table></td></tr></tbody></table> </center>
> <br><br>
> <?php
> //$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 "<font color=\"red\" size=4>no
> result</font>"; exit;}
> printf ("<center>
> ");
> printf ("<table cellpadding=4 cellspacing=1 border=1>
> ");
> printf ("<tr
> bgcolor=\"lightblue\"><td><b>ID</b></td><td><b>College</b></td></tr>
> ");
> while($myrow = pg_fetch_row($result)) {
>
> printf ("<tr><td><a
> href=\"javascript:setCampCode('%s')\">%s</a></td><td>%s</td></tr>"
> , $myrow[0], $myrow[1], $myrow[2]);
> }
> printf ("</table></center>
> ");
> }
> pg_close($dbconnect);
> ?>
> </body>
> </html>
--
---------------------------------------------------------------------
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/
---------------------------------------------------------------------
