Can anyone, someone please point me in the right
direction.
I have a multi page form, so at the last page I want
to insert all data into database. Basically I'm trying
to go from 0 - 90 , meaning my skills are less the
basic. And this seems like a big task.
Couple of other things.
1-There would
.
$sql = begin ;
$sql .=insert into table 1...;
$sql .=insert into table 2...;
$sql .=insert into table N...;
$sql .=end;
$result = mysql_query($sql);
hth
From: Stuart Felenstein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL, Multiple tables, and Multipage form using sessions
Date
MySQL is stable enough. May be it'll be better to rewrite your code or
to add some indexes to Users?
I can help you with ideas of refactoring.
Murat BIYIKLI wrote:
I use a Linux web server with PHP-MySQL. The hardware is good enough with
2GHz CPU and 1 GB RAM. and 7200 Cycle/min Serial ATA IDE
I use a Linux web server with PHP-MySQL. The hardware is good enough with
2GHz CPU and 1 GB RAM. and 7200 Cycle/min Serial ATA IDE HDD. Only one web
site is running on it and on every page of that site, it searchs for a value
in Users table including 78000 records and updates that value. The MySQL
Do you have indexes on the searched columns?
Are you searching on numeric links not text (numbers are easier to compare)
What is your structure / data like?
Bastien
From: Murat BIYIKLI [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL performance and crash
Date: Fri, 1 Oct 2004 17
Hi,
I am trying to get skilled up on postgres and decided to port a little
movie database I wrote for mysql with php to access it.
I used an auto converter for the bulk and then tried to tweak. The
following code does not work but the error message it gives me is
strange. It tells me that the
PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql to postgres migration blues...
Date: Thu, 23 Sep 2004 19:44:51 +0200
Hi,
I am trying to get skilled up on postgres and decided to port a little
movie database I wrote for mysql with php to access it.
I used an auto converter for the bulk
Its because the function cannot access your connection object...
Try passing it to the function..
function makelistboxentries($link, $title, $mytable, $mycolumn, $othertable,
$wherestring)
On Thu, 23 Sep 2004 19:44:51 +0200, Antoine [EMAIL PROTECTED] wrote:
Hi,
I am trying to get skilled up
define the connection object as a global var in ur function
function ( params)
{
global $ur_connection_obj;
...
...
}
On Thu, 23 Sep 2004 14:56:10 -0300, Eduardo Sampaio [EMAIL PROTECTED] wrote:
Its because the function cannot access your connection object...
Try passing it to the
On Thu, 23 Sep 2004 22:27:38 +0400, M Saleh EG [EMAIL PROTECTED] wrote:
define the connection object as a global var in ur function
function ( params)
{
global $ur_connection_obj;
...
...
Damn you guys are quick! I like this list...
declaring it as global didn't seem to work -
global
On Thu, 23 Sep 2004 20:51:52 +0200, Antoine [EMAIL PROTECTED] wrote:
declaring it as global didn't seem to work -
global $link;
/* Connect to database */
$link = pg_connect(dbname=movies host=localhost user=anton
password=password)
The global keyword works a little bit differently
On Thu, 23 Sep 2004 12:23:32 -0700, Andrew Kreps [EMAIL PROTECTED] wrote:
On Thu, 23 Sep 2004 20:51:52 +0200, Antoine [EMAIL PROTECTED] wrote:
declaring it as global didn't seem to work -
global $link;
/* Connect to database */
$link = pg_connect(dbname=movies host=localhost
After installing MySQL 4.1.4-gamma, phpinfo() shows MySql client API
v3.23.49 and it needs to be updated to 4.1. But I can't seem to get it
updated. Please help.
I recompiled with:
./configure --with-mysql=/usr/local/mysql --with-apache=../apache_1.3.31
make clean
make
make test
make
1. Did you install MySQL-client or only MySQL-server?
2. Do you think I'm a telepath? Please, if you want good answers, tell,
at least, your OS and PHP version.
I can't help you without any information.
3. You choose wrong maillist for this question. Here are many
php-programmers, but not
hi gang
I'm working on optimizing the SQL for my forum system, but have run into a
problem trying to optimize the function for deleting a thread with
accompanying stats data and posts from the database using 1 query.
The current function, that works, looks like this:
// delete all traces of a
If the threadID column is an int, you don't need to wrap the $threadID
variable in quotes.
HTH ~randy
On Tue, 14 Sep 2004 00:05:56 +0200, -{ Rene Brehmer }-
[EMAIL PROTECTED] wrote:
hi gang
I'm working on optimizing the SQL for my forum system, but have run into a
problem trying to optimize
On Tuesday 07 September 2004 12:14, rolando g wrote:
I am storing array of user IDs as TEXT using the serialize() function
on the array, since several users, one or none can be part of each
record...
and I noticed that the serialized array has the values in double
quotes like :21; for
I am storing array of user IDs as TEXT using the serialize() function
on the array, since several users, one or none can be part of each
record...
and I noticed that the serialized array has the values in double
quotes like :21; for example... so since I know that the values
will be enclosed,
Excellent ... thanks that is exactly what I wanted.
Michael.
On Sat, 04 Sep 2004 20:21:46 -0600
Doug Thompson [EMAIL PROTECTED] wrote:
Michael Gale wrote:
Hello,
Right now I have a mysql select statement with the LIMIT option
of 500.
Is there a way to find what the total
Hello,
Right now I have a mysql select statement with the LIMIT option of 500.
Is there a way to find what the total number of selected results would
of been with out doing a mysql select first with out the limi and using
mysql_num_rows ?
Thanks
--
Hand over the Slackware CD's and back
Michael Gale wrote:
Hello,
Right now I have a mysql select statement with the LIMIT option of 500.
Is there a way to find what the total number of selected results would
of been with out doing a mysql select first with out the limi and using
mysql_num_rows ?
Thanks
You could use
Hello!
I'm writing a PHP script which accesses a MySQL database. As it turns
out, sometimes I get an empty row from a SELECT query which should
normally return one or more rows. The same query executed a while later,
on unchanged data, returns the rows perfectly fine. No errors are
returned,
I finally got my PHP5 installation to support MySQL and now this. When I try
to edit anything on mysqlgui.exe, it just gives me this error: error in
database function: access denied for user @localhost...
I don't know if this has to do with my php installation or what. If not,
flame me for all
-Original Message-
You can use
table
tr
td
and each tr becomes an excel row and each td becomes a cell. This may or
may not work in/before excel97??
If you're looking to create true excel files, then i highly suggest
spreadsheetwrite_excel,
It is an
This is a MySQL error on the server side - you need to make sure that
whatever user you're signing into MySQL with has access to modify the
database/table you're using. I believe the GRANT keyword in MySQL is
what you need -- look at the MySQL reference manual:
http://dev.mysql.com/doc/
Good
Also, take care with the new password hashing:
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
Paul
On Wed, 18 Aug 2004 00:56:08 -0700, Peter Ellis [EMAIL PROTECTED] wrote:
This is a MySQL error on the server side - you need to make sure that
whatever user you're signing into MySQL
[EMAIL PROTECTED] wrote:
I finally got my PHP5 installation to support MySQL and now this. When I try
to edit anything on mysqlgui.exe, it just gives me this error: error in
database function: access denied for user @localhost...
I don't know if this has to do with my php installation or what.
Ok, thanks to many people's help, I have managed to install MySQL right and
login as root with no password. However, MySQL will not allow to log in to my
databases as root. Is this normal, because when I try it brings back the old
access denies: [EMAIL PROTECTED] thing.
So I thought maybe I
This isn't the appropriate list to direct this question to. I suggest
one of the MySQL help lists or a careful reading of the documentation,
which tells you exactly what you need to know.
--
Peter Ellis - [EMAIL PROTECTED]
Web Design and Development Consultant
naturalaxis |
mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by
'password' with grant option;
try this out
balwant
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 19, 2004 12:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL denying
Hi there everyone,
I'm having a dilemma (Now that I have power back after the hurricane hit us
directly in Orlando). Anyway, I need to export a database table to Excel, I
can do it as a .txt file without a problem, but I can't seem to get it to
put each column into a separate cell when I try
I'm having a dilemma (Now that I have power back after the hurricane hit us
directly in Orlando). Anyway, I need to export a database table to Excel, I
can do it as a .txt file without a problem, but I can't seem to get it to
put each column into a separate cell when I try to export as an
You could always use phpMyAdmin...I believe it will export to Excel
(if not, CSV file).
http://phpmyadmin.sourceforge.net/
On Tue, 17 Aug 2004 15:36:49 -0400, Chris Payne
[EMAIL PROTECTED] wrote:
Hi there everyone,
I'm having a dilemma (Now that I have power back after the hurricane hit us
-Original Message-
either output the data as a csv which you are doing (on windoze name
the file with a .csv extension) or take a look at
http://pear.php.net/package/Spreadsheet_Excel_Writer
I have another option that might work for you also. Go to MySQL's website
and grab their ODBC
I have another option that might work for you also. Go to MySQL's website
and grab their ODBC driver and use that to pull data directly into Excel.
That's what I do and the end result tends to be a lot cleaner than going
through cvs or other MySQL exports.
I was not sure that this was a
I have another option that might work for you also. Go to MySQL's website
and grab their ODBC driver and use that to pull data directly into Excel.
That's what I do and the end result tends to be a lot cleaner than going
through cvs or other MySQL exports.
I was not sure that this was
I don't know how you have it setup.
But you can create a XLS file on the fly using PHP
By using header...
header(Content-Type: application/vnd.ms-excel);
header(Content-Dispostion: attachemnt; filename='Project.xls');
header(Pragma: no-cache);
header(Expires: 0);
Then just echo your results
-Original Message-
From: Daniel Brunner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 17, 2004 2:45 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL to EXCEL?
I don't know how you have it setup.
But you can create a XLS file on the fly using PHP
By using header
I don't know how you have it setup.
But you can create a XLS file on the fly using PHP
By using header...
header(Content-Type: application/vnd.ms-excel);
header(Content-Dispostion: attachemnt; filename='Project.xls');
header(Pragma: no-cache);
header(Expires: 0);
Then just
Consider a table similar to the one below.
What I want to do is to get ONE random record from categories(cat) A
and 5 random record from category B
| ID | computer | name | cat |...
1 dell 834A
2 ibm526A
3 apple 134B
4 sony 333A
5
Justin Patrin [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Fri, 13 Aug 2004 15:20:36 +0200, Quentin Cotillard
[EMAIL PROTECTED] wrote:
Consider a table similar to the one below.
What I want to do is to get ONE random record from categories(cat) A
and 5 random record from
On Fri, 13 Aug 2004 19:39:59 +0200, Torsten Roehr [EMAIL PROTECTED] wrote:
Justin Patrin [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Fri, 13 Aug 2004 15:20:36 +0200, Quentin Cotillard
[EMAIL PROTECTED] wrote:
Consider a table similar to the one below.
What I want to do
I don't think there is anything you can do that won't require a full
table scan. I think some people break out the field they want to do a
full text search on into another table using the MyISAM format. So your
core table is InnoDB and your full text search fields are in a
related table that
What is the best way to simulate a fulltext search on a MySQL table of type InnoDB?
Do I index the searchable fields and use the LIKE() function with appropriate
wildcards?
What are the performance implications with this? Switching back to a table type of
MyISAM is really not an option. Is
Is there a piece of software that will allow my to create MySQL
databases and table relations in a graphical format without having to
connect to the database?
I am looking for something where I can point and click the creation of
tables and easily create several relationships between tables (
May be ERwin or BPwin can help you.
imho ERwin works with MSSQL, Access, so maybe new versions work with
MySQL too.
Vincent Jordan wrote:
Is there a piece of software that will allow my to create MySQL
databases and table relations in a graphical format without having to
connect to the database?
I have ERwin 4.1.2208 installed, and it connects to MySQL only through
ODBC, so one needs to have the MyODBC.dll installed. You can then make an
ODBC connection with it. But ERwin is probably a $4,000.00 software
package. Pretty steep for an individual...
dave
May be ERwin or BPwin can help
PROTECTED]
Sent: Wednesday, July 28, 2004 7:39 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL software question
May be ERwin or BPwin can help you.
imho ERwin works with MSSQL, Access, so maybe new versions
work with MySQL too.
Vincent Jordan wrote:
Is there a piece of software
Vincent Jordan wrote:
Is there a piece of software that will allow my to create MySQL
databases and table relations in a graphical format without having to
connect to the database?
snip
Try DB Designer from Fabforce - it has it's idiosyncracies, but it is
free, and I use it without major
Hi there...
I'm trying to select all records from a MySQL database, and exclude those
from certain countries...
I've posted a copy of an SQL statement I've got that I'm using in
PHPMyADMIN.
And as you can see, I've said not to pick Argentina, but there it is???
What first year mistake am I
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 20, 2004 4:58 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL '!=' ???
Hi there...
I'm trying to select all records from a MySQL database, and
exclude those
from certain countries...
I've posted a copy
there is a better way.
Regards,
Aurelien Vandoorine
-Message d'origine-
De : Hutchins, Richard [mailto:[EMAIL PROTECTED]
Envoyé : mardi 20 juillet 2004 14:20
À : [EMAIL PROTECTED]
Objet : RE: [PHP-DB] MySQL '!=' ???
Tris,
Instead of using != in your statement, try using . I looked in my
I was about to suggest the same, the latest builds of MySQL have theese
functions from what I knew... I think youll find what you need there.
Thanks, Kim.
Any stable and fairly affordable hosts out there using these latest builds?
Mine is back a few, no transactional functionality that I can
I've done exactly this for a really cheap-and-dirty instance where two
people were doing bulk data entry into two different instances of a mysql
table which would eventually be stitched together. by giving one a higher
range, the data migration afterwords was very easy.
Other than that, can't
There might be some system that requires a 4 digit number and the PK is
being used directly. Also, this same system might need to be exported
to Excel, which trims leading zeros and is generally a pain in the ass.
Peter Westergaard wrote:
I've done exactly this for a really cheap-and-dirty
I'm developing a site where I anticipate the need to make several updates to
several forms, and I'll want to commit them all at once (i.e. if there's a
failure with any of the transactions, I'd like to be able to back out to
before I started).
Is there a decent way to do this with PHP and Mysql?
Peter Westergaard wrote:
I'm developing a site where I anticipate the need to make several updates to
several forms, and I'll want to commit them all at once (i.e. if there's a
failure with any of the transactions, I'd like to be able to back out to
before I started).
Is there a decent way to do
I was about to suggest the same, the latest builds of MySQL have theese
functions from what I knew... I think youll find what you need there.
--
Kim Steinhaug
-
There are 10 types of people when it comes to binary numbers:
Hello,
I know this is more of a mysql question then php with mysql but I can not find
the answer. I have a primary key in a
table the is setup and working with auto increment.
Now I want to change it so it will start auto incrementing from 1000. So each entry
will be:
1001, then
Michael Gale wrote:
I know this is more of a mysql question then php with
mysql but I can not find the answer. I have a primary
key in a table the is setup and working with auto increment.
Now I want to change it so it will start auto incrementing
from 1000. So each entry will be:
First of
On Tuesday 13 July 2004 07:19, Michael Gale wrote:
I know this is more of a mysql question then php with mysql but I can not
find the answer.
www.mysql.com search auto increment
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
Keep reading and re-reading that page until you have
I just had a bit of a play with it and discovered you can do this:
say your auto-increment index is named 'fred' for arguments sake.
INSERT INTO table SET FRED = 1000
This will just create a record where the auto-index fred will equal 1000.
Next auto-increment, NOT specifying a value for 'fred',
Pablo M. Rivas [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello Torsten,
TR thanks for your help. Unfortunately it's always returning the same row
for
TR each category (maybe because of the group by) and only one row for
each
TR category. I need to select 2 random rows for
I have a system that tracks downloads, capturing loadsa info, but of
interest here, is email and filename.
Simply put, I wanna show all results where file name AND email are unique.
(so if email '[EMAIL PROTECTED]' has filename 'word.doc' 5 times in a table,
I want to only see it once.)
What am
On Tuesday 06 July 2004 17:58, [EMAIL PROTECTED] wrote:
I have a system that tracks downloads, capturing loadsa info, but of
interest here, is email and filename.
Simply put, I wanna show all results where file name AND email are unique.
(so if email '[EMAIL PROTECTED]' has filename 'word.doc'
Hello,
I was wondering how many of you have made the switch to mysqli from the mysql library?
I teach a class in PHP/MySQL and want to keep current with what industry folks are
doing. I did not immediately adopt mysqli into my classroom and am wondering if it's
time.
I was also wondering how
Hello Torsten,
TR thanks for your help. Unfortunately it's always returning the same row for
TR each category (maybe because of the group by) and only one row for each
TR category. I need to select 2 random rows for each category. Any more ideas?
I'ts returning 2 rows each RECORD, but the
Hi there everyone,
I'm using MySQL 4's built-in Boolean handling abilities with PHP 4 which
works wonderfully, but I need to change:
ft_min_word_len
to be 3 characters instead of 4 for fulltext indexing, how can I change this
as words such as cat etc ... are not showing up in my PHP
Chris Payne wrote:
I'm using MySQL 4's built-in Boolean handling abilities with PHP 4 which
works wonderfully, but I need to change:
ft_min_word_len
See here: http://dev.mysql.com/doc/mysql/en/Option_files.html
--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
You need to compile PHP with MySQL support. There is a php-mysql.rpm
package, but I'm not sure if it will work with MySQL 5. You might just
have to recompile PHP (but probably not).
Cole
Iain Wiseman wrote:
Cole S. Ashcraft wrote:
They are at http://dev.mysql.com/downloads/mysql/5.0.html.
Iain
If I select rows with a limit clause I need to know if there are more
rows than the limit.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Bob Lockie wrote:
If I select rows with a limit clause I need to know if there are more
rows than the limit.
Either do a SELECT COUNT(*) prior to your LIMIT query to see how many
total rows there are, or use SQL_CALC_FOUND_ROWS and FOUND_ROWS() (more
info here:
Hi,
I've got the following table:
categorylanguagename
1 de a
1 de b
1 de c
2 de a
2 de b
2 de c
3 de a
3 de b
3 de c
Hello Torsten,
This is one, but I think you can find another one:
Supose your table is called tablename
select * from tablename as a left join tablename as b on
a.category = b.category and a.nameb.name and
a.language=b.language where a.language='de' and b.name is
Pablo M. Rivas [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello Torsten,
This is one, but I think you can find another one:
Supose your table is called tablename
select * from tablename as a left join tablename as b on
a.category = b.category and
How do I enable more connections for mysql. the default is 100 but i want to
set more. does anyone know?
--
**
Free Nokia Ringtones US
http://www.ring-tones.us
**
--
PHP Database Mailing List (http://www.php.net/)
To
Hi,
Refer to
http://dev.mysql.com/doc/mysql/en/Too_many_connections.html
Concretely, the description below is added to the [mysqld] section
of my.cnf (my.ini for Windows), and mysqld is rebooted.
[mysqld]
set-variable=max_connections=500
--
Sumito_Oda mailto:[EMAIL PROTECTED]
--
PHP
Hello,
I know this question is more mysql related then PHP with mysql .. but
If I do a SHOW INDEX from table_name
I see what appears to be two index for the same column ?
table_name 0 PRIMARY 1 columnname A NULLNULLNULL
table_name 0 columnname
Hi Everyone !
I've coded a php site for a musical store. At the end of every page, before
closing the connection, I send an UPDATE request to increment a statistical
tool. Recently I saw weird results, so I tried to understand. Looking in my
logs, I saw that this request could be sent several
Good day list,
I was running a Mysql/PHP DB/Webpage that was hosted on Redhat 8.0
It was a simple DB - only 1 table, and the php page connected and fed data
to it.
Last weekend I rebuilt the server to Fedora Core 2 - using the default
PHP/Mysql/apache installs.
I setup the databases, and
Online I could see everything, and the pages gave the appearance of
working,
however when I went into the DB using PHPMYADMIN to check the status
of the
new data entered, all I found was blank rows ( for the new data since
the
rebuild, all the old data was there) There were the correct number
]
Sent: Sunday, June 13, 2004 11:22 AM
To: Andrew Rothwell
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Mysql not receiving the data
Online I could see everything, and the pages gave the appearance of
working, however when I went into the DB using PHPMYADMIN to check the
status of the new data
Andrew Rothwell wrote:
Hi Larry, Thank you very much for the very quick response, I set my php.ini
file (located /etc/php.ini ) for the register_globals = On (it was off by
default)
Now however I get an error
Error adding entry: You have an error in your SQL syntax near 's spanish
driver is found
';
Hope this helped.
Rich
-Original Message-
From: Andrew Rothwell [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 13, 2004 1:48 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Mysql not receiving the data
Hi Larry, Thank you very much for the very quick response, I set my php.ini
file (located
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Mysql not receiving the data
Hi Larry, Thank you very much for the very quick response, I set my
php.ini
file (located /etc/php.ini ) for the register_globals = On (it was off by
default)
Now however I get an error
Error adding entry: You have an error
you all again
Andrew
-Original Message-
From: franciccio [mailto:[EMAIL PROTECTED]
Sent: Sunday, June 13, 2004 12:26 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Mysql not receiving the data
I agree, the slashes are killing the query. I would suggets doing this:
$add = INSERT
Hi Andrew,
Andrew Rothwell wrote:
Thank you everybody that responded so quickly -
I used the suggestion of Franciccio - and the data is now gow into the db
Thank you very much - I really appreciate the help.
Another question - with this fix in place - do I still need the
register_globals = On ?
Or
Some of the reason to have register_global on is to easly use variables
sent by post, get, cookie method of a form.
Ex.
form name=form1 method=post action=anypage.php?get_var=1
input type=text name=text_post value=Hello World
input type=submit name=Submit value=Submit
/form
in your code at
Hello,
I am no expert but I believe more information is required, like what
would be the average return of a mysql operation ? How many different
DB's are you accessing ? How many different usernames and passwords for
mysql are you using ??
I believe persistent connections are only
Hi all!
I am using a select statement to obtain all the dates whenever someone
submitted a problem in a database. Well, I want to get the result
(which could be multiple dates) and then print that in a table format
with some other information on a webpage. So I want to use a FOR loops
and go
Hey there PHP fiends,
I have a bit of cookie here. We're designing a PHP based app that uses MySQL as
the data storage. Scalability is an issue, we want to be able to handle up to
1 people utilizing the system (not at once of course).
Question is, should I be connecting and disconnecting
Greetings,
I'm trying to set up a PHPWiki using Apache 2.0.49, PHP 4.3.7, PEAR 4.1.0,
and PHPWiki 1.3.10.
I get this error when trying to load index.php:
C:\Program Files\Apache
Group\Apache2\htdocs\lib\WikiDB\backend\PearDB.php:778: Fatal[256]:
wikidb_backend_mysql: fatal database error
DB
Hi!
You missed table definition:
... FROM my_table where ...
Wednesday, June 9, 2004, 12:57:02 PM, PHPDiscuss wrote:
PPNaml Greetings,
PPNaml I'm trying to set up a PHPWiki using Apache 2.0.49, PHP 4.3.7, PEAR 4.1.0,
PPNaml and PHPWiki 1.3.10.
PPNaml I get this error when trying to load
is there anyway to add 1 to an int with 1 mysql query, i know i can pull
the value down with a SELECT then add 1 with php.. then do an UPDATE on
it.. but i didn't know if there was any other way?
thanks
Steve Mo'
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
update field = field + 1;
On Friday 04 June 2004 01:47 pm, Steven Morgan wrote:
is there anyway to add 1 to an int with 1 mysql query, i know i can pull
the value down with a SELECT then add 1 with php.. then do an UPDATE on
it.. but i didn't know if there was any other way?
thanks
Steve
Wait, sorry, It's late..
update tablename set fieldname = fieldname + 1;
That will increment all the rows in table, you can add a 'where' statement to
limit the update.
update tablename set fieldname = fieldname + 1 where indexfield = someindex;
-Micah
On Friday 04 June 2004 01:47 pm,
I need to make a dbf file with some mysql records
The creation of the dbf with the dbase_create works FINE
Now I need to fill the dbf, I have a mysql database with some of the data, I
have the apropiate SQL to view that data but I need to make an array with
that data and some , 0.
How can i do
-
From: Bill Green [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 4:05 PM
Subject: [PHP-DB] mysql went away
HI. I've been using mySQL 4.0.13, php4.3.4, and phpMyAdmin2.5.5 on Mac
OS 10.3.3 as a learning/testing/development environment for a couple of
months now - no problems
Hello
We currently run mysql 4.0.14 in MyISAM table format.
Server config :
Dual P-3 600
1GB of ECC SDRAM
6 SCSI drives 10,000 RPM using RAID 5 Array.
OS :
RedHat Linux 9.
We just realized we really need the adnvaned futures of InnoDB or MaxDB/SAP DB.
What would it takes (System preformance,
HI. I've been using mySQL 4.0.13, php4.3.4, and phpMyAdmin2.5.5 on Mac
OS 10.3.3 as a learning/testing/development environment for a couple of
months now - no problems, works great.
I've created more than a few mySQL databases and tables, but yesterday
I created a database, a table, and LOAD
401 - 500 of 1362 matches
Mail list logo
