Array problem

[rockinaway]

$form_array = array('title', 'entry', 'comment', 'rating');

foreach ($form_array as $cs)
{
        $query = mysql_query('SELECT value FROM prefix_config WHERE name = "'.$cs.'"');
        $test = mysql_fetch_array($query);
        $cs = $test['value'];
}

 

What I am wanting to do is get the value for each thing in the array with a select, and then I want to update the array value with the new value from the query. This isn't working.. what should I do?

[per1os]

Try this:

 

$form_array = array('title', 'entry', 'comment', 'rating');

foreach ($form_array as $cs)
{
        $query = mysql_query("SELECT value FROM prefix_config WHERE name = '".$cs."'");
        $test = mysql_fetch_array($query);
        $cs = $test['value'];
}

 

MySQL only supports Single-quotes in it's queries.  And to debug I would do this:

 

$form_array = array('title', 'entry', 'comment', 'rating');

foreach ($form_array as $cs)
{
        $query = mysql_query("SELECT value FROM prefix_config WHERE name = '".$cs."'") or DIE(mysql_error());
        $test = mysql_fetch_array($query);
        $cs = $test['value'];
}

 

--FrosT

[rockinaway]

But then that means the variable is not read as a variable..

[per1os]

What do you mean, that statement just confused me?

 

<?php
$x = "test test '" . $b . "' test test";

//is the same as
$x = 'test test "' . $b . '" test test';
?>

 

--FrosT

[rockinaway]

Doesn't work that way around and I have been doing the same all through my other files and works fine.. I just see the problem in the updating of the array value

[per1os]

Maybe your version of php and mysql would help diagnose the problem. Because as far as my knowledge goes, and every line of code that I have written what I posted above holds true.

 

--FrosT

[rockinaway]

It is doing the query fine.. just the array values aren't changing..

[per1os]

Ohhh my bad, mis-read the question.

 

Try this:

 

<?php
$form_array = array('title', 'entry', 'comment', 'rating');

foreach ($form_array as $key => $cs)
{
        $query = mysql_query('SELECT value FROM prefix_config WHERE name = "'.$cs.'"');
        $test = mysql_fetch_array($query);
        $form_array[$key] = $test['value'];
}
?>

 

--FrosT

[rockinaway]

Thanks.. I had a think last night and I got something like that. I will try it later on .