<?php
if ($id == 0) {
if ($buy == 0) {
$result = pg_query($conn, "SELECT p.*, us.login FROM plyty.pozycja p LEFT OUTER JOIN plyty.users us ON
p.user_id=us.id WHERE p.buy=0 ORDER BY p.id DESC LIMIT ".$limit." OFFSET ".$start.";"); $resultMuch = pg_query($conn, "SELECT count(id) AS much FROM plyty.pozycja WHERE buy=0;"); } elseif ($buy == 1 ) {
$result = pg_query($conn, "SELECT p.*, us.login FROM plyty.pozycja p LEFT OUTER JOIN plyty.users us ON
p.user_id=us.id WHERE p.buy=1 ORDER BY p.id DESC LIMIT ".$limit." OFFSET ".$start.";"); $resultMuch = pg_query($conn, "SELECT count(id) AS much FROM plyty.pozycja WHERE buy=1;"); } else {
$result = pg_query($conn, "SELECT p.*, us.login FROM plyty.pozycja p LEFT OUTER JOIN plyty.users us ON
p.user_id=us.id ORDER BY p.id DESC LIMIT ".$limit." OFFSET ".$start.";"); $resultMuch = pg_query($conn, "SELECT count(id) AS much FROM plyty.pozycja"); }
} else {
if ($buy == 0) {
$result = pg_query($conn, "SELECT p.*, us.login FROM plyty.pozycja p LEFT OUTER JOIN plyty.users us ON
p.user_id=us.id WHERE us.id=".$id." AND p.buy=0 ORDER BY p.id DESC LIMIT ".$limit." OFFSET ".$start.";"); $resultMuch = pg_query($conn, "SELECT count(id) AS much FROM plyty.pozycja WHERE buy=0;"); } elseif ($buy == 1 ) {
$result = pg_query($conn, "SELECT p.*, us.login FROM plyty.pozycja p LEFT OUTER JOIN plyty.users us ON
p.user_id=us.id WHERE us.id=".$id." AND p.buy=1 ORDER BY p.id DESC LIMIT ".$limit." OFFSET ".$start.";"); $resultMuch = pg_query($conn, "SELECT count(id) AS much FROM plyty.pozycja WHERE buy=1;"); } else {
$result = pg_query($conn, "SELECT p.*, us.login FROM plyty.pozycja p LEFT OUTER JOIN plyty.users us ON
p.user_id=us.id WHERE us.id=".$id." ORDER BY p.id DESC LIMIT ".$limit." OFFSET ".$start.";"); $resultMuch = pg_query($conn, "SELECT count(id) AS much FROM plyty.pozycja;"); }
}
?>
czy nie ma lepszego sposobu na tworzenie zapytan?
$id odnosi sie do usera z ktorego wyswietlamy zawartosc
$buy -> 1 dla rzeczy do kupienia, 2 dla wszsytkich, 0 dla rzeczy do sprzedania