Coding – The SQL

Logo_2It’s a long time since I’ve been a developer; February 1998, over eight years ago at Creative Convergence. Today, in order to help my brother out with his university assignments and also to start skilling up for the future…I taught myself some basic MySQL and PHP!

Essentially, I had to extract some product information from a database table and display it:

  • Create an HTML template (no CSS skills yet I’m afraid…)
  • Create the SQL to generate the data model.
  • Write some PHP to create database connections and run basic SQL queries.
  • Format the query results into a table.

Dammit, it’s taken me from 8pm to 2am, but I’ve cracked it – don’t laugh, I’m still learning, but here’re the first results… – well anyway, over to Farhan now to do the hard stuff!


Comments

2 responses to “Coding – The SQL”

  1. I guess you’re still working on it :-p
    Couldn’t retrieve contents of Product table: Table ‘imran.Product’ doesn’t exist

  2. Aha – when Farhan finished the work he must’ve transferred it over to his University site for demonstration. Oops.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.