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 ", "
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
<P>Show All:</P>
<form name="input" action="allout.php"
<input type="submit" value="Submit">
<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>
    /* Close connection */
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 - http://www.g-system.at

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to