scvinodkumar Posted January 24, 2009 Share Posted January 24, 2009 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? Quote Link to comment https://forums.phpfreaks.com/topic/142259-creating-views-and-inserting-into-views/ Share on other sites More sharing options...
fenway Posted January 27, 2009 Share Posted January 27, 2009 Well, you're trying to make the same view over and over again. Quote Link to comment https://forums.phpfreaks.com/topic/142259-creating-views-and-inserting-into-views/#findComment-747529 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.