Inserting data into Views

[scvinodkumar]

Hello there,

 

I am vinod. I have a problem in creating view in for loop. Let me explain clearly,

 

I have a list of items for different categories.

 

I want to store the records for every ten minutes in a temporary table.

 

so i go with "creating view".

 

This is the loop i have currently,

 

for($i=0;$i<count($category);$i++)

{

$sql = "CREATE VIEW items_temp AS SELECT * FROM items WHERE cat_id=".$category[$i];

mysql_query($sql);

}

 

here, when the loop executes first time it will success, but when it comes for second time, i get the error

"items_temp" table already exists.

 

i dont know how to insert the records in the view table?

 

please help me

 

sorry for my bad english?

[DeanWhitehouse]

do

for($i=0;$i<count($category);$i++)
{
if($i == 0)
     $sql = "CREATE VIEW items_temp AS SELECT * FROM items WHERE cat_id=".$category[$i];
else
     $sql = "INSERT INTO items_temp (column1,column2) VALUES ('value','')";
mysql_query($sql);
}