Просмотр поста #63538: >>>ВОПРОСЫ НОВИЧКОВ<<<

.
Screamer

Где здесь может быть ошибка?

$req = mysql_query("SELECT `id`, `text`, `sort` FROM `lib` WHERE `type` = 'cat' AND `refid` = '".$id."' ORDER BY `sort` ASC");
	$total = mysql_result(mysql_query("SELECT COUNT(*) FROM `lib` WHERE `type` = 'cat' AND `refid` = '".$id."'"), 0);
	echo '<table cellpadding="0" cellspacing="0" width="900"><tr>';
	echo '<td width="50"><b>№ п/п</b></td><td><b>Имя категории</b></td><td><b>№_</b></td></tr>';
	echo '<tr><td colspan="3"><form action="admin.php?act=cat" method="post"></td></tr>';
	while ($sort = mysql_fetch_array($req)) {
		$var[] = $sort['sort'];
	}
	while ($cat = mysql_fetch_array($req)) {
		echo '<tr><td align="center">' . $cat['sort'] . '</td>';
		echo '<td>' . $cat['text'].'</td>';
		echo '<td align="left"><select>';
		foreach ($var as $var1) {
		echo '<option value="">'.$var1.'</option>';
		}
		echo '</select></td></tr>';
	}
	echo '<tr><td colspan="3"><input type="hidden" name="total" value="'.$total.'" /><input name="submit" type="submit" value="Упорядочить" /></form></td></tr>';
	echo '</table>';