Re: [PHP] mysql help (sorry, a bit OT)

2010-11-19 Thread Andre Polykanine
Hello Gary, Actually, what I do here is the following: I create a subdomain called beta.mysite.com (for me it's http://beta.oire.org/ and http://beta.gviragon.org/ :-)). There I have a copy of my database and all of my files. The only difference is the mysql_select_db in the connect.php file.

Re: [PHP] mysql help (sorry, a bit OT)

2010-11-16 Thread a...@ashleysheridan.co.uk
It's always best practice to have a staging server for testing these sorts of things. If in doubt, run it in a transaction, but don't commit it, I.e. roll it back. That way you'll see if it would run but nothing actually changes. Thanks, Ash http://www.ashleysheridan.co.uk - Reply message

RE: [PHP] mysql help (sorry, a bit OT)

2010-11-16 Thread Tommy Pham
-Original Message- From: Gary [mailto:php-gene...@garydjones.name] Sent: Tuesday, November 16, 2010 5:35 AM To: php-general@lists.php.net Subject: [PHP] mysql help (sorry, a bit OT) Is there a way to check the syntax of a query, short of running it? I've got an insert to do (but