Re: mysql result display with php
| From: | Mike Patton | Date: | Mon, 15 Oct 2001 03:16:27 +0000 |
| Subject: | Re: mysql result display with php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-71056@lists.php.net to get a copy of this message | ||
$sth = mysql_query("SELECT * FROM Port1 WHERE date BETWEEN '2001-10-04'
AND '2001-10-11'");
while( $res = mysql_fetch_array( $sth ) ) {
print "RESULT OF field1 is" . $res[field1];
etc...
}
take a look in the docs at the mysql_fetch_array() function.
------------------------------------------------------------------------
James "Mike" Patton \ Professional web applications developer
mpatton@acuitymedia.com \ Specializing in PERL, MySQL, PHP and JAVA
------------------------------------------------------------------------
On 2001.10.14 23:33 sc 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.
>
> -sc
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>