[SOLVED] php variables and mysql

[sanchez77]

i read it, i read that, i re-read this, and I just don't get it.

 

How do you query a table for a value and store that value as a variable in php?

 

[TeNDoLLA]

<?php
mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db('test_database') or die(mysql_error());

$sql = "SELECT id, name FROM test_table LIMIT 1"; // This will take only one row bcause of limit.
$result = mysql_query($sql)  or die(mysql_error());
$result = mysql_fetch_array($result);
$myVariableName = $result[0]['name'];
$myVariableId = $result[0]['id'];

// print the variable contents
echo 'Name: ' . $myVariableName . ' and ID: ' . $myVariableId;

[sanchez77]

awesome,

 

had to take out the [0] in $result and it worked.

 

thanks alot

 

cheers