i tried to read the manual, lol

[dv6cougar]

it's way too big, i was trying to find a function and yes i did search.

what i need to do is to have it display 2 results next to one another and then 2 more below that and so on... if it were plain html it would look like this

<table>
<!--while($row = mysql_fetch_array($somequery)) {-->
<!--would go here i would presume-->
<tr>
<td>
Info 1
</td>
<td>
Info 2
</td></tr>
<tr>
<td>
Info 3
</td>
<td>
Info 4
</td></tr>
<!--} end your while-->
</table>

now i'm pretty sure that there would be some logical way to do this, as i've seen ti done plenty of times, just never done it myself.

do you use 2 queires maybe ?

any help is greatly appreciated!

[jclout]

Not my code but try something like this:

$i = 1; 
$cols = 3; 

echo "<table border='1' width='100%'><tr>";

while ($row=mysql_fetch_array($query)) {
    if ($i > $cols) {
       echo "</tr><tr>";
       echo "<td>" . $row["linkname"] . "</td>";
       $i = 2;
    } else {
       echo "<td>" . $row["linkname"] . "</td>";
       $i++;
    }
}
echo "</table>";

Or try this:

<?php
echo "<table width=\"100%\" border=\"1\" bordercolor=\"#FFFFFF\">"; 
    $j = 0; 
    $rownum = 0;     

    $result = mysql_query($query); 
    if (($result = @ mysql_query ($query, $connection))){ 
        while ($row = mysql_fetch_array($result)){ 
            if($j == $rownum) { 
                echo "<tr>"; 
                $rownum += 2; //<------- REPLACE 2 WITH NUMBER OF RECORDS PER ROW 
            } 
            echo "<td>";
            echo mysql_result($result,$i,letter);
            echo "</td>"; 
        ++$j;
        } 
        if($j == $rownum) { 
            echo "</tr>"; 
        } 
    } 
    echo "</table>";
?>

[dv6cougar]

well i figured it out, haha, it was much easier then i thoguth after i figured it out, just use a counter 🙂

$counter = 0;
?>
<table><tr>
<?
while($row = mysql_fetch_array($result)) {

?><td><center>
<?
							  if($counter > 2) {
							  echo "</tr><tr>";
							  }
							  $counter++;
							  ?>
                              <b><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Make:</font></b><font face="Verdana, Arial, Helvetica, sans-serif" size="2">&nbsp; 
                              <? echo $row["2"]; ?>
                              <br>
                              <b>Model:</b>&nbsp; 
                              <? echo $row["3"]; ?>
                              <br>
                              <b>Generation:</b>&nbsp; 
                              <? echo $row["1"]; ?>
                              <br>
                              <b>Years:</b>&nbsp; 
                              <? echo $row["4"]; ?>
                              </font><br>
  <br></center>
<hr color="#444F67" width="200"><br><br></td>
<?
}
?>

only problem is it does one result all the way down to the last 2 and it displays those 2 correctly....

what did i do wrong ?

thanks! 😃

[dv6cougar]

jclout-
i tried that with no luck 🙁

it didn't give me any results at all but the count of 18 was correct 🙁

thanks alot though! any ideas on my script??

[jclout]

Give me the names of your fields

Make:
Model:
ect:

[dv6cougar]

nevermind i got it...

i played around with what you gave me jclout, and i set the digits and what not and i got it now.

rewrote the script from scratch and it worked.

thanks alot! 🙂