Referencing field names

[meigwil]

Hi,

I have fields named thus:

field_1, field_2, field_3 etc.

Is it possible to reference them in a loop like this?

$i=1;
while($row=mysql_fetch_array($result)){
   $sql = "UPDATE tablename SET field_".$i." = '".$value."' ";
}

or perhaps like this?

$sql = "UPDATE tablename SET field_$i = '".$value."' ";

Also, if a sql query returns no records, is it correct to use this

sql = "SELECT * FROM table WHERE records = 1";
$result = mysql_query($sql);
if($result>0){
   //etc etc
}

Thanks,

Mei

[laserlight]

I have fields named thus:

field_1, field_2, field_3 etc.

Why in the world do you have your fields named like that? Time to refactor into a new table.

[pppppp]

$i=1;
while($row=mysql_fetch_array($result)){
$sql = "UPDATE tablename SET field_".$i." = '".$value."' ";
$i++;
}

this is correct

sql = "SELECT * FROM table WHERE records = 1";
$result = mysql_query($sql);
if(mysql_num_rows($result)>0){
//etc etc
}
use this

[meigwil]

Sorry, it's just an example. I have three fields for each position in a competition, as part of a wider database, they're actually called rhag_1, rhag_2, rhag_3.

Pppppp: so are your examples OK to use?

Thanks,

Mei

[thorpe]

pppppp is way off track.

You can get field names using [man]mysql_list_fields/man.

However, as laserlight has suggested, maybe you need to rethink your design. Do a google on database normalization.

[pppppp]

i m not off my track 'thorpe' ... as 'meigwil' wrote that he/she has field_1,field_2,field_3 so i told him that