Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
| Search | Today's Posts | Mark Forums Read
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 29th, 2006, 09:42 PM
Registered User
 
Join Date: Oct 2006
Location: Llanelli, Crmss, United Kingdom.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to majika Send a message via Yahoo to majika
Default Drawing Data from mysql DB to use on app

Hi please can some one guide me as to which is the best method for me to use to retrieve sales data from my online shop so I can analyse the data and edit and insert new records of the same and different records once I have in on my internal network servers ?

I am running Apache Mysql PHP setup.

I can connect to server using my script I can query using my scripts but cant resubmit it back to original database which is held remotely out of my internal network structure?

Many thanks in advance


  #2 (permalink)  
Old October 31st, 2006, 07:11 AM
Friend of Wrox
Points: 1,515, Level: 15
Points: 1,515, Level: 15 Points: 1,515, Level: 15 Points: 1,515, Level: 15
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2003
Location: Oxford, , United Kingdom.
Posts: 488
Thanks: 0
Thanked 3 Times in 3 Posts
Default

So, you've got SELECT privileges on your remote MySQL server but not UPDATE/INSERT?

If you have administrative rights on the server you could just grant your account UPDATE/INSERT priviliges

Code:
GRANT UPDATE on `my_database`.`my_table` TO 'my_account'@'my_location' IDENTIFIED BY 'secret_password';
FLUSH PRIVILIGES;
If not you'll have to make friends with the admin

--
Don't Stand on your head - you'll get footprints in your hair
                                           http://charlieharvey.org.uk
                                              http://charlieharvey.com
  #3 (permalink)  
Old November 1st, 2006, 09:27 AM
Registered User
 
Join Date: Oct 2006
Location: Llanelli, Crmss, United Kingdom.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to majika Send a message via Yahoo to majika
Default

Cheers for reply ciderpunx, Just to confirm that it is a shared hosting account that all the data is on But I do believe I have ADMIN PRIVLIGES on will but i'm not root @ hostname, but anyway, The remote site is where I need to get the data from to update my localhost application every 15 mins so it is kind of real time system that I am trying to develop.



Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieve image data from mysql db vermaarun2005 PHP Databases 0 July 14th, 2007 11:12 AM
problem writing listview data to mysql db method Pro VB 6 2 April 10th, 2007 07:17 PM
problem writing listview data to mysql db method Pro VB Databases 0 May 17th, 2006 06:18 AM
problem with uploading blob data to MySQL DB kyle_shea PHP Databases 1 March 8th, 2005 06:15 PM
Storing PHP Session data in a MySQL db? CFerthorney PHP Databases 1 May 10th, 2004 08:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.