- $link = mysql_connect("$hostname", "$username", "$password")
- or die("Could not connect : " . mysql_error());
- mysql_select_db("$dbName") or die("Could not select database");
- $result = mysql_query("SELECT id, title FROM data WHERE name_section='1' ORDER BY id", $link) or die("Query failed : " . mysql_error());
- $n = "1";
- $line = mysql_fetch_array($result);
- do
- {
- $n++;
- printf ("<table>
- <tr>
- <td>
- <ul>
- <li><a href='a.php?id=%s'>%s</a></li><br>
- <ul>
- </td>
- </tr>
- </table>", $line["id"], $line["title"]);
- }
- while ($line = mysql_fetch_array($result) AND $n < '6');