pulling specific information from the order databases

[bobio]

I want to grab all the information stored in my attributes for a specific order. when an order gets completed is there a specific number (field) that is used to identify all aspects of the order, like a (cart number) or (order id).

so when I search within this result (number or field) all information regarding the order will be found.

[jammin320]

It is possible to pull any information from the Zen Cart Database that Zen Cart itself accesses - however, that information is almost never in one place. Most of the time it is scattered across multiple tables and requires some intermediate skilled query writting.

How are you planning on "getting" this information - are you hitting the DB direcctly?

[bobio]

I do not know, I am familiar with programming and databases but new learning zen, php and sql. I am going through the wiki to learn what I need to do to pull the info. I am trying to figure out when an order is placed what reference is there to the order database to the customer database and so on, is there a common link that they all share?

[rtp3789]

here are the data base tables and PHP is the languange You use to talk to the data base. You can hard code info from a table. then do a search. but i do not think You can do a search directly to the data base i might be wrong.

You can see Your tables with phpadmin if that is the program Your server is using to work with the data base. most paid for servers like godaddy use phpadmin or use the one Your server uses. sorry for the long post but people should see this stuff it's interesting how it all works

# address_book
# Browse address_format
# Browse admin
# Browse admin_activity_log
# Browse authorizenet
# Browse banners
# Browse banners_history
# Browse categories
# Browse categories_description
# Browse configuration
# Browse configuration_group
# Browse counter
# Browse counter_history
# Browse countries
# Browse coupons
# Browse coupons_description
# Browse coupon_email_track
# Browse coupon_gv_customer
# Browse coupon_gv_queue
# Browse coupon_redeem_track
# Browse coupon_restrict
# Browse currencies
# Browse customers
# Browse customers_basket
# Browse customers_basket_attributes
# Browse customers_info
# Browse customers_wishlist
# Browse db_cache
# Browse email_archive
# Browse ezpages
# Browse featured
# Browse files_uploaded
# Browse geo_zones
# Browse get_terms_to_filter
# Browse group_pricing
# Browse languages
# Browse layout_boxes
# Browse manufacturers
# Browse manufacturers_info
# Browse media_clips
# Browse media_manager
# Browse media_to_products
# Browse media_types
# Browse meta_tags_categories_description
# Browse meta_tags_products_description
# Browse music_genre
# Browse newsletters
# Browse nochex_apc_transactions
# Browse nochex_sessions
# Browse orders
# Browse orders_products
# Browse orders_products_attributes
# Browse orders_products_download
# Browse orders_status
# Browse orders_status_history
# Browse orders_total
# Browse paypal
# Browse paypal_payment_status
# Browse paypal_payment_status_history
# Browse paypal_session
# Browse paypal_testing
# Browse products
# Browse products_attributes
# Browse products_attributes_download
# Browse products_description
# Browse products_discount_quantity
# Browse products_notifications
# Browse products_options
# Browse products_options_types
# Browse products_options_values
# Browse products_options_values_to_products_options
# Browse products_to_categories
# Browse product_music_extra
# Browse product_types
# Browse product_types_to_category
# Browse product_type_layout
# Browse project_version
# Browse project_version_history
# Browse query_builder
# Browse record_artists
# Browse record_artists_info
# Browse record_company
# Browse record_company_info
# Browse reviews
# Browse reviews_description
# Browse salemaker_sales
# Browse sessions
# Browse specials
# Browse tax_class
# Browse tax_rates
# Browse template_select
# Browse upgrade_exceptions
# Browse whos_online
# Browse zones
# Browse zones_to_geo_zones

[bobio]

thanks, I am getting closer to my goal.