So, in my latest project I have decided to save all of the visible text a "strings" in a table in my database. The database structure is as follows:

+----+------+-----------------------------+------------+
| id | name | default_value               | cust_value |
+----+------+-----------------------------+------------+
|  1 | str1 | This is a demo string       |            |
|  2 | str2 | This is another demo string |            |
+----+------+-----------------------------+------------+

So I got the contents of the table called 'strings' like this:

PHP Code:

$strings = mysql_query("SELECT * FROM `strings`;"); 


but after that I am unsure as to how I would go about placeing these strings in my code.

Can anyone help?
thanks

Read the manual section about mysql.
You will find everything that you need.
http://www.php.net/manual/en/book.mysql.php

Even on the mysql_query() documentation page, you have an example on how to perform the query and get the column values. Look at the example 2.
http://www.php.net/manual/en/function.mysql-query.php

thank you for the speedy response, however from what i read that does not fully help me. I already know how to print a whole array of all the values, but I need away to print just one on the values from whole selected dataset

thanks

well, then just print it:

PHP Code:

$sql="select * from x";
$r=mysql_query($sql);
while($res=mysql_fetch_array($r)){
  print $res['column_name'];
} 


Might I suggest that you really read the tutorial.
Accessing 1 array value is something so basic, that you will have many more problems later on if you don't understand how functions, variables and iterations are working.

You should iterate though your mysql result set and create indexed array like this:
$indexed[$record->name] = $record
After that in your templates you may refer to it like this:
<?= $indexed['str1']->default_value ?>

thanks

Originally Posted by mtishetsky

You should iterate though your mysql result set and create indexed array like this:
$indexed[$record->name] = $record
After that in your templates you may refer to it like this:
<?= $indexed['str1']->default_value ?>

I seem to still need a little help, could you please explain your code abit, i just dont understand quite how to use it.

thanks

PHP Code:

$sql="select * from x";
$r=mysql_query($sql);
while($res=mysql_fetch_array($r)){
  $indexed[$res->name] = $res;
}
...
echo "Here is str1 value: {$indexed['str1']->default_value}";