Hi Laurie
You can put the DB data on any disk or directory as long as it's
location is in the .ini file
#Path to the database root
datadir=C:/MySQL/Data/
HTH
Steve
l'[EMAIL PROTECTED] wrote:
I installed Mysql on windows and found out that the documentation does
not talk about
Hi Kaan
try
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
$testA=implode(!, $testArray);
echo INPUT NAME = \kcompany\ TYPE = \hidden\ VALUE=\$testA\;
Page2
$testArray=explode(!, $kcompany);
echo $testArray[1];
HTH
Steve
PartyPosters wrote:
Hello,
Please can someone
backslash escape the quote:
$field=Joe\'s car;
or if you're using PHP you can turn this on automatically
HTH
Steve
Nestor Florez wrote:
Hello world,
I am passing a a string Joe's car as part of the SQL query to be inserted
to a String field.
$field=Joe's car;
$query=insert into mytable
Hi Christopher
You need the FROM MembersData directly after the SELECT and before
outputting.
HTH
Steve
Christopher Chamber wrote:
I have a query:
$QRY = SELECT * FROM MembersData;
-- Executes fine, no problems.
I have another though:
$DataSet3 = SELECT * INTO OUTFILE '/www/Export/DataSet3.csv'
Try PHP, it has built in functions to access both DBs
HTH
Steve
Victor Pendleton wrote:
You may want to look into using a programming language such as C or Java
that communicates between both databases.
-Original Message-
From: Alonso, Claudio Fabian
To: '[EMAIL PROTECTED]'
Sent: 7/7/04
hi
Have you changed the auth bits in config.inc.php in the phpMyAdmin
directory?? You need to tell phpMyAdmin how and who to connect to mysql
as. I can't remember the exact lines but there are 3 lines in the
'servers' section containing (I think) auth_type, user and password.
These need to be
had no mysql list mail for a while
just testing please ignore
mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
just drop the 'distinct' - should give you what you want
mysql select count(last_name) as LnameCnt, last_name from table_ABC group by last_name;
hth
steve
[EMAIL PROTECTED] wrote:
I am using MySQL 4.0.18 and trying to generate a list of the number of row in a table with the same last name, by
Hi Andre
should be GRANT
hth
steve
Steenveld, A. wrote:
I try to grand some rights by using GRAND but for some unclear reason to me I
can't get it to work.
Here is what I type
mysql -u root -p
Enter password: **
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL
; the
default behaviour) then reconnect to phpMyAdmin
HTH
Steve Davies
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SuSE Pro. Automatic online updates/bugfixes. Cheap. Only pay for the
support you need. I've been running MySQL on SuSE for 18+mths with no
problems, and SuSE in general for about 3 yrs for allsorts of thing.
Steve
[EMAIL PROTECTED] wrote:
Hello,
For some time we've been running MySQL (from
Hi Ian
reverse the order of your date, i.e., 2003/09/12 or use the date format
function
hth
steve
Ian O'Rourke wrote:
I'm very new to MySql and I'm having problems inserting dates into my tables
(via the Web using Coldfusion). The user can put the following in the field:
12/09/2003
But the
Hi Trevor
You haven't the query which connection to use:
$result = mysql_query( select * from domains, $link );
HTH
Steve Davies
Trevor Rhodes wrote:
Hello friendly helper types,
What is the problem here. I can't find any errors. I know it's there but as a
newbie I'm as blind as a bat
Hi Jess
Have you tried SELECT DISTINCT
not sure if 'select distinct *' will work but if doesn't 'select
distinct userlastname,userfirstname' will
hope this helps
Steve Davies
Hunter, Jess wrote:
Using PHP as the front end I am creating a form with a dropdown box that
displays information
Sebastian Haag wrote:
Steve,
Steve Davies sagte:
Sinisa Milivojevic wrote:
On Mon, 08 Sep 2003 19:57:25 +0100
Steve Davies [EMAIL PROTECTED] wrote:
Hi All
I'm currently trying to learn C so that I can recode some php/mysql apps
I've got but I've run into probs right
Hi All
I'm currently trying to learn C so that I can recode some php/mysql apps
I've got but I've run into probs right at the start.
I'm trying to compile the examples in PDuBois MySQL (myclient.c the
really easy one ;-( ) and get the errors below.
I'm using SuSE 8.2 but also get the same
Sinisa Milivojevic wrote:
On Mon, 08 Sep 2003 19:57:25 +0100
Steve Davies [EMAIL PROTECTED] wrote:
Hi All
I'm currently trying to learn C so that I can recode some php/mysql apps
I've got but I've run into probs right at the start.
I'm trying to compile the examples PDuBois MySQL
Hi All
Is it possible to mix javascript and PHP in the same script??
I have a number of web based apps written in PHP/MySql and while they
are functionally pretty good they are aesthetically garbage. I'll like
to pretty up the interfaces with rollovers etc, but haven't got time to
learn JS
sql spam filter
Hi
I'm running MySQL-3.23.37 on a cobalt raq. I have a table with approx
40,000 records and a dozen users running simple queries and updates -
names, addresses that kinda thing, but every time a query is run mysql
takes everything it can get and the box freezes:
10:33am up
main where user != @id;
But each query produces near identical results - more or less a dump of main.
Any ideas gratefully rec'd.
Thanks
Steve Davies
-
Before posting, please check:
http://www.mysql.com/manual.php
20 matches
Mail list logo