Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL query


srober

Recommended Posts

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,

Link to comment
Share on other sites

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:

Link to comment
Share on other sites

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

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

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).

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

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..

Lloyd

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...