[PHP-DB] Paging

2009-05-11 Thread Joey Hendricks
Hi everybody, I have a paging question. I have a page where you can view a persons 'profile'. And I have a list taken from the db of there books. I can get all the books on one page but I can't figure out the WHERE from the get. This is what I tried but it didn't work. $query = "SELECT COUNT(*

Re: [PHP-DB] PHP & Postgres - query not writing to database.

2009-05-11 Thread danaketh
Glad that you found the problem :) Carol Walter napsal(a): To all who helped. Thank you very much. I found the problem. There is a leading blank on the last name field that I couldn't see. It was coming from my program code. Thanks for all your help. Carol On May 11, 2009, at 4:23 PM,

Re: [PHP-DB] PHP & Postgres - query not writing to database.

2009-05-11 Thread Carol Walter
To all who helped. Thank you very much. I found the problem. There is a leading blank on the last name field that I couldn't see. It was coming from my program code. Thanks for all your help. Carol On May 11, 2009, at 4:23 PM, Carol Walter wrote: I have copied the queries into psql an

Re: [PHP-DB] PHP & Postgres - query not writing to database.

2009-05-11 Thread Carol Walter
I have copied the queries into psql and wrapped them in a BEGIN and COMMIT. Even from psql the queries appear to work but don't store the information. There don't appear to be errors in the log either. Thanks for your help, Carol km_tezt=# begin; BEGIN km_tezt=# INSERT INTO "tblPeople"("f

Re: [PHP-DB] MySQL: did anyone start a transaction?

2009-05-11 Thread Bastien Koert
On Fri, May 8, 2009 at 6:23 PM, Bogdan Stancescu wrote: > Hello all, > > I asked this question on php-general last month > (http://marc.info/?t=12404923034&r=1&w=2), and received some answers > -- but I was directed to this list, so here. > > My question is: can I tell programatically whether