UPDATE         thread

INNER         JOIN post ON thread.threadid=post.threadid

SET         thread.title=REPLACE(post.title)

WHERE         post.postid=thread.firstpostid

$sql = "SELECT d.title, d.mktime, COUNT(r.id) FROM documents AS d LEFT JOIN clickreg AS r ON r.docid = d.id"

$val_d = $_POST['Device_num'];    //value submit from user 

$val_l = $_POST['location_area'];  //value submit from user 



$dev_insert = "INSERT INTO device (device_id, device_num)

                VALUES (NULL, '$val_d')";

$results = mysql_query($dev_insert)

                or die (mysql_error());

CREATE TABLE Job_Title

(

Job_ID                        int                        NOT NULL

        PRIMARY KEY(Job_ID),

EEO1_Class                varchar(20)        NOT NULL,

Job_Title                varchar(40) NOT NULL,

Job_Descrip                varchar(100)NOT NULL,

Status                        varchar(10)        NOT NULL

)



CREATE TABLE Employee

(

Emp_ID                        int                        NOT NULL

        PRIMARY KEY(Emp_ID),

Last_Name                varchar(50) NOT NULL,

First_Name                varchar(50)        NOT NULL,

Address                        varchar(50)        NOT NULL,

City                        varchar(25)        NOT NULL,

State                        varchar(20)        NOT NULL,

Phone_AC                char(3)                NOT NULL,

Phone_Num                char(7)                NOT NULL,

Ssn                                char(9)                NOT NULL,

Hire_Date                datetime        NOT NULL,

Salary                        numeric(6,2)        NOT NULL,

Gender                        varchar(6)        NOT NULL,

Birthday                datetime        NOT NULL,

Job_ID                        int        FOREIGN KEY REFERENCES Job_Title (Job_ID)

)

INSERT INTO Employee (Emp_ID,Last_Name,First_Name,Address,City,State,Phone_AC,

        Phone_Num,Ssn,Hire_Date,Salary,Gender,Birthday,Job_ID)

VALUES (62683,'Edelman','Glenn','175 Bishop Lane','La Jolla','California',619,555-0199,112333445,

        10/07/2003,11.25,'male',11/02/1981,004)





INSERT INTO Job_Title (Job_ID,EEO1_Class,Job_Title,Job_Descrip,Status)

VALUES (001,'Office/Clerical','Accounting Clerk','Computes, classifies, records, and verifies numerical

        data for use in maintaining accounting records','NonExempt')

INSERT INTO interest_list (user_id, interest_id, details)

  VALUES

  (1, 1,'somestring1'),

  (1, 2, 'somestring2'), 

 ...etc

IF the record exists where (user_id==1 and interest_id==1) or (user_id==1 and interest_id==2)  ... etc THEN (dont insert but rather update)

UPDATE interest_list

    SET details = CASE interest_id

        WHEN 1 THEN 'somestring1'

        WHEN 2 THEN 'somestring2'

...etc

    END

WHERE interest_id IN (1,2...etc) AND user_id=1;

create table main(id int(10) unsigned NOT NULL AUTO_INCREMENT, fname varchar(25) NOT NULL DEFAULT '', `uid` int(10) unsigned NOT NULL,  PRIMARY KEY (`id`))



insert into main(1, 'abcd', 1), (2,'doll',1), (3,'animals',1)



CREATE TABLE category (

  `cid` int(3) NOT NULL AUTO_INCREMENT,

  `id` int(2) NOT NULL DEFAULT '0',

  `category` varchar(25) NOT NULL DEFAULT '',

  PRIMARY KEY (`cid`)

) 



insert into category(1,1,'abcd1'), (2,2,'doll1')

$row=mysql_select("SELECT * FROM table where id='1'") or die(mysql_error());

$result=mysql_fetch_array($ROW);



$name=$result['name'];

CREATE  TABLE IF NOT EXISTS `accounts` (

  `account_id` INT(10) NOT NULL AUTO_INCREMENT ,

  `username` VARCHAR(255) NOT NULL ,

  `password` CHAR(64) NULL ,

  `email` VARCHAR(255) NOT NULL ,

  `company` VARCHAR(255) NULL ,

  PRIMARY KEY (`account_id`) )  (... remainder of CREATE statement omitted)





CREATE  TABLE IF NOT EXISTS `persons` (

  `person_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,

  `firstname` VARCHAR(45) NOT NULL ,

  `lastname` VARCHAR(45) NOT NULL ,

  `jobtitle` VARCHAR(255) NULL DEFAULT NULL ,

  `phone` CHAR(12) NULL DEFAULT NULL ,

  `email` VARCHAR(255) NOT NULL ,

  PRIMARY KEY (`person_id`) ,

  INDEX `fk_person_account` (`account_id` ASC) ,

  CONSTRAINT `fk_person_account`

    FOREIGN KEY (`account_id` )    (... remainder of CREATE statement omitted)



CREATE  TABLE IF NOT EXISTS `sections` (

  `section_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,

  `name` VARCHAR(255) NOT NULL ,

  `startdate` DATE NULL ,

  `enddate` DATE NULL ,

  `base_price` INT(10) NOT NULL DEFAULT 0 ,

  PRIMARY KEY (`section_id`)     (... remainder of CREATE statement omitted)



CREATE  TABLE IF NOT EXISTS `person_attending_section` (

  `person_id` INT(10) UNSIGNED NOT NULL ,

  `section_id` INT(10) UNSIGNED NOT NULL ,

  PRIMARY KEY (`person_id`, `section_id`) ,

  INDEX `fk_person_has_section_person1` (`person_id` ASC) ,

  INDEX `fk_person_has_section_section1` (`section_id` ASC) ,

  CONSTRAINT `fk_person_has_section_person1`

    FOREIGN KEY (`person_id` )

    REFERENCES `persons` (`person_id` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_person_has_section_section1`

    FOREIGN KEY (`section_id` )

    REFERENCES `sections` (`section_id` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

CREATE  TABLE IF NOT EXISTS `orders` (

  `orders_id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,

  `account_id` INT NOT NULL ,

  `created_on` DATETIME NOT NULL ,

  `person_id` INT(10) UNSIGNED NOT NULL ,

  `section_id` INT(10) UNSIGNED NOT NULL ,

  PRIMARY KEY (`orders_id`) )

(SELECT a, b, c, d, e, f, date FROM table1 WHERE a=10 AND b=1) UNION (SELECT a, b, c, d, e, f, date FROM table1 WHERE a=11 AND b=1) ORDER BY date DESC;

$query = " SELECT *FROM tabela WHERE persons LIKE '%$search%'