I realized I need to do some processing on the time after it's retrieved,
so I decided to retrieve hours and minutes separately and then subtract the
necessary time with PHP. Each city has sunset times for each day stored in
the database, in a datetime field. I retrieve all cities and times for
In article
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> In general, is it better to have MySQL select less using TIME_FORMAT than=20
> to have PHP crop the info?
>
> -Lisi
The general rule of thumb seems to be: if mysql can do it, use mysql else
use php.
--
Quod subigo farinam
$email =~
Yes it is posible using the preg_replace substituing the text with the
text or to what ever you want.
If you are not advanced in php you could do it with substr_replace()
function.
The first solution is more dificult to be used but you have the advantage
you can search for each word used in the %
That's what I tried, but when the minutes are less than 40 it doesn't work
I guess because you get negative. Actually, I'm not sure it even workied
for the one that was more than 40. Is there a way to do taking into account
hours as well without having to code by hand "if minutes < 40 " ... etc.
Create a string which is six char long,
(for instance shop the head and tail
of the first string if you are not able
to generate a six char string)
If you chop an 8 char string and MUST have
the special chars in the string then check
that the chopped char's is not a memember of
the special char's
Being thick today:
How do I select unique values from a table? Eg I have a image upload script
that writes the name of the file to a db when it uploads. As we may need to
upload the image several times, my db is full up with several rows with same
titles..
Eg:
img db
id | title | sh
mike karthauser wrote:
Being thick today:
How do I select unique values from a table? Eg I have a image upload script
that writes the name of the file to a db when it uploads. As we may need to
upload the image several times, my db is full up with several rows with same
titles..
Eg:
img db
id
on 18/6/03 12:20 pm, John W. Holmes at [EMAIL PROTECTED] wrote:
> Not really a PHP question...
This is a php db list though.
> SELECT DISTINCT title FROM ...
Thanks for this.
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.b
On Wednesday 18 June 2003 17:21, Lisi wrote:
> That's what I tried, but when the minutes are less than 40 it doesn't work
> I guess because you get negative. Actually, I'm not sure it even workied
> for the one that was more than 40. Is there a way to do taking into account
> hours as well without
HI,
> I am using redhat 9 2.4.20-9 kernel and the following rpm's
> MySQL-devel-4.0.13-0 MySQL-server-4.0.13-0
> MySQL-client-4.0.13-0
> MySQL-shared-3.23.51-1
> php-mysql-4.2.2-17
>
in my phpinfo file I see --with-mysql
> I get the following error when I try to access my php page:
>
> Fatal
Yes please that is what i want.. if it possible to give em the code..
thanks in advance for you and for George Pitcher
"Cristian Marin" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Yes it is posible using the preg_replace substituing the text with the
> text or to what ever you w
Oops! I sent this to the wrong list last night. This is what happens when
we answer emails @ 4:18 AM...
> 4- I want when echo the return $row["address"] to highlight the entered
> keyword (that the user has entered in the search form) in the output with a
> different font backcolor or by just an
Edward , what about the percentage how much accurate the result returned??
"Becoming Digital" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Oops! I sent this to the wrong list last night. This is what happens
when
> we answer emails @ 4:18 AM...
>
> > 4- I want when echo the ret
> what about the percentage how much accurate the result returned??
Let's see... Since you're on the list, I'll give you a discounted rate of
$80.00/hr. I accept Credit Cards, Money Orders, PayPal, and cash.
Seriously, you can't expect us to do your work for you. I know quite little
about strin
This should be as simple as a PHP script that opens a connection to the
destination server (with rights to do all actions you mentioned)..
Opens a text file with all the SQL commands you want to issue, and starts
firing them off at the server 1 by 1...
Once you create the database, you need to m
[EMAIL PROTECTED] wrote:
This should be as simple as a PHP script that opens a connection to the
destination server (with rights to do all actions you mentioned)..
Opens a text file with all the SQL commands you want to issue, and starts
firing them off at the server 1 by 1...
Once you create the
On Mon, 16 Jun 2003 21:13:14 -0500, Norma Ramirez - Tecnosoft
<[EMAIL PROTECTED]> wrote:
Hi all,
I´m starting with posgresql and i trying to use pg_last_oid to get the
last id in a insert query, but this function returns me a big number like
21318 and bigger, but the table just have 3 or 4 reco
I've done a google search, but most of the results are for the part I've
already figured out. People that have the "top 10" sorting usually want
money for their system (one wanted an absurd $500).
I'm working on a database application where users vote on how much they
like a particular picture
Just a shot in the dark.. it may be wrong, but try it out..
"SELECT avg(rating) AS avgrating FROM ratings WHERE parent_id = '$id' ORDER
BY avgrating DESC LIMIT 10"
try that out.. should work.
metin
At 04:06 PM 6/18/2003 -0400, chris wrote:
I've done a google search, but most of the results are
On Wed, 18 Jun 2003 16:06:23 -0400, Chris <[EMAIL PROTECTED]> wrote:
I've done a google search, but most of the results are for the part I've
already figured out. People that have the "top 10" sorting usually want
money for their system (one wanted an absurd $500).
I'm working on a database ap
[...]
what about the percentage how much accurate the result returned??
I'm not sure what kind of keywords or text you're searching, but here's
the algorithm i used a while back, for plain-text search:
given:
$query
$text
/*
curve() maps values between 0 and 1 to.. a curve:
0% -> 0%
25% ->
21 matches
Mail list logo
