+/-
codice:<?php $conn = mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("html") or die(mysql_error()); $sql = "SELECT sottomenu.nome, sottomenu.url, principale.nome FROM sottomenu LEFT JOIN principale ON sottomenu.idp = principale.id"; $rs = mysql_query($sql) or die(mysql_error()); while ($row = mysql_fetch_array($rs)) { $voci[$row[2]][] = $row[0]; $link[$row[2]][] = $row[1]; } $i = 0; foreach($voci as $k => $v) { $var = 'voci[' . $i . ']=newArray("' . $k . '", '; foreach ($v as $kk => $vv) { $var .= '"' . $vv . '", '; } $var = substr($var, 0, -2); $var .= ")\n"; print $var; $i++; } $i = 0; foreach($link as $k => $v) { $var = 'link[' . $i . ']=newArray("/", '; foreach ($v as $kk => $vv) { $var .= '"' . $vv . '", '; } $var = substr($var, 0, -2); $var .= ")\n"; print $var; $i++; } ?>

Rispondi quotando