TalkPHP - View Single Post - Having trouble learning MySQL database codes...

ReSpawN · 01-03-2008, 08:25 PM

The INSERT Query can be formatted as;

PHP Code:


			
// One of the more simply - one way - ... ways.
$resQuery = 'INSERT INTO `field` SET `column1` = `1` WHERE `id` = 1';

It's a lot easies if you have to do tons of inserts and updates. You can simply sum them up underneath each other like so;

PHP Code:


			
$resQuery = 'INSERT INTO `field` SET    `column1` = `1`, 
                                        `column1` = `1`, 
                                        `column1` = `1`, 
                                        `column1` = `1`, 
                                        `column1` = `1`
                                        WHERE `id` = "1"';

01-03-2008, 08:25 PM	#3 (permalink)
ReSpawN The Frequenter Join Date: Nov 2007 Location: Netherlands Posts: 460 Thanks: 49	The INSERT Query can be formatted as; PHP Code: // One of the more simply - one way - ... ways. $resQuery = 'INSERT INTO `field` SET `column1` = `1` WHERE `id` = 1'; It's a lot easies if you have to do tons of inserts and updates. You can simply sum them up underneath each other like so; PHP Code: $resQuery = 'INSERT INTO `field` SET `column1` = `1`, `column1` = `1`, `column1` = `1`, `column1` = `1`, `column1` = `1` WHERE `id` = "1"'; __________________ "Life is a bitch, take that bitch on a ride"