Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MYSQL query doesn't work if row doesn't exist in a table
- SELECT albums.*, MAX(albums.date) AS newDate
- FROM albums, albumData
- WHERE albums.userID='$id'
- AND albums.state='0'
- AND (
- albums.albumID=0
- OR
- albumData.id=albums.albumID
- AND albumData.state='0'
- )
- GROUP BY albums.albumID, albums.userID
- ORDER BY newDate DESC
- SELECT albums.*, MAX(albums.date) AS newDate
- FROM albums WHERE userID=$id AND albums.state='0'
- GROUP BY albums.albumID ORDER BY newDate DESC
- if($quer['id']&&$quer['state']==0||$albumID==0)
- {//do my stuff here }
- SELECT albums.*
- , MAX(albums.date) AS newDate
- FROM albums
- LEFT JOIN albumData ON albumData.id = albums.albumID
- WHERE albums.userID='$id'
- AND albums.state='0'
- AND (albums.albumID=0 OR albumData.state='0')
- GROUP BY
- albums.albumID
- , albums.userID
- ORDER BY
- newDate DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement