retrieving data from the database

[knowledg3]

hi

using PHP4
and MS Access 2000

i want to use the select statement below to retrieve items(duh) and stick them into sepearte variables so i can transport them to another page.

$sql ="select EventNo, EventTech, EventDate
           from Event
           where EventNo = $TicketNo";

$conn->Execute($sql);

how would i go about putting the items into seperate variables

btw...I'm with stupid😕

[bastien]

from the link to the article about adodb

while (!$rs->EOF) {
    print $rs->fields[0].' '.$rs->fields[1].'<BR>'; 
     // fields[0] is surname, fields[1] is age
    $rs->MoveNext();  //  Moves to the next row
  }  // end while

the above shows that the fields are in an array similar to the regular result for a php query

you could place them into sessions

by simply doing this

$_SESSION['eventno']=$rs->fields[0];  //first in array of values
$_SESSION['evetntech']=$rs->fields[1];  //2nd result
$_SESSION['eventdate']=$rs->fields[2];  //3rd result

or similar to the above to assign to regular variables by simply replacing the $_SESSION['varname'] with $varname

hth