running4surival - Developer IT

Excel and pgSQL

- by running4surival

How do I import data from a excel sheet onto a PGSQL database on linux?

ok im trying to upload this csv file onto my table in pgsql but im getting this error ERROR: invalid input syntax for integer: "mlname,mfname,slname,sfname,address,postalcode,membershiptype,hphone,email" CONTEXT: COPY members2, line 1, column id: "mlname,mfname,slname,sfname,address,postalcode,membershiptype,hphone,email" i really understand why im getting this error, both my table and my csv file have the same column names

Read the article

Handling apostrophes, php and pgsql

- by running4surival

For my forms, I'm using pg_escape_string on every field before I insert them into the database. So I get something like firstname='O''reilly'. But when I try to print that out, I get O''reily, 2 apostrophes. Shouldn't it only 1 apostrophe, O'reilly? This isnt a debugging problem, im just wondering if you have firstname='O''reilly', how do you print that so it is just O'reilly instead of O''reilly?

Read the article

Firefox displaying username and password in all my forms?

- by running4surival

I have a website, and when I tell Firefox to remember my username and password for the website, it is causing the username and password to display in all forms on my website, such as registration form. It is only supposed to do this on the login form. Does anyone know a fix for this?

Read the article

pgSQL query error

- by running4surival

i tried using this query: "SELECT * FROM guests WHERE event_id=".$id." GROUP BY member_id;" and I'm getting this error: ERROR: column "guests.id" must appear in the GROUP BY clause or be used in an aggregate function can anyone explain how i can work around this?

Developer IT