php and ADOdb

[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.

PHP:

$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😕