Return value in array

doby48

I have an array and I am trying to return the value from a certain field in a certain table and am not certainof the syntax. Any help is appreciated. What I have is:

$form_data = array(
	x_Customer_IP => "{$HTTP_SERVER_VARS['REMOTE_ADDR']}",
	x_Description => UNKNOWN,
	tep_session_name() => tep_session_id(),
	prod => "$prod");

for x_Description, I have entered UNKNOWN. This is where I would like to add some code to return the value from a table.

dalecosp

$foo=DOMYSQLSTUFFHERE;

$form_data = array(
    x_Customer_IP => "{$HTTP_SERVER_VARS['REMOTE_ADDR']}",
    x_Description => $foo,
    tep_session_name() => tep_session_id(),
    prod => "$prod");

In re: DO MYSQL STUFF HERE, see the "Newbies forum FAQ and Bookmarked threads...IIRC, planetsim gave a pretty good tute there....

doby48

Thanks, but not quite what I'm looking for. I had figured out declaring the var, but I just can't seem to figure out how to write the syntax for pulling a value from a specific field in a specific table. I can only seem to find how to return the value if certain conditions apply and I want to return the value no matter what it is.

Another way I can accomplish what I am trying to do is if I can take a value and add 1 to it but I can't seem to find the syntax for that either. For example, I have the following:

$form_data = array( 
    x_Customer_IP => "{$HTTP_SERVER_VARS['REMOTE_ADDR']}", 
    x_Description => "$value_id", 
    tep_session_name() => tep_session_id(), 
    prod => "$prod");

For x_Description I need to take the variable $value_id and add 1 to it but I can't seem to find the syntax to do that.

flashgc

Not entirely sure about your request, but I've recently put together some script to pull multiple fields from a table. Maybe it will help.

<?php 
require_once ('{pathtofile}/connect.php');
# Select database or tell me why not
mysql_select_db(test) or die('Could not select database. '.mysql_error());

$query = "SELECT quote,author FROM quotes ORDER BY RAND() LIMIT 1";

$result=mysql_query($query) or die("Invalid query: ".mysql_error());

$row = mysql_fetch_array($result);
$quote = $row['quote'];
$author = $row['author'];

echo '<div align="center"><br>';
echo '  <table width="98%" border="0" cellspacing="0" cellpadding="2">';
echo '   <th nowrap bgcolor="#666666" align="left"><font size="-1" face="Arial, Helvetica, sans-serif">',$author,'</font></th>';
echo '<tr><td valign="top" bgcolor="#333333"><font face="Arial, Helvetica, sans-serif" size="2" color="#FFCC99">',$quote,'</font>';
echo '   </td></tr>';
echo '  </table>';
echo '</division>';

mysql_close();
unset($result);
unset($quote);
unset($author);
unset($dbc);
?>

'quote' and 'author' are field names in the table. $row becomes an array variable that represents the selection from the table.

$quote and $author are assigned values equal to the cells in the array $row which can then be manipulated, output, etc.
Hope this helps.