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.
Ther
> -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
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
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 bo
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 wan
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 relationship
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 differn
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 informatio
ecrement the items in stock by 3.
>
> Just an idea...
>
> Do you know about database normalization? How is the database designed?
>
>
>
> -Original Message-
> From: elias [mailto:[EMAIL PROTECTED]]
> Sent: August 2, 2001 6:32 PM
> To: [EMAIL PROTECTED]
&g
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
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 on
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
Looks fine to me
Miles
At 10:31 AM 8/2/01 +0200, elias wrote:
>Hi again.
>
>$result = mysql_query("SELECT id FROM table");
>$id_array = array();
>
>while ($r = mysql_fetch_array($result))
>$id_array[] = $r["id"];
>
>// now $id_array[] is an array of IDs that was grabbed from the database.
>
>
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
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]
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);
mysql_select_db($db_databasenam
> 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 name=\"$
On Thu, 8 Mar 2001 02:38, Deependra B. Tandukar wrote:
> Greetings!
>
> I am trying to compile MySQL. what I did are:
> tar -xvzf mysql-3.23.33.tar.gz
> cd mysql-3.23.33
> ./configure --prefix=/usr/local/mysql
> then it startx to work and inerrupt and says
> testing gcc working: no
> configure: e
18 matches
Mail list logo
