$res = mysql_query("SELECT MAX(time) as 'max' FROM input_information WHERE ip = $ip ");
while($row = mysql_fetch_assoc($res))
$time_old = $row['max'];
Выводит сообщение:
$res = mysql_query("SELECT MAX(time) as 'max' FROM input_information WHERE ip = $ip ");
while($row = mysql_fetch_assoc($res))
$time_old = $row['max'];
Цитата |
Предупреждение: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given |
Цитата (Владимир55 @ 27.02.2016 - 19:01) |
Как это сделать правильно? |
$res = mysql_query("SELECT MAX(`time`) as 'max' FROM `input_information` WHERE ip = $ip ");
while($row = mysql_fetch_assoc($res))
$time_old = $row['max'];
Цитата |
На форуме: 4 года, 10 месяцев, 19 дней |
Цитата (Владимир55 @ 27.02.2016 - 19:17) |
as 'max' |
SELECT MAX(`id`) FROM `table` WHERE `uid`='36';
$res = mysql_query("SELECT MAX (`time`) FROM `input_information`
WHERE `ip` = '188.166.91.5'");
while($row = mysql_fetch_assoc($res))
$time_old = $row['time'];
Цитата |
Предупреждение: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given |
$res = mysql_query("запрос") or die(mysql_error());
$query = "SELECT MAX(`time`) as `max` FROM `input_information` WHERE `ip` = '$ip' ";
echo $query;
$res = mysql_query($query) or die(myssql_error());
if($res){
if(mysql_num_rows($res) > 0){
while($row = mysql_fetch_assoc($res))
$time_old = $row['max'];
}
}
Цитата |
'max' |