Array Problem

zooropa

Hello, I wondered if anyone could show me code to achieve the following:

I have:

1 textbox
1 submit button

When the user enters a number e.g. 7 into the text box the following should happen:

The text 01, 02, 03, ..., 07 is entered into a field "sometext" in the mysql database (so there are 7 records)

I figure that i maybe need to do some string to int conversion and loop round an array but after an afternoon of frustration, it's beyond me.

Thanks

johanafm

zooropa;10963409 wrote:
The text 01, 02, 03, ..., 07 is entered into a field "sometext" in the mysql database

would mean one record

zooropa;10963409 wrote:
(so there are 7 records)

would mean that 7 different records are inserted, where the first one has '01' in "sometext", the second one has '02' in "sometext" etc.

Assuming you do want 7 records

if (isset($_POST['some_element'])) {
	$val = (int) $_POST['records'];

if ($val > 0) {
	$qry = 'INSERT INTO sometable(sometext) VALUES ';
	for ($i = 1; $i < $val; ++$i) {
		$qry .= '('.($i < 10) ? "0$i" : $i) . '),';
	}
	$qry .= '('.($i < 10) ? "0$i" : $i) . ')';
}
}