Parse error.

sri2002

I am trying to execute this script with the Pgsql database and getting a weird parse error.
My script is:
<?
$conn = pg_connect("dbname=ussa host=11.11.111.11 port=1234 user=ussa_readonly") or die("Could not connect!");
@pgsql_select_db('mydb') or die( "Unable to select database");
$sql_univ_coll ="SELECT DISTINCT tblsaunivname.saunivname, tblsacontacts.SAUniv, tblsaunivName.SAUnivAbbr
FROM tblsacontacts, tblsaunivname
WHERE tblsacontacts.sauniv <> ''
AND tblsacontacts.sauniv = tblsaunivname.saunivabbr
ORDER BY tblsaunivname.saunivname ASC";
result_set = pg_exec($conn,$sql_univ_coll);
$num_rows = pg_numrows($result_set);
?>

When I try to execute this script I get this error:
Parse error: parse error in /usr/home/public_html/pgconnect.php on line 9.
Line 9 corresponds to
result_set = pg_exec($conn,$sql_univ_coll);

Help pls!!
Thanks
Sri

mrmufin

S/B $result_set = pg_exec($conn, $sql_univ_coll);

-NOT-

result_set = pg_exec($conn, $sql_univ_coll);

sri2002

That worked. Thanks much...
Sri

sri2002

To debug this code to verify whether it is retreivving any records from the DB what print f state do I need to use?
<?
$conn = pg_connect("dbname=ussa host=11.11.111.11 port=1234 user=ussa_readonly") or die("Could not connect!");
@pgsql_select_db('mydb') or die( "Unable to select database");
$sql_univ_coll ="SELECT DISTINCT tblsaunivname.saunivname, tblsacontacts.SAUniv, tblsaunivName.SAUnivAbbr
FROM tblsacontacts, tblsaunivname
WHERE tblsacontacts.sauniv <> ''
AND tblsacontacts.sauniv = tblsaunivname.saunivabbr
ORDER BY tblsaunivname.saunivname ASC";
$result_set = pg_exec($conn,$sql_univ_coll);
$num_rows = pg_numrows($result_set);
printf $result_set;
?>
But this again gives me a parse error.
Help pls!

🙁

mrmufin

A quick glance reveals that you're not calling printf() properly.

Try something like to start with:
printf("%d rows returned", $num_rows);

But consult the experts, not me, since printf() and sprintf() are BIG powerful, flexible functions:
http://www.php.net/manual/en/function.sprintf.php

Further, you don't just get a result handle, and then go hell-bent-for-election and try to print it to the screen. Result set handles don't work that way. Conversely, result handles provide a 'resource reference' and need to be processed in order to extract the 'user-world' data that lies within. Which is why there are functions pg_fetch_row(), pg_fetch_array(), pg_fetch_object() and pg_free_result().

I kindly suggest you read up on the various PostgreSQL functions while you're learning all about sprintf() and printf(). The PostgreSQL reference can be found at:
http://www.php.net/manual/en/ref.pgsql.php

Have fun...