Kód: Vybrať všetko

$result = mysql_query("SELECT * FROM WEBSITE WHERE id_account = '$id_account'");
for($count = 0; $count < mysql_num_rows($result); $count++ ) {
    $website_name = mysql_result($result, $count, "website_name");
    $id_page = mysql_result($result, $count, "id_page");
    echo "<option value=\"$id_page\">$website_name</option>";
}

Kód: Vybrať všetko

$ids = array();
$result = mysql_query("SELECT * FROM WEBSITE WHERE id_account = '$id_account'");
for($count = 0; $count < mysql_num_rows($result); $count++ ) {
    $website_name = mysql_result($result, $count, "website_name");
    $ids[mysql_result($result, $count, "id_page")] = $website_name;
}

$smarty->assign('ids', $ids);

Kód: Vybrať všetko

{html_options name=ids options=$ids}

Kód: Vybrať všetko

$result = mysql_query("SELECT * FROM table WHERE id  = '$id'");
for($count = 0; $count < mysql_num_rows($result); $count++ ) {
    $value1 = mysql_result($result, $count, "id1");
    $value2 = mysql_result($result, $count, "id2");
    $value3 = mysql_result($result, $count, "id3");
    $value4 = mysql_result($result, $count, "id4");
    $value5 = mysql_result($result, $count, "id5");

echo "<div>
<span>$value1</span>
<span>$value2</span>
<span>$value3</span>
<span>$value4</span>
<span>$value5</span>
</div>"

}

Kód: Vybrať všetko

$result = mysql_query("SELECT * FROM table WHERE id  = '$id'");
while($row = mysql_fetch_assoc($result)) $data[]=$row;

$echo="";
foreach($data as $row):
  $echo.="<div>\n";
    foreach($row as $column)
      $echo.="<span>$column</span>\n";
  $echo.="</div>\n";
endforeach;
echo $echo;