Perform a query without a view I've created msyql
Posted: Sat Oct 13, 2012 9:04 am
The following is the queries:
I would need not to use the create view query, and instead make it a single query, substitute the select * from f1limit5
Code: Select all
<?php
mysql_query("CREATE VIEW F1LIMIT5 as SELECT DISTINCT albumid from tags WHERE id3='$value' AND flag!='w' AND visibility='t' ORDER BY datetimep DESC limit 5");
$aresult=mysql_query("SELECT * from tags where albumid in (SELECT * FROM F1LIMIT5) and id3='$value' AND flag!='w' AND visibility='t' order by datetimep desc");
?>