есть запрос
PHP |
mysql_query("SELECT COUNT(*) AS count_comm FROM commentary GROUP BY id_field and category='news' ORDER BY count_comm DESC LIMIT 1") |
PHP |
mysql_query("SELECT name FROM news WHERE id='$id_news'") |
SQL |
SELECT COUNT(*) AS count_comm, name FROM commentary GROUP BY id_field and category='news' ORDER BY count_comm DESC LIMIT 1 |
PHP |
mysql_query("SELECT news.id, news.name, COUNT(commentary.id_field) AS count_comm FROM commentary LEFT JOIN news ON commentary.id_field=news.id GROUP BY commentary.id_field and commentary.category='news' ORDER BY count_comm DESC LIMIT 1" |
SQL |
SELECT news.id, news.name, COUNT(commentary.id_field) AS count_comm FROM commentary LEFT JOIN news ON commentary.id_field=news.id GROUP BY commentary.id_field AND commentary.category='news' ORDER BY count_comm DESC LIMIT 1 |
PHP |
SELECT news.id, news.name, |
PHP |
/* Последние зарегистрированные пользователи, день рождения */ |
PHP |
/*день рождения*/ |
Цитата (live Uucyc @ 26.06.2009 - 11:47) |
желательно проверять так каждый запрос. не важно, уверен в том, что обязательно должно что-то быть? |