format content for display in table???

[jpfour23]

Doubt my subject makes any sense, but I can't figure this one out.

I am querying a database for a user who made a search. I am trying to figure out how to display the results in a table with 2 columns. I could just display it like:

echo "Title: $title<br>Etc: $etc";

But I want to organize it so that there are two columns.. How can I divide the content thats been queried so it results in something similar to this:

echo "<table>";
echo "<tr>";
echo "<td>$title[1]</td><td>$title[2]</td>";
echo "</tr>";

I assume I'd use a 'while' or 'for' function and somehow get the SQL Query into an array that holds COLUMN 1 and COLUMN 2... but I don't know how to do this.

ANy suggestions?
Josh

[JLW]

In the past I have put the values in an array like this

1. select whatever you need from the database
2. then use the following after your select statement

session_register('Array');
$check_sql= mysql_num_rows($sql);
	if($check_sql > 0){
	while($row = mysql_fetch_array($sql)){
		foreach( $row AS $key => $val){
			$$key = stripslashes($val);
		}
		session_register('Item');
$Array[] = $Item; //puts next value into array
		}//end while

this puts whatever you are getting from the database into an array ($Array)

3.You can use foreach to print out the array or just a for loop, whatever you are comfortable with

If you use a for loop get the size of the array
like this :
$SizeofArray = count($Array);
then do the for loop

set up the table
echo "<table>";
echo "<tr>";
for($i=0; $i<$SizeofArray; $i++){
echo "<td>";
echo $Array[$i];
echo "</td>";
}
echo </tr>
echo </table>

And that is one way you could do it.

[razz]

What I do is as follows, but be aware you can do many types of loops and they all have advantages or dis-advantages.

// First do you query:

$result = mysql_query("SELECT * FROM table WHERE condition");

// Count the result

$num = mysql_num_rows($result);

// Test the num to make sure there is a record

if ($num > 0)
{

// Start the table

echo '<table>';
echo '<tr><td>Title 1</td></tr>';
echo '<tr><td>Title 2</td></tr>';
echo '<tr><td>Title 3</td></tr>';

//Loop the rows

      for($i = 0; $i < $num; $i++)
          {
            $row = mysql_fetch_array($result);
            echo '<tr>';
            echo '<td>'.$row['fieldname1'].'</td>';
            echo '<td>'.$row['fieldname2'].'</td>';
            echo '<td>'.$row['fieldname3'].'</td>';
            echo '</tr>';
           }

// End Table

echo '</table>';

Thats the short version but it may help,

Razz