correct, I tried to use
your convention, but I may have missed something.
Robert V. Zwink
http://www.zwink.net/daid.php
-Original Message-
From: Michael Robbins [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 4:55 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Help with a JOIN statemen
In MySQL you can also do this:
SELECT * FROM artists
WHERE
LEFT(title, 1) >= 'A'
AND
LEFT(title, 1) <= 'H'
ORDER BY title
This will return a range of all artists whose title begins with A thru H.
Treat the letters like numbers.
Robert V. Zwink
http://www.zwink.n
The simple answer might be:
SELECT member.*
FROM `member`
WHERE DAYOFYEAR(member_dob) >= DAYOFYEAR(CURDATE())
ORDER BY member_dob DESC LIMIT 1
Seems to work for me. The problem is that it wouldn't support members that
have a birthday on the same day :) To solve that I would select the next
bi
Looks like LIMIT can only contain one number, when using UPATE the offset
parameter cannot be added.
http://www.mysql.com/doc/U/P/UPDATE.html
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]
So . . .
"UPDATE catal
http://www.mysql.com/doc/U/P/UPDATE.html
UPDATE catalogs SET PROCESSED = "Y" WHERE PROCESSED IS NULL LIMIT $i,10
Is this what you are looking for?
Robert V. Zwink
http://www.zwink.net/daid.php
-Original Message-
From: James Kupernik [mailto:[EMAIL PROTECTED]]
Sent: Monday,
If all of your pages share an include file, then add to the include file
something like this:
http://www.newhostname.tld".$PHP_SELF);
}
?>
That way all requests to the old url will be redirected to the new url. You
can also do something similar with JAVASCRIPT (I see you are using
Dreamweaver,
There is also a program called asp2php. I'm sure how effective it is.
http://asp2php.naken.cc/
You are probably best off rewriting the site. That way you will know
exactly what is going on, and can use some of the more advanced features of
php.
Robert Zwink
-Original Message-
From: T
";
}
}
}else{
// supply a method, or do not run
}
?>
Robert Zwink
-Original Message-
From: David W. Fenton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 12:02 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Using text files instead of a DB
O
Use: echo mysql_field_name($result, $i);
Like this:
Robert Zwink
DISCLAIMER This is not my syntax, it is taken from the original poster's
message.
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 7:31 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
You are going to need to post more information. Maybe send part of the
script that is having the problem.
I'm sure there are quite a few people familiar with classes on this list,
but unfortunatly your question may not have enough information.
Also: You posted this question to the php-db list.
I don't understand. What is your question?
Robert Zwink
-Original Message-
From: Keith Whyman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 13, 2001 11:32 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Sure it's simple but.
I've got a several links(each with a seperate arti
http://phpclasses.upperdesign.com/browse.html/package/52
The above link will take you to a class to manipulate CSV files. This might
help you understand file access in php. If you want to maintain a database
within a text file using CSV file format may help.
If you have specific questions don'
In Reply to:
>Hello all.
>
>I have a question.
>How can i define some flexible variables?
You would have to have a method in your object that echoed passed variable
names. So it would look like this instead:
echo $obj->write(ID);
echo $obj->write(TOWN);
echo $obj->write(PHONE);
Or create an a
13 matches
Mail list logo
