Helpful Information
 
 
Category: ColdFusion
HELP (how can i insert multiple row into mysql with on insert statement)

i need help on how to enter multiple row into mysql with one insert
statement e.g

<---- THIS AN EXAMPLE OF MY INSERT FORM ---->

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form id="form1" name="form1" method="post" action="">

<input type="checkbox" name="product" id="value" value="EMD44D" />

<input type="checkbox" name="product" id="value" value="EMD456" />

<input type="checkbox" name="product" id="value" value="EMD4545" />

<input type="checkbox" name="product" id="value" value="EMD344" />

<input type="checkbox" name="product" id="value" value="EMD4355" />

<input type="checkbox" name="product" id="value" value="EMD3445" />

<input name="submit" type="button" />

</form>
</body>
</html>

<--MY DATABASE LOOKS LIKE --->

ID | VALUE |
| |
| |
| |

I have been looking for a way to enter only the value that is selected by

the user.










privacy (GDPR)