problem with function

[ccp999]

I just wonder why in the code below isn't working. it stop at the line: "$result = mysql_query...". but if I copy the code from the addToCart function into the switch statement after the "case'add'", then no problem at all. What's wrong with the use of function here?

*Actually, I was first put the function "addToCart" in a separate file, and since I couldn't get it work so I move it to here.

and at the time the Yellowgreen Part of the code are working fine.

ccp

==========================================================

<?php

require_once('library/config.php');

$action = (isset($GET['action']) && $GET['action'] != '') ? $_GET['action'] : 'view';

switch ($action) {
case 'add' :
addToCart();
break;

...

}

function addToCart()

{
$productId = (int)$GET['pid'];
$qty = (int)$GET['qty'];
$sid = session_id();
$sql = "SELECT productID FROM shopcart WHERE productID = $productId AND shopcart.clientID = '$sid'";
$result = mysql_query($sql, $testconn) or die(mysql_error());
$totalRows = mysql_num_rows($result);
}

$query_cartset = "SELECT * FROM shopcart, product WHERE shopcart.productID = product.ID AND shopcart.clientID = '$sid'";

$cartset = mysql_query($query_cartset, $testconn) or die(mysql_error());

$row_cartset = mysql_fetch_assoc($cartset);

$totalRows_cartset = mysql_num_rows($cartset);

?>

[thorpe]

what error are you getting? and please.... use the [ php ] tags.

[ccp999]

it shows only a blank screen, no error message.

[KingWylim]

Try the following query:

$sql = "SELECT * FROM shopcart WHERE productID = $productId AND shopcart.clientID = '$sid'"; 

The where function solves the problem of locating ProductID you do not need to state it during the SELECT function. I'm not sure if this will solve your problem but it will hlep.

[ccp999]

I tired it but still not working. what could be the problem by putting the code into function?