Displaying 2 rows?

Anon

I have a page with links, pulled out from a mysql database. Right now I'm just displaying them on the page. But it seems a bit empty now. Now the output is one big html table with rows for each link. I want to make a html table with 2 columns so you would have 2 links next to each other. How can I do this.

An example is at: http://www.php.net/quickref.php where you can see two columns of functions. I want to do the same things with links

I looked into the source already but they look at the files in a directory and I need to get it from a database...

So, could anyone please help me? 🙂

Anon

Sorry the title should read:
Displaying 2 columns?

My bad 🙂

hiasl

Hi Ticalleh,

I suppose you the output with something like:

$row = mysql_fetch_array() {
echo "<tr><td>".$row[link]."</td></tr>";
}

now it's easy if you just want to put one result in the left col and one in the right, the again one left, one right...just add a second mysql_fetch_array and a second column

while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>".$row[link]."</td>";
$row = mysql_fetch_array($result)
echo "<td>".$row[link]."</td>";
echo"</tr>";
}

however this could propably cause PHP to output an error message, if the amount of result are odd (this can't be difficult to suppress however)

if you want to do it like at php.net, you must first count the number of results using

$count = mysql_num_rows($result)

and you must assign the whole result into an array, so that you can directly output a specific result:

the loop for doing this is:

while ($row = mysql_fetch_array($result)) {
$result_array[] = $row;
}

now you can directly output one specific result:

echo $row[12][link];

if you know the amount of results just devide it by two, and make a while loop for the output:

let's say you habe 24 results, that means you have to ouput:

$row[0][link] and $row[11][link]; then:
$row[1][link] and $row[12][link]; then:
$row[2][link] and $row[13][link];
... and so on!

good luck!
Matthias