Its because the function cannot access your connection object...
Try passing it to the function..
function makelistboxentries($link, $title, $mytable, $mycolumn, $othertable,
$wherestring)
On Thu, 23 Sep 2004 19:44:51 +0200, Antoine <[EMAIL PROTECTED]> wrote:
> Hi,
> I am trying to get skilled up on postgres and decided to port a little
> movie database I wrote for mysql with php to access it.
> I used an auto converter for the bulk and then tried to tweak. The
> following code does not work but the error message it gives me is
> strange. It tells me that the connection string used on line 82 (where
> it calls pg_query in makelistboxentries) is invalid... but the same
> string/connection works just great in another script... any pointers
> appreciated.
> Cheers
> Antoine
>
> <?php
>
> /* Connect to database */
> $link = pg_connect("dbname=movies host=localhost user=anton
> password=password")
> or die("Could not connect : " . pg_result_error($link));
>
> print <<<TII
> <div id=mybody>
> Search by:
> <BR>
> <TABLE border="1" cellpadding="10" cellspacing="10"><TR>
> <TD align="center">
> ID:
> <form name="input" action="searchout.php" method="post">
> <input type="text" name="mychoice">
> <input type=hidden name = wherestring value=" t1.ID = ">
> <input type=hidden name = othertable value="movies">
> <input type="submit" value="Submit">
> </form>
> </TD>
> <TD align="center">
> Name:
> <form name="input" action="searchname.php" method="post">
> <input type="text" name="mychoice">
> <input type="submit" value="Submit">
> </form>
> </TD></TR>
> </TABLE><BR>
> <TABLE border="1" cellpadding="10" cellspacing="10"><TR>
> TII;
> makelistboxentries("Audio Language", "lang", "lang", " audio ", "
> t2.movie = t1.ID and t2.lang = ");
> makelistboxentries("Subtitle Language", "lang", "lang", " subtitles ",
> " t2.movie = t1.ID and t2.lang = ");
> makelistboxentries("Genre", "Genre", "Genre", " moviegenre ", "
> t2.movie = t1.ID and t2.genre = ");
>
> print <<<TINI
> </TD>
> </TR></TABLE>
> <br><br>
> <P>Show All:</P>
> <form name="input" action="allout.php"
> method="post">
> <input type="submit" value="Submit">
> </form>
> </div>
> <div id=mymenu>
> <P><A href="index.php"><H3>Back to main page</H3></A></P>
> <P><A href="movie.php">Add a movie</A></P>
> <P><a href="audio.php">Add a movie's audio languages</a></P>
> <P><a href="subtitles.php">Add a movie's subtitle languages</a></P>
> <P><a href="searchin.php">Search the movies</a></P>
> </div>
> TINI;
> /* Close connection */
> pg_close($link);
>
> function makelistboxentries($title, $mytable, $mycolumn, $othertable,
> $wherestring)
> {
>
> print "<TD align=\"center\">";
>
> print "$title:";
> /* Perform SQL query */
> $query = "SELECT $mycolumn FROM $mytable";
> $result = pg_query($link,$query)
> or die("Query failed : " . pg_result_error($link));
> print "<form name=\"input\" action=\"searchout.php\" method=\"post\">";
> print "<SELECT NAME=\"mychoice\">";
> print "<option value=\"zz\" SELECTED>Select $title</option>";
> while ($line = pg_fetch_array($result,$result_countt++,PGSQL_ASSOC)) {
> foreach ($line as $col_value) {
> print ("<OPTION VALUE=\"".$col_value."\">");
> print $col_value;
> print ("</OPTION>");
> }
>
> }
> print "</select>";
> print "<input type=hidden name = wherestring value=\"$wherestring\">";
> print "<input type=hidden name = othertable value=$othertable>";
> print "<input type=\"submit\" value=\"Submit\">";
> print "</form>";
>
> pg_free_result($result);
> }
>
> ?>
>
> --
> G System, The Evolving GUniverse - http://www.g-system.at
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
