Build shopping cart with php & dreamweaver mx

cage

I try to display the list of items in shopping cart stored in the database.... and i wanna compare with php session_id()... the current is....

Using dreamweaver server behaviour to add record... it generate the following code....
<?php
mysql_select_db($database_conn, $conn);
$query_listcart = "SELECT cart.quantity, products.ProductName, products.UnitPrice, products.ProductImage FROM cart, products WHERE products.ProductID = cart.productid";
$listcart = mysql_query($query_listcart, $conn) or die(mysql_error());
$row_listcart = mysql_fetch_assoc($listcart);
$totalRows_listcart = mysql_num_rows($listcart);
?>

How do i add a line for $query_listcart, at the end ... with the value of cart.sessionid equal to the value of php session_id() ???

sneakyimp

you want to add a line to do what exactly? your question is very unclear. furthermore, your grasp of php seems tentative at best. you might consider reading about some of the functions you are trying to use at www.php.net. the docs there are very good and you might understand better what you are trying to do.

cage

<?php
mysql_select_db($database_conn, $conn);
$query_listcart = "SELECT cart.quantity, products.ProductName, products.UnitPrice, products.ProductImage FROM cart, products WHERE products.ProductID = cart.productid WHERE cart.sessionid = session_id();]
$listcart = mysql_query($query_listcart, $conn) or die(mysql_error());
$row_listcart = mysql_fetch_assoc($listcart);
$totalRows_listcart = mysql_num_rows($listcart);
?>

Was the part underlined and bolded correct..??? WHERE cart.sessionid is from the database and i wanna compare its value with php session_id();

sneakyimp

Like I said, you might want to read up on PHP.

First off, you have opened a string with " but you fail to close it.

Additionally, "session_id" is a string with exactly that phrase. I doubt you will ever have a cart id that is equal to the string of letters that spell out "session_id". You should do something like

$sql = "SELECT blah blah blah WHERE cartid=" . session_id();

each line must be terminated by a semicolon, etc. This is very basic stuff. Again, you can try www.php.net or perhaps this book . If you're desperate, you can have it delivered overnite.

cage

Ha...

What to do...

So difficult to change the query generated by the Dreamweaver MX...

Guess i just have to manually type the query myself...

sneakyimp

Journey of 1,000 miles begin with single step....