(23 мар 2016, 22:47) (0/0)
[0]
<?
$visit = mysql_fetch_assoc(mysql_query("SELECT * FROM `who_theme` WHERE `theme` = '".$id."'"
);
if($visit['us'] != $user['id']) {
mysql_query("INSERT INTO `who_theme` SET `theme` = '".$id."', `us` = '".$user['id']."', `time` = '".time()."'";
}else{
mysql_query("UPDATE `who_theme` SET `time` = '".time()."' WHERE `us` = '".$user['id']."'";
}
?>
$visit = mysql_fetch_assoc(mysql_query("SELECT * FROM `who_theme` WHERE `theme` = '".$id."'"
);if($visit['us'] != $user['id']) {
mysql_query("INSERT INTO `who_theme` SET `theme` = '".$id."', `us` = '".$user['id']."', `time` = '".time()."'"
; }else{
mysql_query("UPDATE `who_theme` SET `time` = '".time()."' WHERE `us` = '".$user['id']."'"
;}
?>
(23 мар 2016, 22:40) (0/0)
[0]
Когда это создается несколько записей? Когда ты гость?
Попробуй
<?php
if(!empty($user)){
$visit = mysql_fetch_assoc(mysql_query("SELECT * FROM `who_theme` WHERE `id` = '".$id."'");
if($visit['us'] != $user['id']) {
mysql_query("INSERT INTO `who_theme` SET `theme` = '".$id."', `us` = '".$user['id']."', `time` = '".time()."'";
}else{
mysql_query("UPDATE `who_theme` SET `time` = '".time()."' WHERE `us` = '".$user['id']."'";
}
}
?>
Попробуй
<?php
if(!empty($user)){
$visit = mysql_fetch_assoc(mysql_query("SELECT * FROM `who_theme` WHERE `id` = '".$id."'"
);if($visit['us'] != $user['id']) {
mysql_query("INSERT INTO `who_theme` SET `theme` = '".$id."', `us` = '".$user['id']."', `time` = '".time()."'"
; }else{
mysql_query("UPDATE `who_theme` SET `time` = '".time()."' WHERE `us` = '".$user['id']."'"
;}
}
?>
- 1 из 1
