Create HTML table from a search

[Anon]

Hello, I am trying to build a two column table with the results of a select statement, from a mysql database.

I want the results counted, split in half, and put in two columns, 6 results at a time, with a next & previous to get the next 6 records.

The first three would results would go down the first column, and the next three down the second column. Like reading a phone book.

Any one know a tutorial that does this, that I can modify?

cya..mf

[Anon]

Feel free to use this code that partly solves your problem:

function sqlnh($sql,$head="") {
// Utfører et sql kall og skriver resultatet til skjerm (html)
$result = mysql_query($sql);
if (!rader($result,0,0)) {
if ($debug) {
echo "Bibliotekfeil 3: Tomt resultatsett"."<br>";
}
return;
}
$m = mysql_num_rows($result);
$n = mysql_num_fields($result);
echo "<table border=1>";
if ($head) {
echo "<th colspan=".$n.">".$head."</th>";
}
for ($i=0;$i<$m;$i++) {
echo "<tr>";
for ($j=0;$j<$n;$j++) {
echo "<td>";
echo mysql_result($result,$i,$j);
echo "</td>";
}
echo "</tr>";
}
echo "</table>";
}

[kiwi_uk]

I dont quite get what your saying, nearly. If you send me a more detailed statement of what u want and your code i will try and make it do what you want. Im get what you say about passing your results 6 at a time. How do you plan to do this? I mean carry the results page to page. Use one db query and a file, pass all data in headers or make a DB query on every page. I can only help if your a mySQ: dude

[Anon]

I am searching the database for a simple list of fields. Lets just say one, for simplicity sake. The query is done by pasing the search argument thru a URL click. Example: I click a topic called, apparel, and it searches the database for all records with 'apparel ' in the category field. It then returns the name of the coupons. I want to take that list and put it in an html table. the first three results go down the first column an the second three go down the second column. the rest are either cached and parsed 6 at a time, with a next & previous button, or another select statement could be executed with the next & prev buttons. It doesn't matter how its done, only that the results are accessed 6 at a time, and can be stepped thru, 6 at a time. And, yes I do use MySQL. Hope this helps.

cya..mf