|
|
Posted by IchBin on 07/07/06 05:31
IchBin wrote:
> Gulasch wrote:
>> IchBin wrote:
>>> 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-)
>>
>> If you have let's say
>>
>> --snip--
>> $sql="SELECT field FROM table";
>> $result=mysql_query($sql, $connection);
>> --snap--
>>
>> you could do for example
>>
>> --snip--
>> echo "<select size=1>";
>> while($row=mysql_fetch_assoc($result))
>> {
>> echo "<option>". $row['field'] ."</option>";
>> }
>> echo "</select>";
>> --snap--
>>
>> to get a Drop-Down-List.
>
> Thank you so much...
>
Thanks again.. I am able to load and display the dropdownlist.
Not sure why but I still had a problem with using:
echo "<option>".$row['field']."</option>";
But can get to work using this statement:
echo "<select size=10>";
while ($row = mysql_fetch_object($result)) {
echo "<option>".$row->field."</option>";
}
echo "</select>";
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]
|