formatting text

deolsabh

I need help in formattting text i want output from my php result to be dispalyed in 4 columns
Actally i want to print address label from result
please help

Alternative also welcome

laserlight

I think you will need to explain in greater detail what you want.

Where is your input coming from, and how exactly do you intend your output to be like? 4 columns is a little vague.

deolsabh

i want out put like
name name name name
address address address address
so that i can print out put to a page (address label)
please help

here is my code

more resultsorg.php

<html>
<head>
<title>Search Results</title>
</head
<body>
<h1>search results</h1>
<?
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];

$searchterm=trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo "You have not entered search details. Please try again.";
exit;
}
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);

@ $db = mysql_pconnect("localhost", "", "");

if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}

mysql_select_db("db");
$query = "select * from customers where ".$searchtype." like
'%".$searchterm."%' order by name";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);

die('MySQL error: ' . mysql_error() . '<br>Query: ' . $query);

echo "<p>Number of customers found: ".$num_results."</p>";

if( mysql_num_rows($result) > 0 )
{
echo("
<table>
<tr>
<td>term</td>
<td>term</td>
<td>term</td>
<td>term</td>
</tr>
");
}
while( $row = mysql_fetch_array($result) )
{
echo("
<tr>
<td>$row[name]</td>
<td>$row[last]</td>
<td>$row[street]</td>
<td>$row[city]</td>
<td>$row[state]</td>
<td>$row[zip]</td>
</tr>
");
}
if( mysql_num_rows($result) > 0 )
{
echo("</table>");
}
}
?>
</body>
</html>