DaniWeb Forum Index > Web Development > PHP

fetching unkown column names

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2008

Posts: 35

Reputation: cali_dotcom is an unknown quantity at this point

Solved Threads: 0

cali_dotcom cali_dotcom is offline

Offline

Light Poster

fetching unkown column names

Nov 18th, 2008

i'm building a website where users can add articles. on the admin side, they can also add new fields on the add articles page.
to allow the user edit the articles, i have to query the database and then assign the results from the query to variables, usually i use the $fieldname.
the problem is, if a user added a new field while he added the article, i can't fetch the content by field anme from the rusult set of the query.
eg:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$select = $article->select();
		$select->where('id =?', $id);
		while ($rows = $article->fetchAll($select)){
			$this->cat_id = $rows->cat_id;
			$this->article_title = $rows->title;
			$this->description = $rows->description;
			:
                        :
		}
$select = $article->select();
		$select->where('id =?', $id);
		while ($rows = $article->fetchAll($select)){
			$this->cat_id = $rows->cat_id;
			$this->article_title = $rows->title;
			$this->description = $rows->description;
			:
                        :
		}

but if i dont know the name of the new field(s) the user added, i can't assign it to a variable.
PS: i was thinking of a solution that would need me to fetch the name of the fields form the article_fields table, but then again i got stuck trying to assign the field name to a variable that had the same name i.e:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$select = $article_fields->select();
			while ($rows = $article_fields->fetchAll($select)){
			${$rows->field_name}= $rows->field_name;
			;
$select = $article_fields->select();
			while ($rows = $article_fields->fetchAll($select)){
			${$rows->field_name}= $rows->field_name;
			;

Does anyone have any solutions??

Last edited by cali_dotcom; Nov 18th, 2008 at 9:03 pm.

•

Join Date: Oct 2006

Posts: 232

Reputation: Rhyan is an unknown quantity at this point

Solved Threads: 24

Rhyan

Offline

Posting Whiz in Training

Re: fetching unkown column names

Nov 18th, 2008

Your select can always be ' select * from whatever'.
Then you just retrieve an associative array using mysql_fetch_assoc, and then run a foreach loop like this

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
foreach( $result as $key => $value)
  {
  echo 'Field name:'.$key."\n Field value".$value;
  }
foreach( $result as $key => $value)
  {
  echo 'Field name:'.$key."\n Field value".$value;
  }