Need help with understanding MySQL and adding things

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
kaYak
Forum Commoner
Posts: 65
Joined: Mon Feb 02, 2004 2:43 pm
Location: USA

Need help with understanding MySQL and adding things

Post by kaYak »

I have a script that checks to see if a file exists and I want to use it to find unreleased files on this one site. The script that checks if the file exists is working fine but I would like to do more than just print out that the file exist. I would like to do something with MySQL if it exists. I don't really understand MySQL at all. What I would like to do is if the file exists have the script add a row to a table with two pieces of information. If you need more information please ask.

Thanks,
techguy
User avatar
infolock
DevNet Resident
Posts: 1708
Joined: Wed Sep 25, 2002 7:47 pm

Post by infolock »

well, you are going to need to either do 1 of 2 things : post this in the Volunteer Forum or open the manual included with your mysql distribution ( or view it on mysql's website ), and learn. that may sound cold hearted, but that's just simply the only way to do it. if we write hte script, you wont understand how it works. so, ur either gonna have to learn it, get started,a nd then run into a problem, or simply have somene write it for you and never learn.

the choice is yours
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

The MySQL Manual has a plethora of information regarding this particular situation.

The link is in my signature; check it out! 8)
kaYak
Forum Commoner
Posts: 65
Joined: Mon Feb 02, 2004 2:43 pm
Location: USA

Post by kaYak »

Thanks guys. I don't think it sounds cold hearted at all. I understand that I need to learn it for myself. Well, I better get reading that huge manual...

Can anyone suggest a couple pages of the manual for me to read so I have some place to start with the reading, there is just way too much.

Also, I'm using phpMyAdmin too so that may help me and make a difference in learning how to use MySQL.
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

I'd check out: http://www.mysql.com/INSERT

Also this google search: [google]php mysql beginner tutorial[/google]
kaYak
Forum Commoner
Posts: 65
Joined: Mon Feb 02, 2004 2:43 pm
Location: USA

Post by kaYak »

Thanks again Sami, I'll check them out. :D
Post Reply