Create a temporary table using php

[parallax]

Hi guys,

i would like to make
create temporary table pagamentos SELECT d.name, SUM(advanced) AS total_advance, f.salario FROM data d JOIN empregados f ON f.name = d.name where MONTH(d.date) = 04 group by name;

and after select all

select * from pagamentos;

in a php script... could someone help me???

thanks


Danylo Iamaguchi

[pbmods]

Moved to MySQL forum.

Are you trying to create a view?

CREATE VIEW pagamentos AS SELECT d.name, SUM(advanced) AS total_advance, f.salario FROM data d JOIN empregados f ON f.name = d.name group by name;
SELECT * FROM pagamentos where MONTH(d.date) = 04;
 

To execute this in PHP:

//  You'll probably want to execute this first line manually...
mysql_query("CREATE VIEW pagamentos AS SELECT d.name, SUM(advanced) AS total_advance, f.salario FROM data d JOIN empregados f ON f.name = d.name group by name");
mysql_query("SELECT * FROM `pagamentos` WHERE MONTH(d.date) = '04'");
 

Check out this thread:
http://www.thescripts.com/forum/thread642508.html

[parallax]

thanks... i was using create table because on the mysql's shell works ok....

thanks a lot