creatin a view to program with php

[orangelight]

Hi
I have just started to look at mysql and php. I had to download mysql 4.0 as i had problems running mysql 4.1+.

Basically I want to know is in SQL2000 i can create a view, I was told I cannot create them in mysql and was wondering how I overcome this problem when programming in php.

many thanks
hesh

 

[sleipnir214]

You're right, MySQL does not support the concept of views.

But I've never considered their lack a problem. Not even an inconvenience, really.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Borvik]

sleipnir213 is correct - however with the upcoming MySQL 5.0 views will be supported see

http://dev.mysql.com/tech-resources/articles/mysql-views.html

for more details.

Still waiting on a release for it - but as soon as it comes out I'm going for it!