Jump to content

Archived

This topic is now archived and is closed to further replies.

alarik149

field name into a variable

Recommended Posts

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:)

Share this post


Link to post
Share on other sites
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".

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.