Just reorder your list of selected fields.
SELECT fieldnames in order to be returned from tablename WHERE
requirements
-Micah
On Sunday 06 March 2005 01:10 pm, Wendell Frohwein wrote:
Hello all,
Have a question for you, don't know how simple this is. I want the
output that mysql sends
As a kind soul pointed out, I missed the string joining you need to do, so I
feel tasked with addressing this further..
Simple answer: I don't see a way to do this with a single query unless you're
using a DB with subqueries.. in which case you might be able to figure
something out, but
how about :
SELECT (count( b.unique_id ) + 1) ranking
FROM table_name a, table_name b
WHERE a.unique_id = '4' AND b.score a.score
Mike wrote:
Let's say I have a database and I want to find the position of a row when it is
ordered by a specific column
before a sort:
UNIQUE ID | SCORE
ioannes wrote:
If you use LIMIT row_count with ORDER BY, MySQL ends the sorting as
soon as it has found the first row_count lines rather than sorting the
whole table.
http://dev.mysql.com/doc/mysql/en/limit-optimization.html
I need to get the top $num results from a completely sorted table (eg
You could also try www.vitalspeeds.com they dont host any microsoft
stuff like .Net or ASP but they are reliable and cheap. Hope this helps.
Regards,
Marcus Joyce
J. Connolly wrote:
Is there a site that someone could recommend that does PHP, Mysql
hosting? If they do .NET that would be good
On Tue, 2005-02-08 at 16:07 -0500, J. Connolly wrote:
Is there a site that someone could recommend that does PHP, Mysql
hosting? If they do .NET that would be good also. This is for practice
and development not for a company so I am looking to keep the costs
down. There are so many sites, I
i buy my hosting on ebay. haven't had a problem
bastien
From: J. Connolly [EMAIL PROTECTED]
To: PHP list php-db@lists.php.net
Subject: [PHP-DB] MySQL PHP hosting
Date: Tue, 08 Feb 2005 16:07:47 -0500
Is there a site that someone could recommend that does PHP, Mysql hosting?
If they do .NET that
joe,
thanks for the advicei just can't host where i work and trying to
develop only on my laptop only at work is becoing tedious. The sys admin
is not happy about me running iis or apache on my laptop here. But at
least I didn't ask how you how to configure my php and mysql
richard,
You may try to create a VIEW. In this case the tables will be dynamically
linked, that is when some values change in both tales the views
automatically update itself each time you call it.
CPT John W. Holmes [EMAIL PROTECTED] ha scritto nel messaggio
news:[EMAIL PROTECTED]
From: Roger
blackwater dev wrote:
Why is this query handled differently in 4.1?
4.0
select lower(concat(last_name,id)) from client where prim_id=1
returns johnson1
4.1
same query returns Johnson1
Why don't the lower work in 4.1 when you concatonate with a number?
No idea.
select concat(lower(last_name),id)
yeah, that is what I did to fix it...just curious why the problem was
there in the first place.
On Wed, 02 Feb 2005 14:40:55 -0600, Martin Norland
[EMAIL PROTECTED] wrote:
blackwater dev wrote:
Why is this query handled differently in 4.1?
4.0
select lower(concat(last_name,id)) from
precedence of function order may have changed
bastien
From: blackwater dev [EMAIL PROTECTED]
Reply-To: blackwater dev [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB] mysql 4.1-4.0
Date: Wed, 2 Feb 2005 15:46:25 -0500
yeah, that is what I did to fix it...just curious why
try
select concat(lower(last_name),id) from client where prim_id=1
bastien
From: blackwater dev [EMAIL PROTECTED]
Reply-To: blackwater dev [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] mysql 4.1-4.0
Date: Wed, 2 Feb 2005 15:35:08 -0500
Why is this query handled differently in 4.1?
so what exactly is the problem?
bastien
From: mel list_php [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] mysql - image storing
Date: Tue, 18 Jan 2005 11:30:12 +
Hi list,
I try to store/retrieve pictures into MySQL.
I know that a lot of people will say this is not a good
On Tuesday 18 January 2005 19:30, mel list_php wrote:
[snip]
$donnees=stripslashes($row[donnees_binaires]);
[snip]
-I tried different combinations with addslashes/stripslashes, trim in case
of spaces, mysql_real_escape_string...
I haven't looked at your code in detail but stripslashes()
with several header option as I thought it may be the problem as if I
just echo the data without the header they look like normal data for a
picture...
Thanks for the reply.
From: Bastien Koert [EMAIL PROTECTED]
To: [EMAIL PROTECTED], php-db@lists.php.net
Subject: RE: [PHP-DB] mysql - image storing
Date
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
practice to addslashes, when you retrieve from the db, you will need
to use stripslashes to remove the extra \
--
Joseph Crawford Jr.
Codebowl Solutions
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
practice to addslashes, when you retrieve from the db, you will need
to use stripslashes to remove the extra \
If I may step in...
Assuming a MySQL db,
Joseph Crawford wrote:
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
practice to addslashes, when you retrieve from the db, you will need
to use stripslashes to remove the extra \
The slashes are added for
On Wednesday 19 January 2005 01:51, [EMAIL PROTECTED] wrote:
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
practice to addslashes, when you retrieve from the db, you will need
to use stripslashes
Martin Norland wrote:
Joseph Crawford wrote:
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
practice to addslashes, when you retrieve from the db, you will need
to use stripslashes to remove the extra \
The
To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 18 January 2005 17:11, Joseph Crawford wrote:
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it
Joseph Crawford wrote:
Jason, can you explain why stripslashes should not be used on data
taken from the db? when you store data in the db i thought it was good
although 'slashing' text works pretty much all of the time (possibly the
guys using exotic encodings all day will say different :-) but
On Tuesday 18 January 2005 19:18, Jochem Maas wrote:
I was always under the impression that single quotes (assuming you are
delineating you args with single quotes) should (officially) be escaped
with another single quote - although backslash also works:
I think it depends on the database that
Jochem Maas wrote:
I was always under the impression that single quotes (assuming you are
delineating you args with single quotes) should (officially) be escaped
with another single quote - although backslash also works:
INSERT INTO status (hunger) values ('I''ve just eaten.');
...alot of
Simon Rees wrote:
On Tuesday 18 January 2005 19:18, Jochem Maas wrote:
I was always under the impression that single quotes (assuming you are
delineating you args with single quotes) should (officially) be escaped
with another single quote - although backslash also works:
I think it depends on
Martin Norland wrote:
Jochem Maas wrote:
I was always under the impression that single quotes (assuming you are
delineating you args with single quotes) should (officially) be
escaped with another single quote - although backslash also works:
INSERT INTO status (hunger) values ('I''ve just
sqlyog is a great tool
bastien
From: Kris Geens [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL db sync
Date: Sat, 15 Jan 2005 14:06:50 +0100
Hi,
I need some help. Does anyone know a good tool to synchronize MySQL
databases?
Thanks in advance for your help
Regards,
Kris
--
PHP
Kevin the Linux User wrote:
To the PHP Database Mailing-List:
I joined the mailing list for this one question I just can't figure out.
nice, we help you and then you bugger off? - community spirit are go!
I used the phpMyAdmin to create table. I placed one row in this table, I used
the ENCRYPT
On Wed, 05 Jan 2005 18:11:23 -0500, John Holmes
[EMAIL PROTECTED] wrote:
OOzy Pal wrote:
Is it possible to have mysql at an ID as 20050105-1 as
(MMDD-1), -2, etc.
automatically? No. But you can always just use
SELECT CONCAT(date_column,'-',pk_column) AS fixed_id ...
if you
On Friday 07 January 2005 02:29, Andrew Kreps wrote:
This would be a great place for a stored procedure, but I don't know
if I can recommend running MySQL 5 to you. The most platform-safe way
I can think of is to get a count(*) of the number of rows with today's
date, add 1 to it, and stick
-Original Message-
From: Andrew Kreps [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 12:30 PM
Subject: Re: [PHP-DB] MySQL Auto PK
On Wed, 05 Jan 2005 18:11:23 -0500, John Holmes
[EMAIL PROTECTED] wrote:
OOzy Pal wrote:
Is it possible to have mysql at an ID
Andrew Kreps wrote:
...
20050105-1
20050105-2
20050106-1
...etc.
This would be a great place for a stored procedure, but I don't know
if I can recommend running MySQL 5 to you. The most platform-safe way
an open source alternative that does offer this enterprise level
functionality (stored
OOzy Pal wrote:
Dears,
Is it possible to have mysql at an ID as 20050105-1 as
(MMDD-1), -2, etc.
probably, possibly, maybe. take your pick.
as Martin Norland already pointed out to someone else; this is not
[EMAIL PROTECTED] (that beauty of a comment is forever burned
into my neo-cortex! :-)
OOzy Pal wrote:
Is it possible to have mysql at an ID as 20050105-1 as
(MMDD-1), -2, etc.
automatically? No. But you can always just use
SELECT CONCAT(date_column,'-',pk_column) AS fixed_id ...
if you _really_ need something like this. Or just join them together in
PHP.
--
---John Holmes...
Nayyar Ahmed wrote:
Hello All:
Is there any tool available for conversion of M$ Access, Oracle etc Databases
to MySQL database ?
google will probably give you more answers than this list (try also
searching for the term 'datapump' and variations on it)
IBExpert is one tool that will allow you to
DB Designer4 from fabforce (www.fabforce.net/dbdesigner4/)
bastien
From: Nayyar Ahmed [EMAIL PROTECTED]
Reply-To: Nayyar Ahmed [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL database converter ?
Date: Tue, 4 Jan 2005 10:36:20 +0500
Hello All:
Is there any tool available for
Hi Mark,
I guess the best way would be to use some php and sql and let the
application do the checking. First run a query to acertain if the key is
present, if yes then update the main record else insert a new record.
bascially you just need to bring the SQL logic into the app logic.
Bastien
It seems to me that the _mysql manual_ gives a most straightforward and useful
explanation:
If you specify the ON DUPLICATE KEY UPDATE clause (new in MySQL 4.1.0), and a
row is inserted that would cause a duplicate value in a UNIQUE index or PRIMARY KEY,
an UPDATE of the old row is performed.
Hi Everybody ,
Daffodil DB Migration tool provide import/export from a database to
another. It is available at http://www.daffodildb.com/download/index.jsp and
comes with One$DB and DaffodilDB . Use DaffodilDB Browser to import and
export purpose.
Regards,
Manoj Kr. Sheoran
Balwant,
Right now this is an algorithm question, not a PHP or MySQL problem.
Define exactly what you want to see as output, what you have as inputs, and
what process you would have to follow to achieve the output.
But don't suppose - be specific.
Then it's possible to fit it to a language:
Balwant Singh wrote:
hi to all,
may somebody guide me on the following:
I want to retrieve data from MYSQL and then want that PHP do calculation
let hope your not asking how to connect to the DB. and perform a query...
- substract a particular field from its previous row. i.e. suppose i
-Original Message-
From: Perry, Matthew (Fire Marshal's Office)
[mailto:[EMAIL PROTECTED]
Does anyone know of a FREE program that exports MySQL to access? The
trial versions of the
ones I have downloaded do not export all the records of the database.
If you can get a .csv export
why not just link the mysql to access?
bastien
From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql to access
Date: Fri, 17 Dec 2004 09:33:39 -0600
Does anyone know of a FREE program that exports MySQL to access? The trial
versions of the
PROTECTED]
Sent: Friday, December 17, 2004 10:01 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql to access
it would depend on what you need the app to do...if you are looking to use
access to do reporting and/ or act as a front end, then it may be
feasible...
more details, if you care to share
) instead of MySQL?
Thank you all for your time and patience.
- Matthew
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Friday, December 17, 2004 10:01 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql to access
it would depend on what you need the app to do...if you
see embedded comments
bastien
From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql to access
Date: Fri, 17 Dec 2004 10:25:09 -0600
Here is the problem:
I am currently using MySQL and PHP for this application but have realized
recently
This not be what you need, but I think there are some squiggle brackets
missing.
The curly brackets aren't the problem as they're not needed for just
one statement.
Examples at:
http://www.php.net/manual/en/language.control-structures.php#control-structures.if
anna
--
PHP Database Mailing
for inserts , yes, it does
for lots of update, deletes it might be worth to periodically drop and
rebuild the indeces
bastien
From: Yemi Obembe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql Index table
Date: Thu, 16 Dec 2004 04:59:40 -0800 (PST)
just want to know if mysql
This not be what you need, but I think there are some squiggle brackets
missing.
$conexion = mysql_connect(servername,username,password);
?php
If (!$conexion){
Echo Error connecting.;
}
?
Again, I don't think this is the root of the problem but it's the first
thing that popped out
Walker [EMAIL PROTECTED]
To: 'PHPDiscuss - PHP Newsgroups and mailing lists'
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: RE: [PHP-DB] MYSQL Maximum Time Exceeded
Date: Wed, 15 Dec 2004 19:06:01 -0700
This not be what you need, but I think there are some squiggle brackets
missing.
$conexion
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
No... That is just some strange error generated by the cut and
paste. The IS NOT NU LL that is...
The other issue with 'tablename'... I simply typed 'tablename'
in the e-mail because I didn't
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
I have been using a PHP page to update a database table for a
long time now.
Unfortunately, I have noticed that frequently when I perform an update
I get back an error
saying Table 'tablename' doesn't
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL error...
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
I have been using a PHP page to update a database table for a
long time now.
Unfortunately, I have noticed that frequently when I perform
do you have the same user with the same permissions as the mysql cc user?
bastien
From: Bryan Green [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mySQL - can connect with mysqlcc but not PHP code
Date: Fri, 03 Dec 2004 12:52:53 -0800
So here's the problem: I can connect to a mySQL
suggestions or another method?
Thanks a ton!
Nate
[EMAIL PROTECTED]
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 12:11 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql db dump with php
On Wednesday 17 November 2004 13:51, Nate
Nate,
Don't know if this is the case or not, but the destination database has to
already exist on the upload server.
dave
Nate Nielsen [EMAIL PROTECTED]
11/17/2004 10:08 AM
To:
[EMAIL PROTECTED]
cc:
Subject:
RE: [PHP-DB] mysql db dump with php
I tried this but to no avail
if you have access to phpmyadmin, use that to dump the table and then
re-import the created files in the server
bastien
From: Nate Nielsen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql db dump with php
Date: Wed, 17 Nov 2004 10:08:43 -0600
I tried this but to no avail
okay.. i'm stumped. what client libraries?
using php 5, so is it php_mysql.dll???
i'm using a canned script, so i have to make the changes there too?
i checked out the mysql help link. i even started the mysqld with the
--old-passwords parameter...
still getting the error...
thanks...
Bastien
Check the mysql website. Have you upgraded from 4.0x to 4.1 recently. If so
you need to update the client libraries that come with mysql. There are
significant protocol changes from 4.0x to 4.1.
Bastien
From: ian [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject:
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
thnx ya'll... :)
On Mon, 2004-11-08 at 17:52, Bastien Koert wrote:
Check the mysql website. Have you upgraded from 4.0x to 4.1 recently. If so
you need to update the client libraries that come with mysql. There are
significant protocol changes from 4.0x to 4.1.
Bastien
From: ian
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: Tue, 2 Nov 2004 10:05:50
use the offset parameter
$offset = 0; //and is set from the application
SELECT * FROM blah WHERE something0 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
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
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
You were on the right track with mysqldump. Windows doesn't have a
direct cron equivalent - but it does have the ability to schedule tasks.
Write a short batch file or equivalent (you should be able to whip one
together in no time with a little googling) and schedule it to run.
I doubt you'll
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 the
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
How many records it can hold before becoming too slow for practical use
depends entirely
Have a look at some of the case studies at mysql.comthere are servers
handling 50Million records with not problemsat a certain point it
becomes more a hardware issue than a db server issue...
bastien
From: -{ Rene Brehmer }- [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB
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,
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
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()...
]
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
--- [EMAIL PROTECTED] wrote:
If any of the variables used to insert data are
strings ($f1a, $f2a,
etc...), you'll need to have quotes
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 MainTable
single
quotes around the whole date, like '10/15/2004'.
dave
Stuart Felenstein [EMAIL PROTECTED]
10/14/2004 10:02 AM
To:
Stuart Felenstein [EMAIL PROTECTED]
cc:
[EMAIL PROTECTED]
Subject:
RE: [PHP-DB] mysql error and resource ID:
Anyone see something
If you are usiing the INNOdb table type/engine in the mysql db, it supports
transactions. you can wrap the entire set of sql statement in a transaction
and they would get executed as one block. If any fail, then the whole thing
is rolled back. This DOES NOT work with the myISAM table types.
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
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
Could be a scope problem. The connection is declared outside the function
and the attempt to run a query is inside the function...Maybe add the global
command to the connection. Or declare the connection inside the function...
Bastien
From: Antoine [EMAIL PROTECTED]
Reply-To: Antoine [EMAIL
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
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
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
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
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
-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.
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
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
201 - 300 of 916 matches
Mail list logo