Dynamic Mysql Query

Anon

I know this should be simple but I can not figure out how to get
a list of fields. Here is what I am trying to do:

$sql = "UPDATE vipcustomer SET first_name='$first_name',last_name='$last_name',income_level='$income_level',children='$children',pager='$pager',cellno='$cellno',Occupation='$Occupation',employer='$employer',SSNO='$SSNO',fax='$fax',fax_ac='$fax_ac',HomePhone='$HomePhone',email='$email',mstatus='$mstatus' WHERE custid=$uid";

I would like to generate this automatically. If I could get an array like first_name,last_name,income_level and so on - it would be easy to do. I just don't even know what to look for in the manual. could somebody point me in the right direction?

Anon

I'm not exactly sure what you mean by "automatically" in this context. Could you clarify?

Anon

Sorry, poor choice of words.

I want to do something like:

printf(" %s='$%s',%s='$%s'\n, $myrow[1], $myrow[2]);

But I don't know how to make $myrow = field names instead of values. I think it is a mysql command but I don't know . . .

I just want to stop having to type in all of this stuff:

because it changes so freqently.

Anon

OK, assuming you have an associative array where the keys are the column names, AND that all the columns are numeric (probably a killer, this latter assumption!) you can just say:

$qry = 'update table set ';

foreach( $data as $column => $value )
  {
  $qry .= "$column = '$value',";
  }

$qry = ereg_replace( ',$', '', $qry ); // too lazy to think of a better way, sorry!

$qry .= " where primary_key_col = $id;";

egervari

My company has constructed a complete OO solution to formalize and automate the database access layer and it's incredibly simple and easy to extend. A lot of the plumbing is taken away from the programmer. If your interested in knowing more about it, email me at ken@positive-edge.com.

Anon

I had to chew on that one for a little while and make a few adjustments but it works good for me now thank you.