TalkPHP - View Single Post - Dozens of questions which I cannot find. v_v

Orc · 01-31-2008, 03:03 AM

Heres some questions which I cannot find online, cause it's all about crap PHP Tutorials with MySQL. Now

How would I insert two querys at once? in the same variable:

PHP Code:


			
$query = "SELECT * FROM `table`,
          INSERT INTO `table` (id,name,blah) VALUES(, 'blah', 'blah', 'blah');

How would I assign tables/columns/etc to a different column, say I wanted to inherit some columns like so:

PHP Code:


			
// I want t1's users to be t2's users
$query = " SELECT t1.users,t2.users FROM t1,t2
SET `table1` AS `t1` AND `table2` AS `t2`";

How would I edit columns in the tables?

PHP Code:


			
 $query = "TRUNCATE `table` WHERE `blah`='$blah'";

How would I move values from columns to other columns?

That's all the questions I have for now, I might ask some more later.. HALP!

01-31-2008, 03:03 AM	#1 (permalink)
Orc The Prestige Join Date: Dec 2007 Posts: 1,044 Thanks: 193	Dozens of questions which I cannot find. v_v Heres some questions which I cannot find online, cause it's all about crap PHP Tutorials with MySQL. Now How would I insert two querys at once? in the same variable: PHP Code: $query = "SELECT * FROM `table`, INSERT INTO `table` (id,name,blah) VALUES(, 'blah', 'blah', 'blah'); How would I assign tables/columns/etc to a different column, say I wanted to inherit some columns like so: PHP Code: // I want t1's users to be t2's users $query = " SELECT t1.users,t2.users FROM t1,t2 SET `table1` AS `t1` AND `table2` AS `t2`"; How would I edit columns in the tables? PHP Code: $query = "TRUNCATE `table` WHERE `blah`='$blah'"; How would I move values from columns to other columns? That's all the questions I have for now, I might ask some more later.. HALP! __________________ VillageIdiot can have my babbies ;d