I posted this question a few days ago, but I'm just not understanding what it is that I need to do, so I'll explain in more detail what I'm trying to accomplish, also, you can see what I have for code if that helps any HERE.

What I'm doing is writing a script that will allow me the administrator to log in through a web based login(I don't like the look of .htaccess dialogue) and be able to create an account for my clients to login to see their current invoice also with the ability to change their password(because I will set up the original password for their first time login) and also the ability to log out of their account and expire the session. The way that I want the invoice to be shown is by the script "cit.cgi" by extracting the information that I have entered through web form in the admin section from a database where the delimiter is "|".

Here is where my problem is... In the admin section, I want to be able to delete a client. This will bee done by retrieving the database info and displaying each user in a drop down menu(I know how to do this). When I select the user I want it to delete only that entry just by the username(because there won't be any duplicates).

I know that everyone is saying to use MYSQL, and I would but on my server I have access to 1 MYSQL database, and 1 PostgreSQL database,and I've already used the MYSQL database, but I do have 1 PostgreSQL database that I can still use... Although, I'm not really advanced enough in perl to understand how these databases work or even how to use them.

I'm sure that using this kind of database would solve my other problem which is to allow the user to log off through a link in their account.

My concern with this is that my script, as far as I can see will need to use at least 2 flat file databases plus a flat file database that would be created for each user to store their invoice information. I'm not sure that I would be able to fit all of this into the 1 PostgreSQL database that I have left.

If it is possible, could someone explain to me how to do this, and if not how would I go about doing this through my current flat file databases?

Please be as descriptive as possible as this is the first programming language that I'm trying to learn(except for markup language which isn't even really programming)

Thanx a bunch,
You guys have been so helpful so far with my lack of information and experience...

Tylor

In reply to delete user from database by titanic_fanataic

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.