adamdyer Posted August 22, 2007 Share Posted August 22, 2007 Ok, so next part of my problem is such - I have to be able to retreive the data from my Database so that the customers are sorted into two seperate fields of £40 and £60. PHP Coding <html> <head> <title>View Customers by category</title> </head> <body> <?php #get the Customer Price Category i.e. Acat variable $Cat = $_GET['Acat']; #-------------------------------------------------------- echo("<font face=Courier size=3>"); echo("<p>Customer Price Category Results for :$CAT <hr></P>"); $VariableName = $_GET['VariablePassed']; #-------------------------------------------------------- # connect to MySQL $conn = @mysql_connect("localhost","ajdref","ref2") or die ("sorry - could not wont connect to MySQL"); # select the specified database $rs = @mysql_select_db("ajdref", $conn) or die ("sorry - could not connect to the ajdref"); #create the query - sets $sql to contain the required query $sql = 'SELECT * FROM `Booking Database` ORDER BY `Booking Database` . `Price Cat` ASC LIMIT 0, 30 '; #execute the query - uses the mysql_query() function to issue the $sql query to the $conn connection #$rs contains the result set in the form of an array $rs = mysql_query($sql,$conn); ?> </body> </html> HTML Coding <HTML> <HEAD> <TITLE> Search by category </TITLE> </HEAD> <BODY BGCOLOR=lemonchiffon > <form NAME="GetCode" ACTION="customerpricecategory2.php" METHOD=get> <div align="center"><b><font size="4"> Search by Price Category</font></b></div> <p></p> <div align="center"> <p>Please choose price category from this list. <select name="Acat"> <option value="A" selected>A - £40 </option> <option value="B">B - £60 </option> </select> </p> </div> <p></p> <div align="center">Now click 'Send'. <input type="submit" value="Send" name="SUBMIT" > </div> </form> </BODY> </HTML> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.