Updating MYSQL

Anon

I have 10 field names in MYSQL called RN1 through to RN10.

What I need to do in my PHP code is automatically update these 10 fields in a loop.

As an example I need to put the letter "A" into RN1 through to the letter "J"

What I would like to do is set a loop from 1 to 10 that then puts the letter into the field

$RN[$count] - where count is my loop, doesn't seem to work.

Any ideas ? I suspect I am not understanding variables ?

One way would be to have loads of "if" statements but it won't look too good.

Regards

Rowan Trimmer

yurko

Im not sure... what u need exactly?
Update fields in the table in MySQL?
Or just acccess PHP's variables from $RN1..$RN10

Both can be easy solved.

Read about "variable variable" in man or about $$ variables.

for($count=1;$count<11; $count++){
$TheRN = "RN".$count;
$$TheRN = $count; //for example
}
echo("$RN1 $RN2 ... $RN10");
You will see 1 2 ... 10

and to generate SQL to update the DB table is even more easy:

$sql = "UPDATE your_tyable_name ";
$maxcount =10;
for($count=1;$count<=$maxcount; $count++){
$TheRN = "RN".$count;
$$TheRN = $count; //for example
$sql .= "SET $TheRN ='".$$TheRN."'";
if($count < $maxcount) $sql .=", ";

}
//if you need to update just one specific row
//add a where clause
$sql .= "WHERE id=108"; //just example

But for creating dynamic SQLs in this way I would advice to be very carefull. For commas quotes etc. Better try to use static, clearly visible string. Belive me -- much eassier to debug.

good luck.

http://horobey.jlxlinux.com/

Anon

dfgsggdf

Anon

Hello,

Thanks for that. Let me explain what I am trying to do. I am reading in a text file, scanning it, extracting information and then inserting records into a MYSQL database.

On the beginning of each line of the text file is an identifier.

One of the identifiers is RN (it stands for room description)

As I scan the file the occurance of RN will or could appear more than once.

There would appear not be more than 10 occurences of this.

I have setup 10 fields in my database called rn1 through to rn10.

each time I come across the next occurence of RN in the text file I want to put the contents into the next rn(*) field in the database.

The variable I am using is $rn to scan the file, so for the first occurence of the RN identifier i wan't to put it into a variable called $rn1 and so on.

I just can't get the $rn(number) bit to work.

Regards

Rowan