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 installi
Hi Kaan
try
Page 1
$testArray[0] =Apple;
$testArray[1] =Banana;
$testArray[2] =Peach;
$testA=implode("!", $testArray);
echo "";
Page2
$testArray=explode("!", $kcompany);
echo $testArray[1];
HTH
Steve
PartyPosters wrote:
Hello,
Please can someone tell me how you pass arrays between PHP pages.
I ha
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
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
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 da
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 4.
min with conf option; 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]
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 connec
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.cs
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 v
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 8
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 erro
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
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 in
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, b
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]
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 c
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 pro
!= t2.id;
>select * from main left join activity on main.user = activity.id
>select @id:=id from activity; select * from main where user != @id;
>
>But each query produces near identical results - more or less a dump of main.
>
>Any ideas gratefully rec'd.
>
>Thanks
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
20 matches
Mail list logo
