Moving my SQL to different location other than in my script.

[fjm]

I would like to move several sql statements outside of my php script but have yet to be successful.

I moved the sql to a different location/directory then tried to call the sql with an include tag within the php but it doesn't work.

The reason I want to move the sql away from the php script is to make it more readable. My sql view is ove 20 lines. I also need to add about 5 more views into this php script.

Thanks.

Frank

[pbmods]

Your views are over 20 lines, or your queries are over 20 lines?

http://www.thescripts.com/forum/thread642508.html

[fjm]

Your views are over 20 lines, or your queries are over 20 lines?

http://www.thescripts.com/forum/thread642508.html

pbmods, it was actually the query. My views are as simple as select * from view_tbl.

I forgot to create the view. :blush:

Thanks for that link. That is a good read for sure.

Let me ask you this, is there any way that I can update my base tables through a view? What I have are 14 tables I am joining through this view. I know that mysql supports updatable views but I can't seem to get the views to update. I just get an error saying that the view cannot update the base tables.

I am using mysql 5.0.27.

I am going to read the link you provided also to see if I can find the answer in there.