I've just started using DBman, and realised it's a great tool for a web database. My problem is how to display the data the way i want.
I have the database set up with 1 admin account, which is the only one who can add,edit,modify etc. All other access to the database is guest only (only viewing).
But i don't want the default DBman default look, I want to choose (with html/perl code) exactly which records (and which fields in that record) to display on the guest pages. (But i would like to keep the DBman look for the admin tasks.)
IE if one of the guest pages look like this:
<html>
<head><title>My mates</title></head>
<body>
Some text...etc. etc. etc.
<table>
<tr>
<td> ID: 439 (from dbman cgi) </td>
<td> Name: Jax, John (from dbman cgi) </td>
<td> Age: 19 (from dbman cgi) </td>
</tr>
<!-- And although record 439 also contains the fields "Interests" and "Eyecolor" I don't want to show them -->
<tr>
<td> ID: 39 (from dbman cgi) </td>
<td> Name: Clay, Joe (from dbman cgi) </td>
<td> Interests: Cars (from dbman cgi) </td>
<td> Eyecolor: Blue (from dbman cgi) </td>
</tr>
<!-- And in this row I don't want to show how old (the "Age" field) Joe Clay is, even if I have it in the database -->
</table>
</body>
</html>
In other words, how do i select individual fields and records from the database. I have quite a good grasp on html, but very little knowledge of CGI and Perl, so if anybody could tell my in a easy way how to this i would be a happy man
I have the database set up with 1 admin account, which is the only one who can add,edit,modify etc. All other access to the database is guest only (only viewing).
But i don't want the default DBman default look, I want to choose (with html/perl code) exactly which records (and which fields in that record) to display on the guest pages. (But i would like to keep the DBman look for the admin tasks.)
IE if one of the guest pages look like this:
<html>
<head><title>My mates</title></head>
<body>
Some text...etc. etc. etc.
<table>
<tr>
<td> ID: 439 (from dbman cgi) </td>
<td> Name: Jax, John (from dbman cgi) </td>
<td> Age: 19 (from dbman cgi) </td>
</tr>
<!-- And although record 439 also contains the fields "Interests" and "Eyecolor" I don't want to show them -->
<tr>
<td> ID: 39 (from dbman cgi) </td>
<td> Name: Clay, Joe (from dbman cgi) </td>
<td> Interests: Cars (from dbman cgi) </td>
<td> Eyecolor: Blue (from dbman cgi) </td>
</tr>
<!-- And in this row I don't want to show how old (the "Age" field) Joe Clay is, even if I have it in the database -->
</table>
</body>
</html>
In other words, how do i select individual fields and records from the database. I have quite a good grasp on html, but very little knowledge of CGI and Perl, so if anybody could tell my in a easy way how to this i would be a happy man
