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.
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
-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
ganu ullu wrote:
Hi all,
I installed a opensource php project, and now is working fine for me.
Now that project has some 40-50 MySQL tables..
now I want to change something in that but the I am not able to get the DB
flow..
Is any body knows any tool by which we can create/make the
Ask the open-source project for help. They will be able to answer your
questions better than we can.
On 2/25/06, ganu ullu [EMAIL PROTECTED] wrote:
Hi all,
I installed a opensource php project, and now is working fine for me.
Now that project has some 40-50 MySQL tables..
now I want to
Hi,
Saturday, February 25, 2006, 5:53:23 AM, you wrote:
gu Hi all,
gu I installed a opensource php project, and now is working fine for me.
gu Now that project has some 40-50 MySQL tables..
gu now I want to change something in that but the I am not able to get the DB
gu flow..
gu Is any body
At 12:31 PM -0600 9/11/01, Jared Mashburn wrote:
I am tring to run a query On the First Column and place the data into an
array. The problem that I am running into
Is that there are doubles, triples, and sometimes more of the same name
in that column. Each name represents something differnet
On Mon, 10 Sep 2001 16:33, Roman wrote:
In mysql database i have 5 tables, their names are :
db
user
host
tables_priv
columns_priv
I know which information are in tables (db,user,tables_priv,
columns_priv) and I know for what serve this tables but i don't know
some information about
Miles,
The LIMIT works great with UPDATE too.
Miles Thompson [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Come on, you're pushing SQL in directions it's not supposed to go! It is
set oriented after all.
So it's experimentation time. I've never tried, but
Come on, you're pushing SQL in directions it's not supposed to go! It is
set oriented after all.
So it's experimentation time. I've never tried, but as LIMIT works on a
SELECT, try it on an update. And let us know what happened.
Miles
At 10:30 AM 8/2/01 +0200, elias wrote:
How can I update
Depends what is to happen to the array afterwards, but in general no.
An interesting thing is to put timing method calls around a block of code in
question, you will find something like this (depending upon size of db)
takes somehting like 0.005 seconds. Timing things can be useful measures of
a
database normalization? How is the database designed?
-Original Message-
From: elias [mailto:[EMAIL PROTECTED]]
Sent: August 2, 2001 6:32 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySql help #1
Someone purchased items from my site let's say 3 items out of 5 total. All
items are the
Sounds like a strange request, what are you trying to do?
I don't think you can do this directly in mysql, but you could build an
array of results in php.
eg something like (crappy code below)
//Grab results
$db = mysql_connect($db_domain, $db_user,$db_password);
Someone purchased items from my site let's say 3 items out of 5 total. All
items are the same. I just want to update 3 items status to Reserved.
When he buy he just tell how many and not which ones.
Lawrence Sheed [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]
...
is the database designed?
-Original Message-
From: elias [mailto:[EMAIL PROTECTED]]
Sent: August 2, 2001 6:32 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySql help #1
Someone purchased items from my site let's say 3 items out of 5 total. All
items are the same. I just want to update 3 items
Warning: Unable to jump to row 0 on MySQL result index 2 in
/home/sites/site3/web/showthumb on line 71
--here is my code
Change it to look like this:
$connetion = mysql_connect("localhost","cel34243","s2343223") or
die($php_errormsg);
$query = "select images from celeb where
16 matches
Mail list logo