MySQL is breaking my head

Wowww!!!!!! That SQL stuff is being really hard to me!!! Maybe i'm not that smart guy anymore!

I'm trying to learn some SQL ONLY, only and Only to can Setup and OSCommerce Webstore.

Is there an easier way??

Can I do the database in Access 2002 to work it then in PHP?

Buy "learn SQL in 21 days"
"SQL for dummies"

Or.. gather as many sample scripts as you can and learn through example.

oh, and

What does THAT mean?

Ummm i don't know if you know this but I thought I would clear it up

MySQL is NOT SQL.

SQL is a standard set of instructions used to communicate with a SQL compliant database.

So the same statements should (theoretically) work on MySQL, Postgres, MS SQL etc

Thanks for the explanation rabid dog !
suzie.

As far as I understand you want to build the database using access 2002 and have PHP retrieve records from it?

This can be done. just set up an ODBC connection for the PHP code.

Rabid dog is right, but if it is SQL giving you a headache, switching databases will not help.

SQL isn't really that bad. It's mildly confusing if you are trying to think in terms of a procedural programming language, because it isn't. But in terms of structure and commands, it's mostly quite simple when you get the hang of it


//Just to be super-pedantic, SQL does have dialects, so certain codes will need to be "tweaked" for portability, but apart from that it's a standard language.

Thats why I said theoreticaly, because we all know that in practise it is a different story

well ok, I'll let you off then hehe

TBH, I'm not even sure why I posted that. I think I was pointing out that the differences are <i>really</i> minor, like wildcards and stuff.