ОБСУЖДЕНИЕ

Как правилно

8 сообщений0 просмотровОткрыта
#1
<?
/******************************************************************************/
$q=mysql_fetch_array(mysql_query("SELECT * FROM `city` WHERE `city_id`='$ank[mycity]' LIMIT 1"));
$stra=$q['country_id'];
$regi=$q['region_id'];
$qregi=mysql_fetch_array(mysql_query("SELECT * FROM `region` WHERE `region_id`='$regi' LIMIT 1"));
$qcoun=mysql_fetch_array(mysql_query("SELECT * FROM `country` WHERE `country_id`='$stra' LIMIT 1"));
/******************************************************************************/
$d1sql = mysql_query("SELECT COUNT(*) FROM `frends_new` WHERE (`user` = '$user[id]' AND `to` = '$ank[id]') OR (`user` = '$ank[id]' AND `to` = '$user[id]') LIMIT 1");
$d2sql = mysql_query("SELECT COUNT(*) FROM `frends` WHERE (`user` = '$ank[id]' AND `frend` = '$user[id]') OR (`user` = '$user[id]' AND `frend` = '$ank[id]') LIMIT 1");
/******************************************************************************/
$avkom=mysql_result(mysql_query("SELECT COUNT(*) FROM `avkom` WHERE `id_user_adm` = $ank[id] ",$db), 0);
/******************************************************************************/
$k_p_g=mysql_result(mysql_query("SELECT COUNT(*) FROM `us_guest` WHERE `id_user_adm` = $ank[id] ",$db), 0);
/******************************************************************************/
$blog=mysql_result(mysql_query("SELECT COUNT(*) FROM `blog_list` WHERE `id_user` = '$ank[id]'"),0);
/******************************************************************************/
$foto=mysql_num_rows( mysql_query( "SELECT `id` FROM `gallery` WHERE `id_user`='$ank[id]'"),0);
/******************************************************************************/
$prezent=mysql_result(mysql_query("SELECT COUNT(*) FROM `present_give` WHERE `id_give` = $ank[id] ",$db), 0);
/******************************************************************************/
$audio=mysql_result(mysql_query("SELECT count(*) FROM `audio_file` WHERE `id_user`='$ank[id]'"),0);
/******************************************************************************/
$filse=mysql_result(mysql_query("SELECT COUNT(*) FROM `obmennik_files` WHERE `id_user` = '$ank[id]'"),0);
/******************************************************************************/
$chit=mysql_result(mysql_query("SELECT COUNT(*) FROM `my_guests` WHERE `id_ank` = '$ank[id]'"),0);
/******************************************************************************/
$comm=mysql_num_rows(mysql_query("SELECT `id` FROM `community_user_incomm` WHERE `uid` = '$ank[id]'"));
/******************************************************************************/
$pol=($ank['pol']==1) ? '' : '(а)';
/******************************************************************************/
$perehodu=mysql_result(mysql_query("SELECT `perehodu` FROM `user` WHERE `id` = '$ank[id]' LIMIT 1",$db), 0);
/******************************************************************************/
if (isset($user) && $user['id']!=$ank['id'])
{mysql_query("UPDATE `user` SET `prosm` = '".($ank['prosm']+1)."' WHERE `id` = '$ank[id]' LIMIT 1");}
/******************************************************************************/
?>

как их правильно записать
#2
Вопроса не понял. Ты имеешь ввиду правильно в плане синтаксиса? Или в плане куда их записать? Или у тебя что-то не работает просто?
#3
Notice: Undefined index: mycity in /home/usr/data/kickkms/public_html/settings/info/count.php on line 3

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/usr/data/kickkms/public_html/settings/info/count.php on line 3

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/usr/data/kickkms/public_html/settings/info/count.php on line 6

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/usr/data/kickkms/public_html/settings/info/count.php on line 7

Warning: mysql_result() expects parameter 1 to be resource, boolean given in /home/usr/data/kickkms/public_html/settings/info/count.php on line 14

Warning: mysql_num_rows() expects exactly 1 parameter, 2 given in /home/usr/data/kickkms/public_html/settings/info/count.php on line 18

Warning: mysql_result() expects parameter 1 to be resource, boolean given in /home/usr/data/kickkms/public_html/settings/info/count.php on line 22

Warning: mysql_result() expects parameter 1 to be resource, boolean given in /home/usr/data/kickkms/public_html/settings/info/count.php on line 26

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/usr/data/kickkms/public_html/settings/info/count.php on line 28
#4
Может ты базу просто не залил?
#5
залил
#6
Могу сказать как скрыть нотис и варнинг)





Лучше всего исправить код так, чтобы оно непоявлялось!
...................
#7
Не знаю, так с ходу и не скажешь. Попробуй мускул эррор функцию (в гугл за подробным описанием). Она вроде как выдает в чем конкретно и где ошибка.
#8
"правильно"