Mysql> LOAD DATA INFILE '/tmp/jokes.txt' INTO TABLE jokes FIELDS
TERMINATED BY ''
http://dev.mysql.com/doc/mysql/en/mysqlimport.html
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Jeremy Shovan
-Original Message-
From: Ruprecht Helms [mailto:[EMAIL PROTECTED]
S
do
not recomend leaving this here when when it is live.
die(mysql_error());
}
$numRows = mysql_num_rows($sql_query);
if (($numRows) >0){
$valid = $user;
session_start();
session_register("valid");
}
}
if (session_is_registered("reg")){
echo "ok&q
Try this:
select LastName from MyTable where left(LastName,1) >= 'a' and
left(LastName,1) < 'f';
How about
Select LastName from sometable where LastName >= 'A' and LastName <'F'
Hth Henrik Hornemann
-Oprindelig meddelelse-
Fra: Doug Parker [mailto:[EMAIL PROTECTED]
Sendt: 29. decembe
Use the strtoupper() function
$var = strtoupper($var);
-Original Message-
From: Robert Sossomon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 8:29 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Changing case
I have a form that allows for an item to be entered, the
I was able to get rid of the parse error, but what I saw causing the
error was a little strange. All I did was delete the spaces between
your if statement and the bracket that follows ie. if( not if (
The next thing that I did was rewrote the line that says 'echo
"Open";' although I didnt change
Try rewriting your query. It looks to me that you probably have an
error in your SQL statement and it only seems fine because you appended
the @ to the beginning of the mysql_query() function.
I would suggest using a join statement.
If(!$result = mysql_query("SELECT orders.orderid, orders.amou
Try this
WHERE date_field != $date_1 OR date_field != $date_2 OR date_field !=
$date_3
-Original Message-
From: Mike Baerwolf [mailto:[EMAIL PROTECTED]
Sent: Friday, October 24, 2003 6:46 PM
To: [EMAIL PROTECTED]
Subject: mysql field comparison to multiple variables
Hello,
I trying to
You are selecting it as date but trying to echo DateOfOrder
Try this:
$TheDate = mysql_query("select DATE_FORMAT(DateOfOrder, '%d, %m, %Y') as
date from Orders Where Orders.ID = '$TransID'");
while($OrderDate = mysql_fetch_array($TheDate))
{
$Date = $OrderDate["date"];
}
-Original Message--
Try this, I am assuming that emailerror is one of the fields in your
database.
$thisstart=$massmail[current]-1;
[EMAIL PROTECTED]("select
first_name,last_name,email,".$mysql_prefix."users.username
from ".$mysql_prefix."users $leftjoinfirst $leftjoinsecond
limit $thisstart,$massmail[stop]
where v
Use echo(mysql_error());
-Original Message-
From: Ben Edwards [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 5:43 AM
To: pete M
Cc: PHP DB List
Subject: Re: [PHP-DB] mysql_error() (was Re: Getting last insert id?)
On Thu, 2003-10-09 at 17:35, pete M wrote:
> http://www.php.net/
abel to another window
I'm guessing this is html?
Parent.opener.formname.formfield.value = this.value;
Michael Scappa
-Original Message-
From: Jeremy Shovan [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 12:24 PM
To: 'agus supriatna'; [EMAIL PROTECTED]
Subje
Is it a frame page?
-Original Message-
From: agus supriatna [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 1:25 AM
To: [EMAIL PROTECTED]
Subject: Need help Get/send Variabel to another window
Dear all
I have two page one as main and secon as child, now I have problem how
to
se
How do you pass by reference? I tried
$var = myFunction(&$var1, &$var2);
but it gave me a warning saying that pass by reference is depreciated
-Original Message-
From: Shannon Doyle [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 1:19 AM
To: [EMAIL PROTECTED]
Subject: REGEXP and Variables.
Hi People,
Need a little assistance with the following MySQL query:-
$query = "SELECT employ_id,company FROM employers WHERE emp
-Original Message-
From: Gary H. Holabird [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 11:06 AM
To: [EMAIL PROTECTED]
Subject: Hyperlinks in MySQL dB
This has got to be really simple & I feel really stupid having to ask
but...
I'm a very green n00b writing my first php sc
Try this
function send_html_mail($myname, $myemail, $contactname, $contactemail,
$subject, $message) {
$headers = "MIME-Version: 1.0\n";
$headers .= "Content-type: text/html; charset=iso-8859-1\n";
$headers .= "X-Priority: 3\n";
$headers .= "X-MSMail-Priority: Normal\n";
$headers .= "X-
16 matches
Mail list logo
