Php mysql connection from script

Question

I have been facing this problem when using Ubuntu server (lamp) for local development, the problem is when I try to connect to db from Php scripts the queries won't work, as when working with phpmyadmin the queries work without problem. How can I solve this problem?

Answer 1

Show me your query

Answer 2

Are you executing queries capitalized?

Answer 3

no they are not capitalized

Answer 4

I've heard that on linux not capitalizing instructions might cause errors. I have only used it on windows so I can't tell

Answer 5

"select * from people"