Posts Tagged ‘mysql database’

I have a script for a MySQL Database that adds up all of the numbers in a column and sets it back to zero (its pretty much like an adjusting entry). I don’t want to clear the contents completely because I need them for reporting purposes. I want either PHP or MySQL to run a script to do this automatically so I don’t forget to do it. What is the best way in going about doing this?

i need to extract data inputted from pascal and the fit into a mysql database… How exactly would i go about interfacing the two together?

I’d like to be able to upload resumes into a mysql database, be able to search them by keywords, and retrieve them when needed. Is saving them as Blob the best way? If not, which format should they be saved as? I currently have them saved as blobs, but can’t retrieve them, or search through them. I’d like to build a generic Applicant Tracking System using PHP and mysql.

If you can, please help.

If you will advise me to buy an ATS system, save your energy on typing. That wouldn’t be the answer to my question. I am considering buying an ATS if this becomes too complicated…

Thanks!

I just started exploring MySQL for a database that I want to set up. I want the online user to be able to search for any word in the entire database. The database might become 500 meg over time (small compared to facebook, big compared to a employee databse). At what point does searching that amount of a MySQL database going to be an issue? I am new to MySQL and databases, so any other help or suggestion regarding this topic is greatly appreciated.

I have a mysql database that receives the data from a php form that submits a unique user id, and 3 sports. I will likely be adding new fields (age etc) but the main thing I want to accomplish is if my users go through the form again (logged into to the same user id) and submit different information, how could I overwrite the old entry so I only have 1 record for the user?

hopefully this is possible one way or another !

I want to be able to save incoming emails to a mysql database using a php script. I want the script to be executed each time I received and email in my cpanel webmail.

Please could some one give me a link where I can get resource on how to go about such.

Thanks in advance.

I have a MySql database set up called users. The only things required to register to my website are a username and password. When this is completed, the database populates with the users info as requested. How does MySql make this new users permissions to have it where they can now download files from my website? As of now anyone can download and take my sites files without logging in. How do I stop that also?
Thanks in advance for any help.

I’ve searched on the internet and in Dreamweaver help, but I can’t find clear instructions on how to make a MySQL database. Can anyone help?