--- whoisquilty <[EMAIL PROTECTED]> wrote:
> I'd like to be able to return results from a query in two columns of a
> table.
>
> First result in column 1, row 1.
> Second result in column 2, row 1.
> Third results in column 1, row 2.
> Fourth result in column 2, row 2.
>
> How would I do this? I thought about using if's.
>
> Is there a command to return results with different code for every
> other result?
>
> Jeremy
Are you concerned with the HTML display of this data or the SQL query? Are
there only four results or is this a simple example?
In the case of an HTML table, it looks like you would have:
+--------+---------+
| First | Second |
+--------+---------+
+ Third | Fourth |
+--------+---------+
If so, then you want each result to display in its own <td> element. However,
after every even result, you want to insert a </tr><tr> to drop to the next row
of the HTML table. If this is an arbitrary length then we could be concerned
with an extra open <tr> at the end.
$db = mysql_connect(...);
$resource = mysql_query(..., $db);
$result = 1;
$html = "<table><tr>";
while ($data = mysql_fetch_row($resource))
{
$html .= sprintf("<td>%s</td>", $data[0]);
$html .= ($result++ %2) ? "</tr><tr>" : "";
}
$html = substr($html, 0, -4); // get rid of last four characters ("<tr>")
print $html;
Doubtless this will need to be refined for your needs.
James