db query question

AndreF

I have a table like this:

+----+---------------------+-----------------+
| id | variable_name | value_name |
+----+---------------------+-----------------+
| 1 | blah | testing |
| 2 | something | blah1 |
+----+---------------------+-----------------+

now I want to assign each value_name to each variable_name repectively.
e.g. blah = testing and something = blah1.

1) how should be the query to assign each value_name to the respective variable_name?

2) I have a update form like this:
<input type=hidden name="blah" value="testing">
<input type=hidden name="something" value="blah1">

so how should be the query to update each value_name for the respective variable_name? (plz note that variable_name is not editable nor should be updated, only respective value_name should be updated.)

bradgrafelman

You need to execute two separate queries, each looking something like:

UPDATE myTable SET value_name = 'testing' WHERE variable_name = 'blah';

EDIT: Didn't see you clarified that you were updating previous entries.

AndreF

yes, updating, so my second question is already answered.

But how about my first question? I meant to fetch the info from db and assign each value to each variale. so how would you fetch them in order to get:
blah = testing and something = blah1?

bradgrafelman

SELECT variable_name, value_name FROM myTable

Then just loop through the result set and build the HTML dynamically.

AndreF

No, This is not the way, I believe there is a better way byusing mysql_fetch_assoc or something like this, but how to do so?

bradgrafelman

Right... [man]mysql_fetch_assoc/man is what you use to loop through the result set...