field name into a variable

[alarik149]

hi all you guru PHP&MySQL people.
I want you to help me with something.
So I have a database named championships and in it I have 5 fields with names '1''2''3''4''5'.
I want the variable $a to hold the name of the field '1',how do I do that?pls tell me.
thank you in advance:)

[alarik149]

or tell me how do i detect the name of a field that contains a certain text.
for example how do I get the name of the field that holds litter "abcdef".

[kenrbnsn]

Try this:
[code]<?php
$q = "select * from tablename";
$rs = mysql_query($q) or die('problem with query: ' . $q . '<br />' . mysql_error());
while ($rw = mysql_fetch_assoc($rs))
     foreach ($rw as $key => $value)
          if ($value == 'abcdef') echo 'The field ' . $key . " holds the value<br />\n";
?>[/code]

Ken

[alarik149]

it works...yey..thanks a lot man:)