Re: Displaying data using php

Have you verified that the query returns good data? If it doesn't, then you may need to quote the dates: "date > '2000-10-10' and date < '2001-10-10'" as for the output, try this: <table>

        <?
        while($oRow = mysql_fetch_object($test))
        {
                ?>
                <tr>
                        <td><? echo(htmlspecialchars($oRow->field1)); ?></td>
                        <td><? echo(htmlspecialchars($oRow->field2)); ?></td>
                        <td><? echo(htmlspecialchars($oRow->field3)); ?></td>
                </tr>
                <?
        }
        ?>

</table> At 02:02 PM 10/15/2001 +1000, Devon wrote:

Hey guys, I have a script that searches between dates but i cant get the specific data in the rows etc. to display at all... Can anyone help me with displaying this data? Thx. This is the line that we have selecting what we want: $test = mysql_db_query("Syd-01", "SELECT * FROM Port1 WHERE date > 2001-10-04 AND date < 2001-10-11"); And we are having trouble displaying that data in php with rows & columns etc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net