[RESOLVED] Form values within database results

camvoss

Hi all,

I've been playing around with this one for hours, but keep running into dead-ends, some any help would be greatly appreciated. I'm designing a small 'simple' online ordering system. All the products (67 of them) are stored in a MySQL database (each product contains a unique id and product code, price & description). Each product has numerous sizes (XS, S, M, L, XL, XXL, XXXL), on the 1st page, it lists all the products with input fields for each of the sizes. Each input field has a unique name (eg: id1XS, id1S, id1M..... id2XS, id2S, id2M...). On the results page, I return all the products as I do on the 1st page, but I want to replace the input fields simply with the number/value type in on the previous page. Unfortunately after trying several different methods, I can't figure out how to do this. If I manually type $id1XS, it returns the value fine, however obviously there is more than one product the MySQL query is returning, so the form value needs to be displayed for all sizes for all products.

Thanks in advanced.

Kind Regards,
Cam

Houdini

Showing what code you presently have would be of great value please juse copy and paste the code into the Posting area then seleect it and use the tilde ~ in the bootom row of buttons and it will enclose the code in PHP bb Code. or enter [ PHP ] in front and [ /PHP ] after your code (without the spaces) when posting.

camvoss

Thanks for the reply Houdini. Sorry, should have posted the code originally, it had been a long day!! 😉

I was having problems with the names of the input boxes, so I created new fields in the database (s1, s2, s3, s4, s5, s6, s7) - these represent the sizes for each of the products, and contain unique entries. So the name of every input box on the order form comes from these fields.

So, my code on the order form to retrieve the products is:

$query=mysql_query("SELECT id, code, price, desc, s1, s2, s3, s4, s5, s6, s7 FROM merchandise WHERE cat = 1");
while(list($id, $code, $price, $desc, $s1, $s2, $s3, $s4, $s5, $s6, $s7) = mysql_fetch_row($query))

The page looks like this:
www.cvwebdesign.com/vafa_test/merchandise.php

With the results page (merchandise2.php), I use the same query above to return all the products. However I want to return the values of all the input fields (the names which came from the $s1, $s2... fields). I've tried all sorts of silly things like typing $$s1, hoping it would read it as $i30sXL (the unique name of the field, pulled from the mySQL database) and therefore return the value from the previous page what the user typed in, but it doesn't work.

Sorry if this sounds confusing, I'm finding it a bit hard to describe it. :o

Regards,
Cam

camvoss

No clues anyone? Even if someone could just point me to some example code I could look off?

Rgs,
Cam

Houdini

Kind of not really awake but try this and see what it does for you. Your need to rename the desc column to description, desc is a special word in MySQL ( take data in decending order), notice how I changed the name below, you need to do the same

$query = "SELECT id, code, price, description, s1, s2, s3, s4, s5, s6, s7 FROM merchandise WHERE cat = '1'";
$result = mysql_query($query);
if ($result && mysql_num_rows($result)) {
	$numrows = mysql_num_rows($result);
	$count=1;
	echo "There are $numrows rows of data in merchandise!<br>";
		while($row = mysql_fetch_array($result,MYSQL_ASSOC)){
			echo "Row $count<br />";
				while(list($var, $val) = each($row)) {
                	echo "<b>$var</b>: $val<br />";
            }
		echo "<br />";
		$count++;
		}
	}
 ?>

camvoss

Thanks Houdini, I appreciate your help. However the results returned still had the same problem I was getting - it returned the value of the mySQL field rather than the value of the input field from the previous page.

However after more stuffing around, trying different things etc.. I've solved it...
In the results, rather than just typing $s1, type it as: ${$s1} - this now returns the value which was input by the user from the previous page. I'm a very happy man now. Thanks again.

camvoss

I've got another question. I would like to get a total figure from the results returned. Eg: Users have the ability to order a number of products in each catagory (these input fields are the s1, s2, s3 etc fields which I display on the confirmation page.

I can get a total number of products for each product (each row) by using this query:
$total1 = (${$s1} + ${$s2} + ${$s3} + ${$s4} + ${$s5} + ${$s6} + ${$s7});

However, if there are 5 products, how can I get a total of these?

Regards,
Cam

Houdini

Maybe using the MySQL SUM() function there is a little tutorial about its use right here that you might be able to use. SUM()