Re: [PHP-DB] Displaying data using php From: Jason G. (blair <email protected>)
Date: 10/15/01

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 <email protected>
>For additional commands, e-mail: php-db-help <email protected>
>To contact the list administrators, e-mail: php-list-admin <email protected> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>