|
|
Posted by william.clarke on 11/30/38 11:52
IchBin wrote:
> 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-)
Because you fetched an object using this statement
while ($row = mysql_fetch_object($result))
rather than an associative array using this statement:
while($row=mysql_fetch_assoc($result))
as a result this works: $row->field
and this doesn't: $row['field']
Navigation:
[Reply to this message]
|