Database Extraction

[fnbcprog]

I am trying to write some code that produces a table with filled values from a database. I understand how to fill the table with all the information. The only problem is I want to only print the name of the company once with the correspnding other rows.

The database is setup with 5 columns:
company, product, base_rate, fy_bonus, sur_charges

I want to print a table that prints the company name once and then prints the corresponding products and rates for the products.

:mad:

Thanks

[Eddymvp]

mysql_query ("select * from tablename where company='Put the company name'");

[knelson]

in addition to SELECTing by company, you're just going to have to ECHO the $company_name outside of the loop so that it doesn't display each time.

good luck

knelson