display array information from sql query

Question

For some reason I drawing a complete blank on how to display information im looking for from this array. This is the result of this query...

$res = mysql_query("SELECT `key`, `value` FROM `data` where `id` = '4534'", $db_connection);
while ($row = mysql_fetch_assoc($res))
{
    print_r($row);
}

result comes out like this

Array ( [key] => am3:id [value] => 5198 ) 
Array ( [key] => dob [value] => 1984-11-15 ) 
Array ( [key] => examdate [value] => 1 ) 
Array ( [key] => howdidyoufind [value] => Facebook )

if I need to place for instance the value of "howdidyoufind" into a variable how would I do that? so the value of the variable would be "Facebook".

Any help would be appreciated, thanks

Are you always only wanting the value of the howdidyoufind key? — Patrick Q
– Patrick Q, Commented Nov 6, 2017 at 20:30
You should really look into database normalization as you are going to run into issues down the line if you move forward in this way. Here is another SO question and answer that should help you with that. stackoverflow.com/questions/1258743/normalization-in-mysql — cmorrissey
– cmorrissey, Commented Nov 6, 2017 at 20:36
Noted. No i need to pull multiple Key values, there are about 20 in the full result. The database is setup by a 3rd party application we use for member management, it has to be set up the way it is for it to work. :/ — robby
– robby, Commented Nov 6, 2017 at 20:42

Barmar · Accepted Answer · 2017-11-06 20:29:50Z

5

Use an if statement:

if ($row['key'] == 'howdidyoufind') {
    $variable = $row['value'];
}

You could also do it in the SQL:

SELECT value
FROM data
WHERE id = 4534 AND key = 'howdidyoufind'

Then the value you want will be in the only row returned by the query.

answered Nov 6, 2017 at 20:29

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

display array information from sql query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related