PLEASE HELP: reffering to mySQL field as variable (uh, I mean, well: please read...)

nevermind, already got the answer... (can't delete post...)

Hi All,

I want to update a field like this:

$query="UPDATE cursisten SET
d?='2003-12-09'
WHERE id='3'";
$result=mysql_query($query,$link_id);

This is very standard but I want to refer (see the questionmark) to one of many fields in the table named d1, d2, d3, etc. to d40 (datefields)

The questionmark stands for a number and has to be based on a variable.

So: I have a variable (e.g. $x=17). With that variable I want the date '2003-12-09' be put in the field d17

I'm thinking of eval but I dont' know how to do this (maybe it's much simpler?)

Sorry for bad English (I'm dutch)

THANKS a LOT in advance

Marcel

Just out of curiosity how did you do it?

Hi Mahers and all other interested people,

It was this simple:

$x=23; // if I want to refer to field d23 in the table
$field="d".$x; // this is the "trick"

$query="UPDATE cursisten SET
$field='2003-12-09'
WHERE id='3'";
$result=mysql_query($query,$link_id);

That's all!

Marcel