ok so the link helped a lot....
although i keep running into problems (the story of my life)....
im trying to select the values from a specific id value in a psql table....
the table is as such
id serial
service varchar(10)
description varchar(200)
starttime timestamp(0)
and such.....
i keep getting errors when i try to display only one row containing a specific id number
right now i have....
$id_request = pg_fetch_assoc(pg_query($conn, "SELECT nextval('servicestatus_id_seq')"));
$result_service = pg_query("SELECT * FROM servicestatus WHERE id='$id_request'");
while($line = pg_fetch_array($result_service, null))
{
foreach($line as $col_value)
{
echo "$col_value \n"; <------ i'm aware i'm displaying too much kinda trying to fix that
}
}
i'm getting errors about the $id_request variable, right now $id_request echo'd returns "Array" and won't output $id_request[index]
so when i delete the pg_fetch_assoc.... and echo $id_request i get Request id #4 or whatever number
I just want the 4 part but i cannot get it......
ahhh i'm confused.....