$db = mysql_open();

$results = mysql_query( "select * from something", $db );

while( $row = mysql_fetch_array( $results ) ) {
      ....processing using $row["column"] as reference
}


Ben

At 11:21 05/04/2002, Phil Ewington wrote:

>Hi All,
>
>I am new to PHP and am having a bit of trouble. I have a recordset using...
>
>$events = mysql_fetch_array($recordset);
>
>this drags in 3 columns from my table...
>
>event_id, event_title, event_date
>
>I want to search the recordset for a given date, if found I want to be able
>to reference event_id & event_title from the row. I am using PHP 4.01.
>
>TIA
>
>Phil Ewington.
>
>---
>P.S. If there are any ColdFusion developers on this list, what is the PHP
>equivalent of a structure?
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php

****************************************************************
* Ben Edwards                              +44 (0)117 9400 636 *
* Critical Site Builder    http://www.criticaldistribution.com *
* online collaborative web authoring content management system *
* i-Contact Progressive Video      http://www.videonetwork.org *
* Smashing the Corporate image       http://www.subvertise.org *
* Bristol Indymedia               http://bristol.indymedia.org *
* Bristol's radical news             http://www.bristle.org.uk *
* PGP : F0CA 42B8 D56F 28AD 169B  49F3 3056 C6DB 8538 EEF8     *
****************************************************************

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to