Match Records

I`m trying to find the best method to match records between two tables in a MySQL database. But it must match atleast once, so here is a scenario for you to think about. Member - Job, Salary, Location Jobs - Job, Salary, Location All values will be enum sets in both tables as follows Job = en

Table joining/setup advise?

Hi, I`m setting up a email system, the same type of system as Yahoh Groups, Topica etc.. I`m just in need of some advise as to how best to handle my tables. At the moment I have the following tables setup.. Lists - Stores info about the list ListOwners - Stores all List Owners info Members

Re: Auto-Inc question

In a message dated 22/02/2001 12:22:26 GMT Standard Time, [EMAIL PROTECTED] writes: << 30 seconds work(less time than it took you to type your email) would've revealed the answer: 1. Click on "the manual" link at the bottom of this message. 2. See the search box? Type in "auto increment"

Auto-Inc question

Hi, I have a table which contains a row called ListID which is set to auto increment, I added a load of test data into the table while I built my website so I could test various things out, anyway that is all finished now and I am ready to go live so I have dropped all the test data from the t

Date???

Hi, I`m selecting information from my MySQL as follows... Select * FROM Features WHERE Platform='pc' and Public='Y' Order by DateTime ASC LIMIT 0,3 I am storing the field DateTime as a date when selected it looks like this 2001-05-05 but I want to change it so it looks like May 5th 2001, I`v

Insert into blob

Hi, I am having some problems inserting data into a blob field, everything works fine but if I use any HTML and try to insert it, it doesn`t work. So in short is there something I should be doing to allow HTML to go into a text blob? I am using PHP if that helps. TIA Ade --

Re: OT:Browser-based client UI design question

Hi, I`m not sure if this will be helpful or not but here goes... If the Service calls are always going to be logged manually why not create a Search feature so that he/she can enter in the company name it will search and display the info, then he she makes a note of the comp_id. They do the s

Re: Drop Database

David, Firstly are you sure it`s a database you have created and not a table? Either way try the following DROP DATABASE #Muffin; or DROP TABLE #Muffin; HTH Ade - Before posting, please check: http://www.mysql.com/manual.p

OT - Cron

Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Text Max

Hi, I`m setting up a field in my DB called Description and basically want it to have a max character length of 1000, my MySQL manual tells me varchar is limited to 255 so thats out of the window then it goes on to say text has a max of 64 kb of text and defines all the others in this way. I di

Re: Ideas??

Hi Greg, Thanks for that, perhaps I should drink more coffee help my brain to be a bit more active at 5.30 in the morning. Cheers Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

Ideas??

Hi, I am creating a web site which allows users to post projects and then others to place bids. I am setting up two tables in MySQL 'Projects' & 'Bids' my problem is how best to cross reference. What I was thinking of doing is creating a number of fields in the Projects table... Bid1 Bid2