A strange bug? Maybe not. You'll never know unlesss you read...

F_SH

Hello all.

I have a very strange problem. I try to do a simple database query, using mysql_query() (duh!). I've done this before many times, so I think the code is OK, but from the following code I get
"Resource id #15" for $rfunds
"Resource id #16" for $ofunds
Doinh their repective queries through phpMyAdmin give me the values (integers) I want..

$query = "SELECT * FROM tblcontracts WHERE isopen=0";
$resulta = mysql_query($query);

while ($row = mysql_fetch_array($resulta))
	{
	$contractid = $row["id"];
	$origin = $row["origin"];
	$recipient = $row["recipient"];
	$rtype = $row["rtype"];
	$rvalue = $row["rvalue"];
	$rduration = $row["rduration"];
	$otype = $row["otype"];
	$ovalue = $row["ovalue"];
	$oduration = $row["oduration"];
	$duration = $row["duration"];

echo "<br>Transaction #";
echo $contractid;
echo " starting...";

$message = "Transaction OK";

$query = "SELECT Funds FROM tblcomp WHERE Compname='".$recipient."'";
$rfunds = mysql_query($query);

echo "<br>Recipient Funds: ";
echo $rfunds;

$query = "SELECT Funds FROM tblcomp WHERE Compname='".$origin."'";	
$ofunds = mysql_query($query);

echo "<br>Origin Funds: ";
echo $ofunds;

nnichols

You seem to have forgotten to use one of the mysql_fetch_ functions to retrieve the data from the result set.

$query = "SELECT Funds FROM tblcomp WHERE Compname='".$recipient."'";

$res = mysql_query($query);
// assuming it will only return one row, otherwise must use some form of loop
$row = mysql_fetch_assoc($res);
$rfunds = $row['Funds'];

echo "<br>Recipient Funds: ";
echo $rfunds;

F_SH

I've never had to use that function before. Still, I'll try it..

I also queried the database to select *, then used mysql_result(), to the same effect.

nnichols

You always have to use a mysql function to access the data in the result set!

You should change your query so you don't run multiple queries -

<?

$query = "SELECT a.* , b.Funds AS rfunds, c.Funds AS ofunds
	FROM tblcontracts a, tblcomp b, tblcomp c
	WHERE a.isopen=0
	AND a.recipient=b.Compname
	AND a.origin=c.Compname";
$resulta = mysql_query($query)
	or die('MySQL error: '.mysql_error().'<br>Query: '.$query);

while ($row = mysql_fetch_array($resulta)) {
	$contractid = $row["id"];
	$origin = $row["origin"];
	$recipient = $row["recipient"];
	$rtype = $row["rtype"];
	$rvalue = $row["rvalue"];
	$rduration = $row["rduration"];
	$otype = $row["otype"];
	$ovalue = $row["ovalue"];
	$oduration = $row["oduration"];
	$duration = $row["duration"];
	$rfunds = $row['rfunds'];
	$ofunds = $row['ofunds'];

echo "<br>Transaction #";
echo $contractid;
echo " starting...";

$message = "Transaction OK";

echo "<br>Recipient Funds: ";
echo $rfunds;

echo "<br>Origin Funds: ";
echo $ofunds;
}
?>

Hope this helps 😉

F_SH

I must admint, I've never used syntax like that before, but I see how it might work. I'll give it go...

Thanks..