access data in webpage

[priyankkgupta]

Hi
I am new to this ....

I have a data base in access having 6 columns and around 120 entries.

I want some script or some coding through which I can extract the data into a webpage.

for example say if I create a link with TTT and on clicking this TTT the next page should display the results from database in a webpage in table format ......

Is it possible with php and if yes how

[planetsim]

Yes its possible. What database are you using? Something like this would do it although id suggest you will need to do some research into php and databases.

$q = mysql_query("SELECT * FROM mytable");
echo "<table>";
while ( $r = mysql_fetch_assoc($q) )
{
    echo "<tr><td>" . $r["myfield"] . "</td></tr>";
}
echo "</table>";

Thats a quick and dirty example.

[priyankkgupta]

Hi
Thanks for your reply. I have database is in Microsoft Access ...
If this could be done with access database ... It will be of great help