RE: [GENERAL] pg_result
От | Jackson, DeJuan |
---|---|
Тема | RE: [GENERAL] pg_result |
Дата | |
Msg-id | F10BB1FAF801D111829B0060971D839F2F907B@cpsmail обсуждение исходный текст |
Список | pgsql-general |
> I have looked all over the site and I can not find good > description for > 'pg_result' I am having this problem. My database and everthing is > working fine but when I try to run a query from an html webpage it is > not > working and I believe it is my 'pg_result' command. I have a table > with > 5-6 columns of information and I want total records to be selected. I > then > reference the call to a variable and call it further in my HTML, but > nothing prints up. I have tried naming all the fields where 'row1' is > below but it also doesn't work. I am not getting any errors and html > prints back except for any values for '$rows', not even the row1 > values > will come back. My query command works fine in psql. > Does anyone see my problem? > > $result = pg_Exec($conn, "$query"); > if (!$result); > echo "An error occured inserting information into our > database.\n"; > exit; > else; > pg_close ($conn); > endif; > $rows = pg_result($result,0,"row1"); > > Thanks in advance, > Dave Close the connection after you are done retrieving the results. -DEJ
В списке pgsql-general по дате отправления: