SQL query

[srober]

I taken a SQL class many years ago and I dont remember the commands very well. I have a registration site and I would like to see what customers currently have unpaid items in their shopping cart. I would like to see the customer name and what items. I have a feeling that certain vendors may show up thinking they have paid but did not. Anyone willing to give me the correct SQL statement to pull this info out of the database if its possible?

 

Thanks,

[srober]

I taken a SQL class many years ago and I dont remember the commands very well. I have a registration site and I would like to see what customers currently have unpaid items in their shopping cart. I would like to see the customer name and what items. I have a feeling that certain vendors may show up thinking they have paid but did not. Anyone willing to give me the correct SQL statement to pull this info out of the database if its possible?

 

Thanks,

 

Just bumping to be sure all the smart ones got to see my request :P Last time I swear! :blush:

[♥geoffreywalton]

Try w3.schools.com

 

will be along the lines of

 

select customer_name from orders where order_status =

 

I'll let you fing the field names.

 

Also look up left join

[♥bruyndoncx]

isn't that part of the recover carts / unsold carts contribution (not 100% sure of the name,) but you can basically see customer names and cart contents).

[photofxplus]

Or you could do an sql query of the table customers_basket. This table would hold customers_id, product_id, and date_added. Sould be enough info.

something like:

 

$query = tep_db_query("select customers_id, products_id, customers_basket_date_added from " . TABLE_CUSTOMERS_BASKET);

while ($info = tep_db_fetch_array($query))

{ echo 'customers id = ' . $info['customers_id'] . <br> . blahblah...;

}

 

Didnt try it though..