CodingForums.com - View Single Post

Fou-Lu · 01-30-2013, 10:16 PM

: squint :
Why you have two queries there?

Code:

SELECT ss.status, ss.id, ss.site
FROM site_status ss
RIGHT JOIN votingsite v ON v.VotingSiteType = ss.id
WHERE v.CheckedForVoting = 1 AND v.userid = $uid

01-30-2013, 10:16 PM	PM User \| #7
Fou-Lu God Emperor Join Date: Sep 2002 Location: Saskatoon, Saskatchewan Posts: 15,635 Thanks: 4 Thanked 2,448 Times in 2,417 Posts	: squint : Why you have two queries there? Code: SELECT ss.status, ss.id, ss.site FROM site_status ss RIGHT JOIN votingsite v ON v.VotingSiteType = ss.id WHERE v.CheckedForVoting = 1 AND v.userid = $uid __________________ As of PHP 5.5, the MySQL library has been officially deprecated. It is recommended to move to either MySQLi or PDO libraries for your mysql connectivity. See here for help choosing which interface you prefer: http://php.net/manual/en/mysqlinfo.api.choosing.php