Re: mysql to postgres migration blues...

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 <melser.anton@gmail.com> 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 > >