; Bastien
>
> >From: ian <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >Subject: [PHP-DB] MySQL problem..
> >Date: Mon, 08 Nov 2004 17:02:53 +
> >
> >Any body met this error?
> >Warning: mysql_connect(): Cli
ian wrote:
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
http://dev.mysql.com/doc/mysql/en/Old_client.html
--
PHP Database Mailing List (h
ubject: [PHP-DB] MySQL problem..
Date: Mon, 08 Nov 2004 17:02:53 +
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
--
PHP Database Mailin
Any body met this error?
Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
/usr/local/apache2/html/poems/browse.php on line 15
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.n
use the offset parameter
$offset = 0; //and is set from the application
SELECT * FROM blah WHERE something<>0 LIMIT $offset , 5;
bastien
From: [EMAIL PROTECTED] (Jovan Ross)
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Mysql Function to display number of records
Date: 2 Nov 2004 20:28:41 -
I have a query that uses a LIMIT clause. Let's say it looks like this:
SELECT * FROM blah WHERE something<>0 LIMIT 5;
Ok, now my table really has 20 rows that satisfy the WHERE statement but I
only retrieved 5. There was a function/statement that I could use to find
out the total number of rows t
write a script that will access the information, then use a CRON to schedule
the collection at whatever intervals suite your needs.
Bastien
From: "Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL data harvester
Date:
My office purchased 21 fascinating cell phones that have GPS locaters and
bar codes.
When we scan a bar code with one of these cell phones, the data is sent to a
third party company; information about this scan is stored on their
database.
I have installed a "harvester" on my pc that downl
Perry, Matthew (Fire Marshal's Office) wrote:
Does anyone know a free MySQL backup program to schedule regular backups?
mysql has the ADMINISTRATOR, well at least for win32...
does timed backups.
--
Leo G. Divinagracia III
[EMAIL PROTECTED]
z
--
PHP Database Mailing List (http://www.php.net/)
Perry, Matthew (Fire Marshal's Office) wrote:
Does anyone know a free MySQL backup program to schedule regular backups?
Hi Mathew, i made an litle script to do that.
mysqlbk.pl
Desc: This script made and mysql rotative backup fron sunday to sunday
ch x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
-Original Message-
From: Perry, Matthew (Fire Marshal's Office)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 8:58 AM
To: [EMAIL PROT
On Wednesday 27 October 2004 13:57, Perry, Matthew (Fire Marshal's Office)
wrote:
> Does anyone know a free MySQL backup program to schedule regular backups?
www.mysql.com
google > mysql mailing list
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Inte
Does anyone know a free MySQL backup program to schedule regular backups?
Stuart Felenstein wrote:
First time setting something like this up. So probably
making some major mistakes.
Anyway I get this message : "mysql_error(Resource id
#2)"
[snip]
echo " . mysql_error($link)";
Read the above line or use an editor that does syntax highlighting.
Also, you'll want to get th
4.1 is supposed to handle them, how well is another issue
bastien
From: Matthew Perry <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL nested subqueries
Date: Sat, 16 Oct 2004 18:30:56 -0500
Anyone know when there will be a version of MySQL that can handle nested
subq
> becomes more a hardware issue than a db server issue...
>
> bastien
>
> >From: -{ Rene Brehmer }- <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: [PHP-DB] MySQL max records
> >Date: Sat, 16 Oct 2004 02:01:07 +0200
>
>
> >
>
Matthew Perry wrote:
Anyone know when there will be a version of MySQL that can handle nested
subqueries?
-Matt
http://dev.mysql.com/doc/mysql/en/ANSI_diff_Subqueries.html
v4.1, but it isn't the stable release at this time.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Anyone know when there will be a version of MySQL that can handle nested
subqueries?
-Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
: [PHP-DB] MySQL max records
Date: Sat, 16 Oct 2004 02:01:07 +0200
How many records it can hold before becoming too slow for practical use
depends entirely of the hardware that makes up the server.
Current versions of MySQL has a finite limit of 2^64 records per table, but
how many billion recor
ApexEleven wrote:
I tried a little research on the mysql list but didn't find what I was
looking for.What is the limit of a MySQL database? How many hundreds
of thousands of records can a database hold before it gets too
sluggish to work on a production server?
Check the output from phpinfo()... I'
How many records it can hold before becoming too slow for practical use
depends entirely of the hardware that makes up the server.
Current versions of MySQL has a finite limit of 2^64 records per table, but
how many billion records you can shove into it before you start seeing
performance issue
I tried a little research on the mysql list but didn't find what I was
looking for.What is the limit of a MySQL database? How many hundreds
of thousands of records can a database hold before it gets too
sluggish to work on a production server?
thanks,
--
<<---
t; integers, right? So put single
> quotes around the whole date, like '10/15/2004'.
>
> dave
>
>
>
>
>
> Stuart Felenstein <[EMAIL PROTECTED]>
>
> 10/14/2004 10:02 AM
>
>
>
>
>
> To:
> Stuart Felenstein <[EM
Anyone see something wrong here :
My error message is :
"0: 1064: You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server
version for the right syntax to use near
'd',1,'d',1,1, 31, 33,10/15/2004))' at
line 5"
Code:
$query = "INSERT INTO MainTabl
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: 14 October 2004 15:43
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] mysql error and resource ID:
>
>
> Quote as in "string" or quote as in 'string' ?
> Those two confuse me.
;
>
>
>
> Stuart Felenstein <[EMAIL PROTECTED]>
>
> 10/14/2004 08:26 AM
>
>
>
>
>
> To:
> Graham Cossey <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED]
> cc:
>
>
>
>
>
> Subject:
> RE: [PHP-DB] mysql error and reso
Well believe it or not I got it right finally.
Just used the example from the manual.
Meanwhile, the funny thing is , I think the error
translates back to my original error abut Resource
ID#2
Because not I get :
Check the manual that corresponds to your MySQL server
version for the right syntax t
Stuart, you need to define $link if you're going to use it ;)
>
> Not much luck here on placing the mysql_error($link);
> I know the server and database is reachable. So I
> imagine the error is happening in the query. I've
> moved the $link around with no luck.
>
> Stuart
>
> Revised code below:
If any of the variables used to insert data are strings ($f1a, $f2a,
etc...), you'll need to have quotes around them.
dave
Stuart Felenstein <[EMAIL PROTECTED]>
10/14/2004 08:26 AM
To:
Graham Cossey <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
cc:
Subject:
RE: [PH
Not much luck here on placing the mysql_error($link);
I know the server and database is reachable. So I
imagine the error is happening in the query. I've
moved the $link around with no luck.
Stuart
Revised code below:
--- Graham Cossey <[EMAIL PROTECTED]> wrote:
--
PHP Database Mailing Lis
A few ideas...
[snip]
> Anyway I get this message : "mysql_error(Resource id
> #2)"
>
[snip]
> @mysql_connect("myserver","myusername", "mypassword")
> or die(mysql_error());
>
> @mysql_select_db("mydatabase") or die(mysql_error());
> $link = mysql_connect("myserver", "myusername",
> "mypassword");
First time setting something like this up. So probably
making some major mistakes.
Anyway I get this message : "mysql_error(Resource id
#2)"
I know it's pointing me to something but not sure what
.
My suspicion since I'm driving blind :) is that I'm
attempting an insert using invalid or incorrect
.
$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: [
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 ne
: "Murat BIYIKLI" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL performance and crash
Date: Fri, 1 Oct 2004 17:41:57 +0300
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
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 HD
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:
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
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 hos
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 dif
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 -
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 functi
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 u
lt;[EMAIL 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
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 conne
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 syste
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 i
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 opt
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 th
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"; f
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
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 SQL_CALC_FO
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
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, ju
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]
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 | http://www.naturalaxis
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 jus
[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. I
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
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 luc
> -Original Message-
>
> You can use
>
>
>
>
> 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 ex
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
>>
>> 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("Ex
> -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
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 res
> > 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
> 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 m
> -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 O
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 hi
> 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
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 t
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.
> >
"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 r
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 category B
>
> | ID | computer | name | cat |...
>1dell 834
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
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 t
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?
Try DB Designer from Fabforce - it has it's idiosyncracies, but it is
free, and I use it without major problems.
Petrov [mailto:[EMAIL 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.
&
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
Dezigner
www.datanamic.com
Excellent piece of software.
_
- Original Message -
From: "Vincent Jordan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 28, 2004 1:27 PM
Subject: [PHP-DB] MySQL software question
> Is there
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?
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 ( k
problem, even if I'm quite sure 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 u
e first thing I'd try.
Rich
> -Original 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
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 making
rom: "Peter Westergaard" <[EMAIL PROTECTED]>
Date: Wed, 14 Jul 2004 09:40:28 -0400
Subject: Re: [PHP-DB] Mysql and rollbacks
> 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.
> 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
On Tue, 13 Jul 2004, 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)
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:
tho
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'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?
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 ins
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 ima
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', wi
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
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
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 1002,
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 man
401 - 500 of 1531 matches
Mail list logo