Hello all

When I try to use the code listed below I get an 'Expected Expression' error on the DBGetRecordSet line.

Any help is appreciated.

Thanks in advance

Kevin

$dsn = "DRIVER=MySQL;SERVER=School;UID=root;PWD=;DATABASE=Internet"

$connection=DBConnOpen($dsn)

$YOI = SubStr( @UserID ,2 , 2)

$UserID = SubStr( @UserID , 4 , 4)

$recordset = DBGetRecordset($connection,"SELECT Internet FROM Access WHERE YOI='$YOI' AND USERID='$USERID'")

$retcode = DBConnClose($dsn)
_________________________
Kevin Cowans Senior ICT Technician The Armthorpe School