Functions

furious5

I have a page which I use an include and call a function (email total) from the included file.

How do I return some of the values within the function back to the page calling the included file?

Sorry if this is a fundamental question, but I haven't really done any work with functions before.

LordShryku

At the end of your function, you need to do a return for your variable.

function countSomething($var, $var1) {
    // do what you have to
    return $totalCount;
}

// then you can capture the variable by using
$thiscount = countSomething($this, $that);

$thiscount will be your variable.

furious5

Thanks for the reply, I understand what you are saying.

However I don't think I have been specific enough.

Once the function is called, I perform an SQL query and want to be able to use the values $category and $make within the file which includes this code.

Here is the code I am using:

function emailtotal($cartid,$sess)
{
$query="SELECT product.category,product.make,product.price,orders.ID,orders.quantity  FROM product,orders WHERE orders.cartID=$cartid AND orders.prodID=product.ID";
$result=mysql_query($query);
$row=mysql_fetch_array($result);

$goodstotal=0;
$category = $row["category"];
$make = $row["make"];
$price = $row["price"];
$quantity = $row["quantity"];

print("<table width=\"395\" border=0 cellpadding=0 cellspacing=0><tr><td height = \"20\" width=\"17\" class=\"menuheader\"><img src=\"images/r_div.gif\" width=\"17\" height=\"20\"></td><td width=\"378\" class=\"menuheader\">Your Cart Contents</td></tr></table>");
print("<table width=\"395\" border=0 cellpadding=3 cellspacing=1>");
print("<tr><td class=\"header2\" width=\"150\">Category</td><td width=\"150\" class=\"header2\">Product</td><td width=\"25\" class=\"header2\">Price</td><td width=\"15\" class=\"header2\">Qty</td><td class=\"header2\">&nbsp;</tr>");

do
{
print("<tr><td class=\"searchlist\">".$category."</td><td class=\"searchlist\">".$make."</td><td class=\"searchlist\">".$price."</td><td align=\"center\" class=\"searchlist\">".$quantity."</td></tr>");
$carttotal=$carttotal+($row["price"]*$row["quantity"]);
}
}

furious5

Could I create a global variable to access the $category, $make variables?

Or is there a better way to do this - anyone??

dankstick

function emailtotal($cartid,$sess)
{
$query="SELECT product.category,product.make,product.price,orders.ID,orders.quantity FROM product,orders WHERE orders.cartID=$cartid AND orders.prodID=product.ID";
$result=mysql_query($query);
$row=mysql_fetch_array($result);

$goodstotal=0;
$category = $row["category"];
$make = $row["make"];
$price = $row["price"];
$quantity = $row["quantity"];

print("<table width=\"395\" border=0 cellpadding=0 cellspacing=0><tr><td height = \"20\" width=\"17\" class=\"menuheader\"><img src=\"images/r_div.gif\" width=\"17\" height=\"20\"></td><td width=\"378\" class=\"menuheader\">Your Cart Contents</td></tr></table>");
print("<table width=\"395\" border=0 cellpadding=3 cellspacing=1>");
print("<tr><td class=\"header2\" width=\"150\">Category</td><td width=\"150\" class=\"header2\">Product</td><td width=\"25\" class=\"header2\">Price</td><td width=\"15\" class=\"header2\">Qty</td><td class=\"header2\"> </tr>");

do
{
print("<tr><td class=\"searchlist\">".$category."</td><td class=\"searchlist\">".$make."</td><td class=\"searchlist\">".$price."</td><td align=\"center\" class=\"searchlist\">".$quantity."</td></tr>");
$carttotal=$carttotal+($row["price"]*$row["quantity"]);
}
return Array($category,$make);
}

In the file that you use to call this function simply...

list($category,$make) = emailtotal($cartid,$sess);

Now you have the vars the function used!

furious5

Spot on, thank you for that.