Thanks in advance for any info or help you can give me. This site has been very resourceful for me over the past 6 months.
However, I am stuck on these 2 errors:
Warning: Unable to jump to row 1 on PostgreSQL result index 2 in /usr/home/fast/public_html/bookinfo.php on line 17
Warning: Unable to jump to row 0 on PostgreSQL result index 3 in /usr/home/fast/public_html/bookinfo.php on line 34
Warning: Unable to jump to row 0 on PostgreSQL result index 4 in /usr/home/fast/public_html/bookinfo.php on line 47
Executing this code:
$db = pg_pconnect(\"host=\". $config[\"sqlserver\"] . \" port=\". $config[\"sqlport\"] . \" user=\". $config[\"sqlusername\"] . \" password=\". $config[\"sqlpassword\"] . \" dbname=\". $config[\"defaultdb\"]);
$bookquery = \"SELECT * FROM books WHERE books_id=\'$bookid\'\";
$bookresult = pg_exec($db, $bookquery);
$i = 0;
\"17\"
while($row = pg_fetch_row($bookresult, $i++))
{
$bookresult_book_id = $row[0];
$bookresult_owner_id = $row[1];
$bookresult_title = $row[2];
$bookresult_author = $row[3];
$bookresult_isbn = $row[4];
$bookresult_edition = $row[5];
$bookresult_category = $row[6];
$bookresult_condition = $row[7];
$bookresult_price = $row[8];
$bookresult_dateposted = $row[9];
}
$userquery = \"SELECT * FROM students WHERE students_id=\'$bookresult_owner_id\'\";
$userresult = pg_exec($db, $userquery);
$i = 0;
\"34\"
while($row = pg_fetch_row($userresult, $i++))
{
$userresult_student_id = $row[0];
$userresult_username = $row[1];
$userresult_email = $row[2];
$userresult_school_id = $row[5];
$userresult_state = $row[6];
}
$schoolquery = \"SELECT * FROM schools WHERE schools_id=\'$userresult_school_id\'\";
$schoolresult = pg_exec($db, $schoolquery);
$i = 0;
\"47\"
while($row = pg_fetch_row($schoolresult, $i++))
{
$schoolresult_school_id = $row[0];
$schoolresult_name = $row[1];
}
