[Resolved] Help

John_wilson

ok, these may be in the wrong section, but I've only been doing php for a few weeks so9 I think I'm a noob.

first, how do querys return results??

I've got this $money=mysql_query("SELECT money FROM pupils WHERE name='$user'");
$data=mysql_fetch_array($money);
print("$data");

I've tried just printing $money but get an resource id 2 printed??
with the above code I get Array printed? Help?

The second bit is I'm getting the number of shares and there prices from tables, is there any way I can multiply these together as it seems not to work!

code:
$query=mysql_query("SELECT owned.share, shares.price, owned.number FROM owned, shares WHERE ((owned.name ='$user')&&

(shares.share=owned.share))");

while ($row =@ mysql_fetch_array($query)) {
$table_body .="
<table>
<tr><td>$row[share]</td>
<td>$row[number]</td>
<td>$row[price]</td>
<td>$row[number*price]</td></tr>";

}
?>
<table>
<? echo $table_body; ?>
</table>

It connects to the database fine but I can't manipulate the data correctly.

bad76

Originally posted by John_wilson
first, how do querys return results??

I've got this $money=mysql_query("SELECT money FROM pupils WHERE name='$user'");
$data=mysql_fetch_array($money);
print("$data");
with the above code I get Array printed? Help?

Hi,
The values are stored from resultset into $data.
This is an Array, that mean you can access it with $data[0], $data[1],$data[2] etc... If you use mysql_fetch_array you can also access it with name of field, $data["field1"], $data["field2"], $data["field3"]..

But you can read all this in the manual.
www.php.net/mysql

Originally posted by John_wilson
$query=mysql_query("SELECT owned.share, shares.price, owned.number FROM owned, shares WHERE ((owned.name ='$user')&& (shares.share=owned.share))");

while ($row =@ mysql_fetch_array($query)) {
$table_body .="
<table>
<tr><td>$row[share]</td>
<td>$row[number]</td>
<td>$row[price]</td>
<td>$row[number*price]</td></tr>";
}
?>
<table>
<? echo $table_body; ?>
</table>

Now you know because this is not valid...
If you need number*price you can do in two way:

In the code: $row["number"]$row["price"]
In SQL: "SELECT shares.priceowned.number as total"
=> $row["total"]

Any other hint: you are learning, then when you use mysql_query() is usefull write it in this way:

mysql_query($myquery) or die(mysql_error()." <br> ".$myquery);

On error this will halt the script and show what is wrong.

John_wilson

Thanks, thats got it.