I use PHP and PostgreSQL, let me give you my code and the error message and please tell me what could go wrong with it?
$query = "SELECT * FROM weekly_revision WHERE rpt_yr = $report_year AND week = $week_num";
$result = pg_exec($connection, $query);
and here is the error message:
Warning: 1 is not a valid PostgreSQL link resource in /home/hdt/public_html/Scheduler/maint/review_schedule.php on line 1104
First of all, let me tell you that the $query statement is correct because I tested in the database, and I also used print("$query"); Everything is ok. The line 1104 is the $result line.
What's wrong with my:
$result = pg_exec($connection, $query);
Please please help...
Chris
$query = "SELECT * FROM weekly_revision WHERE rpt_yr = $report_year AND week = $week_num";
$result = pg_exec($connection, $query);
and here is the error message:
Warning: 1 is not a valid PostgreSQL link resource in /home/hdt/public_html/Scheduler/maint/review_schedule.php on line 1104
First of all, let me tell you that the $query statement is correct because I tested in the database, and I also used print("$query"); Everything is ok. The line 1104 is the $result line.
What's wrong with my:
$result = pg_exec($connection, $query);
Please please help...
Chris