Generating a query by concatenating two

[fimbulvetr]

I need to build a query by concatenating two varibles, here is a snip of my code:

---

$howmany = How many times to loop, ie 5 times.

<?php
$i=0;
while ($i <= $howmany)
{
// create connection
$connection = mysql_connect("my_server","php_user","php_password")
or die("Couldn't make the friggin connection.");

// select database
$db = mysql_select_db("my_database", $connection)
or die("Couldn't select database.");

// create SQL statement
$sql = "update the_table set done ='P' where primary_number = $result.{$i}";

// execute SQL query and get result
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute the damned query.");
$i++;
}
?>

---

Essentially results are parsed over, Im not sure what the numbers will be, one time it maybe result0 with a value of '0012'.
Another time it may be result3 with a value of '9911', as well as result9 with a value of '10999'.
My point is I want to parse through result0-result 9999(not a set number) and where the data contained in result0 - result9999(again, not s set number) is equal to a valid primary_number (see code), I want the 'done' field set to 'P' for that record.
Currently that code above sets all the records to 'P'.
Im almost sure its a simple syntax error, but I have been unable to find it.

Thank you for your help.

Fim

[vsego]

I'm not sure what you're triing to do, but to get $resultxxxx variable (and do the query only for those that were set) use this:

$result = ${"result$i"}
if (isset($result)) {
// do whatever you want
}

[fimbulvetr]

Hmm I cant wait to try that. But not till the morning, cause if I start again, I will have to start another pot of coffee, and Im almost out.

I think you caught the jist of what I was trying to do.

'result0' and 'result3' are passed over from the previous page from a submit. The contain data along the lines of '1011' or '9999' etc. There may be up to 1000 'resultx' varibles submitted with data stored in them.
Bascially as I first mentioned, I want to query the data base using trying to match 'result10' 's data with a 'primary_number', and where the data in result0 is equal to a 'primary_number' in the database, I want to set the 'done' value of that record to 'P'

Thanks for the prompt and potentially helpful response, Vedran.

Fim

Hopefully this should be a concise enough answer.
Just remember result0 result1 result2 result3 result4 ....all the way to result9999 could all be viable options with viable data in them, Im just not sure which ones, thats why I run queries against the database one at a time.

[fimbulvetr]

Thanks Vedran

That Solved my problem!!!

[vsego]

I'm glad for you. There remains one question though: why not using arrays?

<input type="text" name="result[]">
<input type="text" name="result[]">
<input type="text" name="result[]">
<input type="text" name="result[]">

When this is submitted, $result will be an array with 4 items, containing values from input boxes. Might be usefull if you have no other requests.

Good luck!