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
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 hours a day. Eventually, I'd
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
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 on the we
Hi Group,
Currently i am connecting the underlying database
server from every php page. To reduce the connection
overhead i am thinking to store the PEAR DB object
into the registry (session) at the time of user login.
Here i am connecting the Database only one time and
rest of the time i am using
Hi all,
I'm trying to grab information from two DBs one being a mamber db and the
other a report DB
I want to print a list of users(pilots for a Virtual Airline) from the Pilot
db and then next to them the nº of reports and total hours they have so far
from the REPORT DB. The Pilot ID on this li
Hi all,
I'm trying to grab information from two DBs one being a mamber db and the
other a report DB
I want to print a list of users(pilots for a Virtual Airline) from the Pilot
db and then next to them the nº of reports and total hours they have so far
from the REPORT DB. The Pilot ID on this li
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
e all
lower case as well.
Good luck,
Warren Vail
-Original Message-
From: Michael Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 2:21 PM
To: PHP List
Subject:[PHP] database question
How can I search a MySQL database field that contains sentences (VAR
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
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 field as TEXT
for the word "bingo", is there any SQL or PHP way of doing that?
Mick
--
22 matches
Mail list logo
