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 gu...@moongate.ro wrote: Hello all, I asked this question on php-general last month (http://marc.info/?t=12404923034r=1w=2), and received some answers -- but I was directed to this list, so here. My question is: can I tell

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

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

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,

[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