Code Forums - View Single Post

falsepride · 02-13-2008, 07:40 PM

well in the past all of my codes have been rather sloppy. all flat file, all using functions involving md arrays. in small amounts it was easy to follow, but once scripts started getting longer, it was hard to detect errors, and fix them.

i read 3/4 of a c++ book(lost track because of school), but it did give me a good enough understanding of programing using oop.

i'm designing a site for the fish store i work at. we've hired 3 guys in the past to do it, but none actually did anything. we've recently just rehired someone, but i personally know, that how long its taking him and the temp page he put up, that i can do a better job. so i just started scripting it out, i'd like to get it done in a month, present it to my boss and tell him to just get rid of the other guy.

my objectives are rather simple on the php/mysql side. its a fish store. i need to make it so managers can post new fish orders so costumers can be alerted. a simple login system for managers to do so. have a sql table for people signed up for the mailing list, and have an email sent out to them of the order. and also have a 'full member' table. where people can build a fish 'wish list' so if we find a certain species is in high demand. order it. then post the order up. in this case the costumer would get 2 emails, one of the whole order. and one alerting them a fish on their wish list has arrived, then remove it off their list. and a few other things

i was planning on having sql tables for
manager info
order arivals
fish species
mailing list
full member

im guessing to do this, im not going to need to learn all of mysql, only a rather small portion. any suggestions would be great on how youd go about things differently.

and a quick sql question, when i try to make a field in a table a primary i got a length error or something. i was using phpmyadmin on awardspace. the free subdomain im setting my demo up on. anyone shed any light on my error?

02-13-2008, 07:40 PM	#6 (permalink)
falsepride Regular Contributor Join Date: Oct 2004 Posts: 203	well in the past all of my codes have been rather sloppy. all flat file, all using functions involving md arrays. in small amounts it was easy to follow, but once scripts started getting longer, it was hard to detect errors, and fix them. i read 3/4 of a c++ book(lost track because of school), but it did give me a good enough understanding of programing using oop. i'm designing a site for the fish store i work at. we've hired 3 guys in the past to do it, but none actually did anything. we've recently just rehired someone, but i personally know, that how long its taking him and the temp page he put up, that i can do a better job. so i just started scripting it out, i'd like to get it done in a month, present it to my boss and tell him to just get rid of the other guy. my objectives are rather simple on the php/mysql side. its a fish store. i need to make it so managers can post new fish orders so costumers can be alerted. a simple login system for managers to do so. have a sql table for people signed up for the mailing list, and have an email sent out to them of the order. and also have a 'full member' table. where people can build a fish 'wish list' so if we find a certain species is in high demand. order it. then post the order up. in this case the costumer would get 2 emails, one of the whole order. and one alerting them a fish on their wish list has arrived, then remove it off their list. and a few other things i was planning on having sql tables for manager info order arivals fish species mailing list full member im guessing to do this, im not going to need to learn all of mysql, only a rather small portion. any suggestions would be great on how youd go about things differently. and a quick sql question, when i try to make a field in a table a primary i got a length error or something. i was using phpmyadmin on awardspace. the free subdomain im setting my demo up on. anyone shed any light on my error?