RE: Newbie Question - PHP and MSACCESS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



//Place your request into a variable:
$result = odbc_do($connection,"select * from events where id=$id");
$var = odbc_fetch_row($result);

// Now you have an array to work on
	foreach($var as $line){
	//Do your formatting thusly:
	echo '
		<tr><td>' . $line[0] . '<?td>
		    <td>' . $line[1] . '</td>
...
		</tr>
	}
	

Hi,
 
Am using php to open a customer's msaccess file.
 
First time for everything.  It's a very small database of less then 25
rows, and will always be this small.
 
Am needing to return all the rows to a web page using php at all times.
Very simplistic.
 
Am apparently set up correctly on the DSN, and am able to do an
odbc_connect:
 
$connection = odbc_connect("meetings","","");
 
Am able to fetch rows, or so it seems:
 
$result = odbc_do($connection,"select * from events where id=$id");
odbc_fetch_row($result);
 
Am not understanding how to "print()" the fields in the rows, one after
the next, on the same line, and then do the same with the next record,
until all records have been presented.
 
Sorry to be lame.  Any help would be gratefully received.
 
 
-Joe

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux