dschuett -1 Junior Poster

I am still fairly new to PHP, so I will do the best at explaining what I am trying to do here...

I have a database table where I store a bunch of invoices. I am now trying to make a front end to run queries. I don't know how to make it so i can keep adding AND/OR statements to my query as need be. Also, I need a way to eliminate the FIRST AND/OR drop down list because obviously your first query statement will not start with an AND or OR.

Here is my basic html code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Invoice Query</title>

<form method="post" action="" enctype="multipart/form-data">
<table  align="center" border="0" id="qry_table">
        <td><select name="andor"><option value="" selected></option>
                <option value="AND">AND</option>
                <option value="OR">OR</option>
        <td><select name="column"><option value="" selected></option>
                <option value="inv_num">Invoice Number</option>
                <option value="inv_date">Invoice Date</option>
                <option value="vendor">Vendor</option>
                <option value="purpose">Purpose</option>
                <option value="amount">Amount</option>
        <td><select name="what"><option value="" selected></option>
                <option value="=">=</option>
                <option value=">">></option>
                <option value="<"><</option>
                <option value=">=">>=</option>
                <option value="<="><=</option>
                <option value="LIKE">LIKE</option>
                <td><input type="text" name="qry_term" /></td>
                <td colspan="4"><input type="submit" value="Submit Query" name="submit" /></td>

I know it will probably take javascript to add/remove rows if needed, but i am very new to this and still trying to learn. Any help is much appreciated!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.