Ashley M. Kirchner wrote:
Someone's going to tell me to go buy a book, I just know it. I'll
ask anyway:
I'm starting to log weather data to a database and I'm trying to
figure out what's the best way to create the tables. The reports are
coming in every minute, of every hour, 24 hou
[EMAIL PROTECTED] wrote:
So you have two "single table" votes.. make this a third. I'm
guessing that each time you collect data, it's going to be one of
each piece of data every time.
As for efficiency, it's probably more efficient to keep everything in
one table and do your statistics by usi
So you have two "single table" votes.. make this a third. I'm guessing that
each time you collect data, it's going to be one of each piece of data every
time.
Temperature, barametric pressure, humidity, wind direction, etc. You're not
going to have 5 things all the time and like 3 other thin
# [EMAIL PROTECTED] / 2006-12-20 00:01:29 -0700:
>I'm starting to log weather data to a database and I'm trying to
> figure out what's the best way to create the tables. The reports are
> coming in every minute, of every hour, 24 hours a day. Eventually, I'd
> like to do some calculations
At 12/19/2006 11:01 PM, Ashley M. Kirchner wrote:
I'm starting to log weather data to a database and I'm trying to
figure out what's the best way to create the tables. The reports
are coming in every minute, of every hour, 24 hours a
day. Eventually, I'd like to do some calculations on the
Ashley M. Kirchner wrote:
>
>Someone's going to tell me to go buy a book, I just know it. I'll
go buy a book? (can't argue with you intuition now can I ;-)
> ask anyway:
>
>I'm starting to log weather data to a database and I'm trying to
> figure out what's the best way to create the t
On Fri, February 3, 2006 2:15 pm, Paul Goepfert wrote:
> I have a MS Acess Database that goes along with my web page. I want
> to transfer the data to a MySQL database since there are php
> functions for the MySQL database. I do not have a MySQL database
> running on the system that I am devel
> I have a MS Acess Database that goes along with my web page. I want
> to transfer the data to a MySQL database since there are php
> functions for the MySQL database. I do not have a MySQL database
> running on the system that I am developing the web page. However there
> is a MySQL database
py" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 10:56 PM
Subject: Re: [PHP] database question
> \S refers to a non whitespace character.
>
>
> >In the following:
> >select whatever from articles where textline
> what does \S means?
http://www.php.net/manual/en/pcre.pattern.syntax.php
This page gives a good description of many of the regex metacharacters and
their meanings.
Sincerely,
Craig Vincent
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For add
"Warren Vail" <[EMAIL PROTECTED]>; "Michael Hall"
><[EMAIL PROTECTED]>; "PHP List" <[EMAIL PROTECTED]>
>Sent: Thursday, November 29, 2001 9:54 AM
>Subject: Re: [PHP] database question
>
>
>> Actually the sql statement you w
[EMAIL PROTECTED]>; "PHP List" <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 9:54 AM
Subject: Re: [PHP] database question
> Actually the sql statement you want is
>
> select whatever from articles where textlines regexp "^\Sbingo\S$"
>
> regards
>
> select whatever from articles where textlines regexp "^\Sbingo\S$"
Again, that would fail if the word 'bingo' is and the end of the sentence.
Allthou i realized my own example doesnt work either in that case. Best way
would be remove all characters like ,.!? and and split the string into
words.
al Message -
From: "Warren Vail" <[EMAIL PROTECTED]>
To: "Michael Hall" <[EMAIL PROTECTED]>; "PHP List"
<[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 2:57 PM
Subject: RE: [PHP] database question
Try;
SELECT whatever FROM articles WHERE textli
Try;
SELECT whatever FROM articles WHERE textlines LIKE "%searchword%"
Two warnings;
1) This will force a "table scan" (the contents of each row in the entire
table because there can be no index to support faster searching of contents
that float in the column) which will be very slow on a large
You could try something like this:
SELECT * FROM database WHERE text LIKE '%bingo%'
Rick
> How can I search a MySQL database field that contains sentences (VARCHAR
> datatype) or entire texts (TEXT datatype) for single words?
>
> Let's say I want to search 100 articles stored in a database fie
16 matches
Mail list logo
