I'm in the need to start learning SQL and php. Does anyone here have any good sugestions as to where to start and some good sites for asking questions?
I'll be interested to see what is recommended for PHP myself.
I learned SQL basics by using (ahem) MS Access. By building SQL queries in its query manager and then examining the SQL code produced, I learned the basics (Having experience in other programming languages helped). I then learned how to manipulate such expressions in VB scripts within the same DB's to further extend my knowledge....
To find out some SQL specifics, I also learned to go to FileMaker Help and open the ODBC and JDBC Guide from the Documentation Sub Menu. It lists quite a bit of SQL info and the information on the Select statement also applies to the Execute SQL function.
W3Schools is most often recommended.
W3Schools SQL Tutorialhttp://www.w3schools.com/sql/default.aspW3Schools PHP Tutorialhttp://www.w3schools.com/php/default.asp
Thanks for the info.
I've looked at the W3Schools, but I'm also concered as there is a lot of negative stuff on the net about the site.
How would you rank learning SQL compared to Filemaker?
I can find negative stuff on the web about puppies.
I would look for a site that gives an overview with specifics that makes sense to me.I would be searching for instruction on how to do or solve a specific task that is presented clearly.
People have learning preferences - some read, some listen, some watch, some do to learn their skills.I can be looking for a tree, or step back and survey the forest.My best recommendation would be to pay a lot of money to a database wizard to reach your goal.
If that is not an option, I would look for someone that has reached the goal and posted the results with the process clearly explained.Few experts take the time to post their expertise. Search for templates for Filemaker and I find few good results.
If I can not find the solution, I would search for the tools and information to find the path to the solution.
Google "sql tutorials"https://www.google.com/search?q=sql+tutorials W3Schools is the first unpaid linkThat can be because they are the best source, the most people think so, they have been around a long time, or they have done good SEO.Or some and or all of the above.
"How would you rank learning SQL compared to Filemaker?"
How would I rank a screwdriver compared to a hammer? Depends on your project. SQL will drive you nuts in different ways from Filemaker.
Google "sql tutorials site:youtube.com"https://www.google.com/search?q=sql+tutorials+site%3Ayoutube.comSQL Tutorials on Youtube
Google "sql tutorial filetype:pdf"https://www.google.com/search?q=sql+tutorial+filetype%3ApdfSQL Tutorial PDFs
Search for PDFs and other file typeshttp://www.pdfsearchengine.org/
PDFSearch "sql tutorial"http://www.pdfsearchengine.org/results.html?cx=016703912148653225111%3Aosmuvcrimei&cof=FORID%3A10&ie=UTF-8&q=filetype%3Apdf+sql+tutorial&qfront=sql+tutorial&sa=Search&algorithm=filetype%3Apdf+&siteurl=www.pdfsearchengine.org%2F&ref=www.google.com%2Furl%3Fsa%3Dt%26rct%3Dj%26q%3D%26esrc%3Ds%26source%3Dweb%26cd%3D1%26ved%3D0CGYQFjAA%26url%3Dhttp%253A%252F%252Fwww.pdfsearchengine.org%252F%26ei%3DRw8kUIHdIuH0iwKTnIGgAQ%26usg%3DAFQjCNHiZQKtSdtvMK_pWly2kuy7bJWELg%26sig2%3DULMTYrdnkK-Bt5esOQiKWg&ss=
There are FMP ExecuteSQL posts here
Well, I didn't mean to hit a nerve...
I was hoping for someone who may actually have experience with the subject.. Anyone can google something and find a pleathora of information to dig through and hopefully find something of value. I wish I knew of this site 4 years ago when I started using filemaker, I would have had a few more nights of sleep..... In my experience the first answer isnt always the best, then sometimes it is... Hense asking for experience...
Simply trying to save myself some wasted time by asking a ?
My two cents worth is to go out and buy a Punch Bag, too. You'll quickly find that whereas you read all the SQL Standards and tutorials, SQL didn't...
At least not the same books as you.
Retrieving data ...