form values

Need a little help. I'm trying to print search results from a mysql database. In the results I need the following:
print ("<INPUT TYPE="CHECKBOX" NAME="addit" VALUE="item description^price^1">")

the info in the value area needs to be called from a mysql database. The ^ symbols need to be between each of the mysql results. I've tried a few different methods but none seem to display the results.

Suggestions???

Thanks in advance

------------------
Chris Staniar

Why would u want to put more than 1 results in as the default value for a checkbox anyway?


Basil

I am not sure I understand the poster's question. You are having trouble outputting your parse delimiters (^)? or you are having trouble getting proper html output in general?

When I do something like this I am generally in a loop outputting html table rows for (for instance) a shopping cart. I have the results of my SQL query in separate variables (i.e., $sku, $qty, $description, etc.) and use printf with an appropriate format string.
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>printf ("<tr><td><input type=checkbox name="addit[]" value = "%s^%d^">%s</td></tr>n", $description, $price, $description);[/code]

It's freehand, so it may be a little whacky. If so, I'll correct it as soon as I get home, but it should work out and output something like

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre><tr><td><input type=checkbox name=addit[] value = "testitem^2.23^>testitem</td></tr>[/code]

You may want to reexamine the value field, which looks as though you're trying to combine a key with a price. If this info is in your base already, why not just pass the sku number (or whatever)?

Also, If you're dealing with multiple items, be sure to name the checkbox with name = "addit[]" or whatever so that it knows to send PHP an array of items. good luck.

jim


[This message has been edited by jodonnell (edited February 29, 2000).]

[This message has been edited by jodonnell (edited February 29, 2000).]

Sorry, I should have been more specific. The value of the checkbox needs to be this way in order to pass data to a shopping cart. The ^ symbols break up the data so the shopping cart can utilize the data. The ^ symbols are not going to be printed from the database, only the product description and price.

Where you see description^price these need to be separate values called from a mysql db. Below is a more detailed section of the code.

Thanks


mysql_select_db (chrisdb);

if ($prodname == "")
{$prodname = '%';}

$result = mysql_query ("SELECT * FROM products
WHERE prodname LIKE '$prodname%'
");

if ($row = mysql_fetch_array($result)) {

do {
print ("<TR><TD>");
print ("<INPUT TYPE="CHECKBOX" NAME="addit" VALUE="description^price^1"></TD>");
print ("<TD>");
print $row["prodname"];
print ("</TD><TD>");
print $row["description"];
print ("</TD><TD>");
print $row["price"];
print ("</TD><TD><INPUT TYPE="submit" VALUE="Order"></TD></TR></TABLE>");
} while($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}

the following code should do it, its only a couple of changes to your original...

<?
mysql_connect("whatever");
$result = mysql_db_query ("databasename","SELECT * FROM products WHERE prodname LIKE '$prodname%'");
if ($row = mysql_fetch_array($result))
{
do
{
print ("<TR><TD>");
print ("<INPUT TYPE="CHECKBOX" NAME="addit" VALUE="".$row["0"]."^".$row["1"]."^".$row["2"].""></TD>");
print ("<TD>");
print $row["0"];
print ("</TD><TD>");
print $row["1"];
print ("</TD><TD>");
print $row["2"];
print ("</TD><TD><INPUT TYPE="submit" VALUE="Order"></TD></TR></TABLE>");
}
while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}
?>

hth

timbo

sorry should have said just replace the "0" "1" etc with whatever your column names are
------------------
cheers


[This message has been edited by timbo (edited March 01, 2000).]

Thanks, that worked great!

------------------
Chris Staniar