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 =

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

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".

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,

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

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)

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:

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

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)