Could be a scope problem. The connection is declared outside the function and the attempt to run a query is inside the function...Maybe add the global command to the connection. Or declare the connection inside the function...


From: Antoine <[EMAIL PROTECTED]>
Reply-To: Antoine <[EMAIL PROTECTED]>
Subject: [PHP-DB] mysql to postgres migration blues...
Date: Thu, 23 Sep 2004 19:44:51 +0200

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


    /* Connect to database */
    $link = pg_connect("dbname=movies host=localhost user=anton
        or die("Could not connect : " . pg_result_error($link));

print <<<TII
<div id=mybody>
Search by:
<TABLE border="1" cellpadding="10" cellspacing="10"><TR>
<TD align="center">
<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">
<TD align="center">
<form name="input" action="searchname.php" method="post">
<input type="text" name="mychoice">
<input type="submit" value="Submit">
<TABLE border="1" cellpadding="10" cellspacing="10"><TR>
makelistboxentries("Audio Language", "lang", "lang", " audio ", " = t1.ID and t2.lang = ");
makelistboxentries("Subtitle Language", "lang", "lang", " subtitles ",
" = t1.ID and t2.lang = ");
makelistboxentries("Genre", "Genre", "Genre", " moviegenre ", " = 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,

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>";



G System, The Evolving GUniverse -

PHP Database Mailing List (
To unsubscribe, visit:

Take advantage of powerful junk e-mail filters built on patented Microsoft® SmartScreen Technology. Start enjoying all the benefits of MSN® Premium right now and get the first two months FREE*.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to