Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "SELECT COUNT(u.url) AS total, u.SiteTypeID, p.SiteType FROM sites AS u LEFT JOIN sitetypes AS p USING (SiteTypeID) WHERE SiteTypeID=3";
- $sq2 = mysqli_query($dbc, $sql);
- $sq3 = "SELECT COUNT(u.url) AS total, u.SiteTypeID, p.SiteType FROM sites AS u LEFT JOIN sitetypes AS p USING (SiteTypeID) WHERE SiteTypeID=4";
- $sq4 = mysqli_query($dbc, $sq3);
- $sq5 = "SELECT COUNT(u.url) as total, u.SiteTypeID, p.SiteType FROM sites AS u LEFT JOIN sitetypes AS p USING (SiteTypeID) WHERE SiteTypeID=5";
- $sq6 = mysqli_query($dbc, $sq5);
- echo $row['url'] $row['SiteType'];
- echo $row2['url'] $row2['SiteType'];
- echo $row3['url'] $row3['SiteType'];
- <?php
- $sql = "SELECT COUNT(u.url) AS total, u.SiteTypeID, p.SiteType
- FROM sites AS u
- LEFT JOIN sitetypes AS p USING (SiteTypeID)
- WHERE SiteTypeID IN (3, 4, 5)
- GROUP BY u.SiteTypeID, p.SiteType";
- if ($sql2 = mysqli_query($dbc, $sql))
- {
- while ($row = mysqli_fetch_assoc($sql2))
- {
- echo $row["total"].." - ".$row["SiteTypeID"].." - ".$row["SiteType"]."<br >";
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement