Automatic Removal
Hi, got a Really Simple question, which is probably really easy, but it's just not starign me in the face. Is there any "query" in MYSQL (or function in PHP that works with MYSQL) to remove a value from a field when a new week comes across, or to remove something from a field on a defined date and time, automatically? Apologies if this is the wrong group Thanks in Advance! r -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: storing images in the database
Hi, In my honest opinion, uploading the image to a "preset" directory in the code, and setting the code to submit the image name, extension, and if needs be (it shouldnt, because you can set it in the HTML), the directory. Google has a lot of useful resources on this. But, if you are really "desperate" to do it using the BLOB type, http://www.wellho.net/solutions/php-example-php-form-image-upload-store-in-mysql-database-retreive.html was a help to me when I first started learning. Hope this helps, r ######### Richard Harris PHP, MYSQL, XHTML, CSS [EMAIL PROTECTED] [EMAIL PROTECTED] # Rodney Courtis wrote: Hi I want to store jpeg images in a mysql database from php in the form of 'blob' types. Is this possible and can you detail for me the steps to achieve this? Regards and thanks Rodney Courtis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reserved word/ Ambiguous Column title 'Key'
Hi, I am importing an Access 97 Database into MySQL. One of tables tblSuppliers holds all the critical supplier information and has a 4 character Primary key called 'Key' This is heavily used throughout a lot of VB code in the Access GUI and can't really be changed easily. When I import the Access tables into MYSQL, they lose their indexes and primary keys. Try as I might, I can't change the properties of the Key column using Alter Table, it keeps coming back with syntax errors. I'm currently stuck on the following, ALTER TABLE tblSuppliers CHANGE Key Key CHAR(6) NOT NULL What am I doing wrong/ is there a work round? Thanks in advance for you help. Richard Harris
