i'm a desperate man!!!

[itworks]

people if there was a time when i needed help, now is it.

i have to develop a section in a clients site where the user can choose from a drop menu the platform he want's for building his own computer online.

then according to that choice i must put a drop menu with the options for each component, only three have to be chosen according to the platform (memory, motherboard and processor) the other are just all the products of that category, this options have to be pulled out from the products table in the database.

then when submited the user's choices must be presented and most important the total value of the computer (sum of all the components).

i have started this scripts a thousand times and i get nowhere i just don't see the right way to do this and then i get stucked where i don't have any options to finish it.

PLEASE I REALLY NEED YOUR HELP!

ask for any information you need to know to help me.

thanks in advance.

[Mordecai]

I'm not sure I understand you, but I'll provide an example and an answer based on what I think. Correct me if I misinterpreted you.

The database holds a two tables. One is labeled pieces_a and the other labeled pieces_b. The user is prompted with a dropdown menu, with two options: OS A, and OS B. Their values are "a" and "b," respectively.
Based on this sent information, a query is made on the database:
SELECT * FROM pieces_$dropdown_menu

This then translates into two possible situations, pieces_a is being queried, or pieces_b.

If the tables are named similarly to pieces_windows and pieces_linux, etc., they can be accessed similarly.

Hope this helps.

[ahundiak]

I am just guessing here as well. Can we assume that some of the products are available for multiple platforms? If so then

TABLE - product
productID description

TABLE - platform
platformID description

TABLE product_platform
productID platformID

For each platform that a product supports, add an entry into the product_platform table. Once the user picks the platform, you can use this table to determine which products are available.

[itworks]

thanks a lot people for your help.

i think i'm in the right track now, but there are still some little things i need to improve.

i have a function to pull the each component options of the database, then when submited i have a loop to show the results and the sum of all their prices, but i need to change this loop to show the components selected in the order they are asked, now they are showing in the order they are found in the table and i need the processor first, then the memory, etc...

but now i have encountered a new problem, and a big one. if you choose the platform with RIMM memory these can only be used in pairs, how can show 2 RIMMS and do the sum of the prices with these two RIMMS in this loop?

function verComponente($processador, $memoria, $motherboard, $disco, $cdrom, $dvd, $disquetes, $placasom, $placagrafica, $monitor, $colunas, $teclado, $rato, $sistema) {
			$sql = "SELECT * FROM produtos WHERE cod='$processador' OR cod='$memoria' OR cod='$motherboard' OR cod='$disco' OR cod='$cdrom' OR cod='$dvd' OR cod='$disquetes' OR cod='$placasom' OR cod='$placagrafica' OR cod='$monitor' OR cod='$colunas' OR cod='$teclado' OR cod='$rato' OR cod='$sistema'";
			$rs=$this->bd->executarSQL($sql);

		$n = 0;
		$total = 0;
		while(mysql_fetch_row($rs)) {
			echo "<b>".mysql_result($rs, $n, "categoria")." : </b>".mysql_result($rs, $n, "marca")." ".mysql_result($rs, $n, "modelo")." - <b>".mysql_result($rs, $n, "preco")." €</b><br>";
			$total += mysql_result($rs, $n, "preco");
			$n++;
			}
		echo "<div align=\"right\"><font size=+1><b>Total: $total €</b></font></div>";
	}

any though could be of great help at this time.

Thanks in advance.