i have connected it with php using the tutorial in w3school
Expand|Select|Wrap|Line Numbers
- <html>
- <body>
- <?php
- $conn=odbc_connect('db','','');
- if (!$conn)
- {exit("Connection Failed: " . $conn);}
- $sql="SELECT * FROM client";
- $rs=odbc_exec($conn,$sql);
- if (!$rs)
- {exit("Error in SQL");}
- echo "<table><tr>";
- echo "<th>firstname</th>";
- echo "<th>lastname</th></tr>";
- while (odbc_fetch_row($rs))
- {
- $fname=odbc_result($rs,"firstname");
- $lname=odbc_result($rs,"lastname");
- echo "<tr><td>$fname</td>";
- echo "<td>$lname</td></tr>";
- }
- odbc_close($conn);
- echo "</table>";
- ?>
- </body>
- </html>
firstname lastname
JOHN KAY
ALIN STEWART
MIKE RITCHIE
MARY TREGEAR
PATRICK HARRISON
RONALDO GERRAD
my problem is i dont know how to bring the table name client and when i click the table name client i can get the information of that table
do i have to write alot of code?
can anyone please give me code to bring out one table name and when i click the table name
i can get the content of the table
and to bring out one query as well
i will be grateful