|
|
Posted by flamer die.spam@hotmail.com on 07/06/06 04:44
<table>
<tr>
<?php
$query = mysql_query(select blah..);
echo '<td>'.$query.'</td>';
?>
</tr>
</table>
now i assume your pulling multiple rows so you need a "while"
statement, read up on them in the manual php.net they are simple to
use, and excuse the psuedo code.
flamer.
Huevos wrote:
> I scanned through hundreds of posts and tried several variations on some
> promising posts, but have not succeeded yet... All I want to do (to start)
> is have a web page display a table of the result of a query.
>
> I am using MySQL via geocities.yahoo.com. The MySQLAdmin auto generated a
> PHP version of my query as follows:
>
> $sql = 'SELECT * FROM `Varieties` WHERE 1'
> . ' ORDER BY `nHeight` DESC, `nDiameter` DESC, `nMinTemp` ASC,
> `tSun` DESC LIMIT 0, 30 ';
>
>
> I tried to merge this into code from another suggestion in these groups and
> came up with:
>
> <HTML>
> <HEAD>
> </HEAD>
> <BODY>
> <?
> // DATABASE QUERY
> $bamboo='SELECT * FROM `Varieties` WHERE 1'
> . ' ORDER BY `nHeight` DESC, `nDiameter` DESC, `nMinTemp` ASC,
> `tSun` DESC LIMIT 0, 30 ';
> $result= mysql_query($bamboo);
> ?>
>
> <table width="100%" border="0" cellspacing="0" cellpadding="0">
> <tr>
> <td>LINK 1 DETAILS HERE<br>
> DATABASE QUERY: <? $result; ?></td>
> </tr>
> </table>
> <? } ?>
> </BODY>
> </HTML>
>
> Can anyone offer a suggestion?
> Thanks in advance!
>
> Jeff Hawkins
[Back to original message]
|