[SOLVED] variables from database

[guymclaren]

variable = queryresult('column')

 

$aff1 = $affdetails('ref2');

 

What am I doing wrong here, sorry to ask such a basic question. I can find lots of info about variables but nothing that actually tells me how to do this.

[kenrbnsn]

Please post all of the script, so we can see the context of your question.

 

Ken

[F1Fan]

You are using parenthesis rather than brackets. Try this:

 

$aff1 = $affdetails['ref2'];

[guymclaren]

$affdetails =" SELECT id, ref2, ref3, ref4 FROM affiliates WHERE aff_id = '$aff'";
mysql_query($affdetails) or die(mysql_error()); 


$aff1 = $affdetails['ref2'];
echo $aff1;

 

OK so what is wrong?

[F1Fan]

You're missing the fetch function:

 

$affdetails =" SELECT id, ref2, ref3, ref4 FROM affiliates WHERE aff_id = '$aff'";
mysql_query($affdetails) or die(mysql_error()); 
$result = mysql_fetch_assoc($affdetails);
$aff1 = $result['ref2'];
echo $aff1;

[guymclaren]

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/webtech.co.za/httpdocs/order.php on line 42

[F1Fan]

Arg, my bad.

 

<?php
$affdetails =" SELECT id, ref2, ref3, ref4 FROM affiliates WHERE aff_id = '$aff'";
$result = mysql_query($affdetails) or die(mysql_error()); 
$row = mysql_fetch_assoc($result);
$aff1 = $row['ref2'];
echo $aff1;
?>

[guymclaren]

Thank you sir, you are a scholar and a gentleman