#75506 - 2003-06-20 11:49 AM
Urgent help required with DBGetRecordSet
|
kncowans
Getting the hang of it
Registered: 2000-11-11
Posts: 98
Loc: Doncaster, UK
|
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
|
Top
|
|
|
|
#75508 - 2003-06-21 04:51 PM
Re: Urgent help required with DBGetRecordSet
|
kncowans
Getting the hang of it
Registered: 2000-11-11
Posts: 98
Loc: Doncaster, UK
|
Hello Sealeopard
Thanks for the reply.
I think your solution to do with the variables may fix the problem as when I replace the variables with fixed data the code works correctly.
Bye for now
Kevin
_________________________
Kevin Cowans
Senior ICT Technician
The Armthorpe School
|
Top
|
|
|
|
Moderator: Glenn Barnas, NTDOC, Arend_, Jochen, Radimus, Allen, ShaneEP, Ruud van Velsen, Mart
|
0 registered
and 248 anonymous users online.
|
|
|