|
|
Posted by jerryyang_la1 on 08/23/07 09:36
I'm using the code below as a base for a connect to an access
database.
This works well, but I have an issue...
<?php
$db = "./access.mdb" ;
$pass = "1234" ;
$conn = new COM("ADODB.Connection") ;
$sql = "DRIVER={Microsoft Access Driver (*.mdb)} ;
DBQ=". realpath($db) ." ;
uid=admin ;
pwd=$pass ;" ;
$conn->open($sql);
$rs = $conn->execute("SELECT * FROM TableName");
while (!$rs->EOF) {
echo $rs->Fields['FieldID']->Value ;
echo $rs->Fields['FieldName']->Value ;
$rs->MoveNext() ;
}
$rs->Close() ;
$conn->Close() ;
?>
using this:
while (!$rs->EOF) {
echo $rs->Fields['FieldID']->Value ;
echo $rs->Fields['FieldName']->Value ;
$rs->MoveNext() ;
}
The data is data is extracted and displayed on the screen.
as:
ID: 123456
Field1: value1
Field2: value12
ID: 123456
Field1: value2
Field2: value22
ID: 123456
Field1: value3
Field2: value23
ID: 123456
Field1: value4
Field2: value24
But I need to do this!!
Show this ONCE : echo $rs->Fields['FieldID']->Value ;
Loop on this : echo $rs->Fields['Field1']->Value ;
Loop on this : echo $rs->Fields['Field2']->Value ;
The end result being
ID: 123456
Field1: value1, value2, value3, value4
Field2: value12, value22, value23, value24
HELP :)
Any ideas ??
Thanks
Navigation:
[Reply to this message]
|