|
|
Posted by IchBin on 07/06/06 20:30
flamer die.spam@hotmail.com wrote:
> <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
>
Not to add another question to this question but how would this be done
with a dropdown list?
Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
__________________________________________________________________________
'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)
Navigation:
[Reply to this message]
|