Greetings and Salutations Ian,
Somewhere in your code you are going to have a line similar to this:
$currentConnection = mysql_connect ($server, $userName,$password)
$server is going to be either the name or the IP address of your server
$userName is going to be the MySQL user name you use to
Thanks, Thor and Cal ; )
"Ian" [EMAIL PROTECTED] wrote in message
99eaaj$njn$[EMAIL PROTECTED]">news:99eaaj$njn$[EMAIL PROTECTED]...
Please help me !!!
Description :-
Server 1 is installed MySQL which located in US.
Server 2 is
MySQL doesn't support nested selects.
At 04:13 PM 3/18/01 -0500, Jen wrote:
Could someone please give their insight?
I'm having trouble with this query...
SELECT CONCAT(c.l_name, ", ", c.f_name) name
FROM contractor c
WHERE c.contractor_id NOT IN
(select c.contractor_id
FROM
I did change the id fields from TINYINT to INT (that was just a careless
error), and fixed something else. But I still have the same problems. The
new table schemas are below, along with the queries that don't work.
I'd love for someone to reproduce the error. As a possible workaround,
("DocCountry", "INSERT INTO files (idProject, name,
comment) VALUES (0, 'sysmsg9.txt', 'Some file')");
}
else echo("Connection failed");
-Mensagem Original-
De: Chris [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: tera-feira, 6 de maro de 2001 16:13
Assunto: R
Have you put an echo with mysql_error() after performing each query ?
Jayme.
-Mensagem Original-
De: Chris [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: segunda-feira, 5 de maro de 2001 05:04
Assunto: [PHP-DB] MySQL - Problem with multiple INSERTs?
Howdy,
I'm getting weird
Three things I see:
1. You seem to be assigning hard-coded values to u_mange_users, and "0" ,
as it is last, will always win. I think, I alsway have to mess with them a
bit. That's why checking your SQL is important.
2. You are embedding a semi-colon in SQL statements. That's not necessary.
I doubt that a few thousand records would be more than mysql is capable of
handeling.
However my ignorance of Mysql is abundant.
Does it use the /tmp directory and is your /tmp or root partition small?
(guessing linux here).
Does mysql use the /tmp directory for temporary tables?
(Answer in
Sir, it would help to see the INSERT statement and the table definition.
Bob Hall
I sent this message to the "general" list yesterday, and have yet to get an
answer (except for that Spanish "Snow White" virus attempt from Peru).
I'm trying to download info from a table as a tab-delimted text
At 03:24 AM 2/22/01 -, Sridhar Ranganathan wrote:
Hi
I have mysql on linux and windows on the same machine. How do i transfer
data between them??
use mysql dump to create a script, .sql file, and execute it on the other one.
=
"To dwell within Samsara,
What about...
GRANT ALL PRIVILEGES ON *.* TO user@"%" IDENTIFIED BY 'user_pass' WITH GRANT
OPTION
make also this for localhost...
GRANT ALL PRIVILEGES ON *.* TO user@localhost IDENTIFIED BY 'user_pass' WITH
GRANT OPTION
By the way, RTFM ;-)
Vojta
hi all...
can you tell me how can i grant
I'm afraid there is no articles on this matter. You are facing a database
design matter.
Auto-increment primary keys must haven't any meaning other than just be the
primary key and relate one table to another, if you had a function to
"update" the auto-increment field to eliminate the holes that
create table foobar (todaysdate datetime default now());
jeff
On Sun, 4 Feb 2001, phobo wrote:
Never used pgsql; but try DEFAULT NOW() NOT NULL ??
Siggy
- Original Message -
From: "Cameron" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 04, 2001 5:18 AM
I am a beginner but did it like this, with a little help from my friends!!
$query = "INSERT INTO guests ";
$query .= "(guest_id, guest_name, ";
$query .= "guest_email, guest_time, guest_message) ";
$query .= "values(, '$name', '$email', NULL, '" .
str_replace("\n","br", $message)
al-
De: Rubanowicz, Lisa [EMAIL PROTECTED]
Para: 'James Smith' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Enviada em: sexta-feira, 26 de janeiro de 2001 07:59
Assunto: RE: [PHP-DB] MySQL/PHP Form Addslashes() command
I am a beginner but did it like this, with a little help from my friends!!
$query
Hello!
JJeffman wrote:
There is the "nl2br()" function too :
// From php manual :
nl2br -- Converts new lines to HTML line breaks.
Description
string nl2br(string string);
Returns string with 'BR' inserted before all new lines.
Sure, but never add any html tag to the
901 - 916 of 916 matches
Mail list logo