Hi, i was just wondering if any of you would like to give me som ideas and some info on what i need to start a project for my own training and the benifet of everybody out on the net!!!!!
@cwrathOct 13.2005 — #hmm design in access? well...
you can actually get an access to mysql program, a demo version is availible which will convert the first three rows of every table (and create the tables)
however, you should really do it by hand, its a lot easier (Zend do have an inbuilt table editor/creator).
and you should be getting familiar with basic SQL syntax
CREATE DATABASE
CREATE TABLE
INSERT INTO table VALUES ('','3','4')
SELECT * FROM
REPLACE INTO
UPDATE
etc.
Yes always start from a database, sometimes i dont and it always ends up in a mess.
@spinnyscripterauthorOct 13.2005 — #ok, good advice. i have a program called SQLyog and that allows me to design from it. but not visually. like access i cant see what the table looks like intilli have completely wrote the code and run it and the looked at the structure
@spinnyscripterauthorOct 13.2005 — #ok, i remember doing somthing like this on my GNVQ ICT 2 cource at college you list all the feilds and make the conections and include the one to many many to many and one to one links?
@cwrathOct 13.2005 — #NO! NO NO! dont do that. You want relationships? FOREIGN KEYS as they are call in database-speak. Sigh. That can get complicated. It can also be quite simple. You will have to find tutorials on how to do that, look up foriegn keys mysql.
Oh and i didnt like GNVQ ict, waste of time, i was teaching the teachers by the end of it.
most of the time 'relationships' will make something getting the data eaiser but manipulating it harder. I simply use 'advanced' select statements or a combination of select statements, because all-to-often my 'relationships' are serverely limited.
@spinnyscripterauthorOct 13.2005 — #ok, well i have just found problems in my installation of PHP such as it wont connect to MySQL saying the mysql_connect() function undefined so i hvae to fix this first.
@cwrathOct 13.2005 — #there isnt a problem with your php installation, php5 does not have mysql_?? functions turned on by default, some licensing problem...
@spinnyscripterauthorOct 13.2005 — #well, i cant be bother with configaration of servers so i am ownloading and installing a new server (a complete ready configerd server)