[PHP-DB] Querying & Displaying a pricing table

2007-12-24 Thread Ron Piggott
I was thinking more after I sent the post. I would like to retrieve the results into an array, if it is possible. Does this make sense? What I am wanting to display are the dollar values for the rate plans. Thanks for the help. Ron -- PHP Database Mailing List (http://www.php.net/) To unsubs

[PHP-DB] Sum function for multiple recordsets?

2007-12-24 Thread jay
I'm getting a health insurance quote engine going... http://www.insuranceshoppers.net/getquotes/short-term-health.php ... it sends me an email with the info, and enters the info into a "leads" table in mysql. Then I want to have it show the rates (on a new page using $_GET) from a table I

[PHP-DB] Querying & Displaying a pricing table

2007-12-24 Thread Ron Piggott
I am trying to query my rate_plan table and then display the results in a table format. I need help developing then SELECT syntax and how I am able to echo the results in a . I want to display the results 7 columns, 4 rows. There are 7 tenures: I have rate plans set up for: 1 week (term =1; uni