1) must be the logged in user ($session_usernumber)
2) wishlist_indicator must be = 0 (off)
I have tried all day and come up with the query and PhP code. The query did work in MySQL, but the script returns NADA.
Any ideas how I can improve it to....well, actually work for instance.
Here is the code:
Code: Select all
<?php
session_register("cart_count")
if (isset($HTTP_POST_VARS['$session_usernumber'])) {
mysql_select_db($database_kb_conn, $kb_conn);
$query_rs_cart = "SELECT * FROM cart WHERE usernumber = $session_usernumber and wishlist_indicator = 0";
$result = mysql_query($query_rs_cart, $kb_conn) or die(mysql_error());
$row_rs_cart = mysql_fetch_assoc($result);
$cart_count = mysql_num_rows($result);
}
?>----------------
SteedVLX
Code: Select all