Thursday, June 5, 2008

I want to use a database for my website. The site has MySQL installed- but... now what? I m used to using actual programming languages- with IDE s- but SQL doesn t have that. How do I get started working with SQL?

My hobby is web designing. So I have some web development projects as social service. I can do web development with PHP- MySQL- JavaScript- HTML- AJAX Technology- etc. But I haven’t talent to drawing icons- logos- pictures on Adobe illustrator.
I know little bit on Flash action script & animation. But I don’t know too much to do my professional works for my web pages. But I don’t like to learn it. Because web developing isn’t my job.
So I like to find a partner (friend) who has an excellent talent on Adobe illustrator & Flash action script- animation. Team works always make success.
But where I can find him?
I m not doing it as a business. I m doing it for free like this
http://vaazhvaham.org/home/
This site under construction.

I have a couple websites hosted with different hosting providers (one with Go Daddy and one with HostGator). I want to be able to email a specific address (that I would create on one of those sites)- and emails to that address would get automatically "processed" by some kind of script as follows: if there is an attachment on the email- it would get saved to a specific directory on the web server- and then a row would get added to a MySQL database to indicate the file is there. The challenging part will be monitoring for an incoming email and then managing the attachment. Is there a website where I could find a script that might help me with this?

(The reason I am doing this is b/c the iPhone will let me email photos but not upload them to a website- so I want to email vacation photos while I am away and have them get processed and uploaded to a website so they can be viewed.)

Thanks!

mySQL database?

I m creating a database that holds data on a large number of users. The database is meant to keep track of "awards" that users have. Each user has an id number and each type of award has an id number. The database will need to be queried about what awards a certain user has.

I m new to database programming and am trying to figure out what the best practice for this design should be. Should I make just one massive table that holds all of the users awards and just filter my queries based on user id number- or should I make separate tables for each user that uses the user s id number as part of its name?

Any help on this issue or links to helpful database programming sites are greatly appreciated.

Still learning about Network security and web page development. Currently Learning PHP and MySQL. Other than that- I am pretty much an HTML- JScript amatuer web designer. On my web site- I would like to be able to record and log the IP address of people who visit my site. Is this accomplished through code on a page- or by adding software to the server? And While I have you here reading- what programming is best for log in abilities (creating user names and passwords)? As I said- still learning- so any help is appreciated. Any references to tutorial sites- or books is also appreciated. I would like to learn as much as possible about web development- network security- and intrusion detection and prevention.
Thank you! ( And yes- I give best answer)

No comments: