oblem is that is counts the number of rows in the whole thing not the
echoed row. How can I get it count the best days only?
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
later do stuff with it in PHP):
+---++
| name | percent |
+---++
| foobar | 75|
| barfoo | 25|
+---++
Thanks in advance,
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
g the entire script into a file and
then using within the page. The problem is that I
don't know how to output the image with PHP.
The image would not be dynamic just a file on the server.
I would appreciate peoples comments or other suggestions
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
Sorry wrong PHP list :}
"Jj Harrison" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I am making a stats program.
>
> When the nessicary include file is included it does a reverse-DNS lookup
to
> find the remote host'
w can I echo count(referer) ?
I currently get this error
Warning: Undefined index: count(referer) in
C:\Inetpub\TecEco_PHP\stats_interface\referer_base.php on line 16
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
"Jj Harrison" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTE
ent' then I could use a join to get the
title, time etc of the article and return the results.
What I am asking is that if this is a good table structure for something
like this(N00B alert!). If not could you please give me a better one?
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
score > 0
and article_data.aid = article_keyword.aid group by article_data.aid order
by score desc
when I do the query in PHP I get a message saying: Unknown column 'score' in
'where clause'.
How can I fix this?
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
--
Thanks for the replies so far.
I see which method is best in 5-10 min.
My question is that if SQL/mySQL support some sort of function to see if a
database entry is in the supplied text?
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
"Jj Harrison" <[EMAIL PROTECTED]> wrote i
I am using mysql.
Is it possible to count the number of words in a text column?
Or is this a job for php(The info will be going into php anyway)?
I can use $word = explode(' ',$row['text']);
then use count($word ).
I just ask because mysql *may* be able to do it.
-
#x27;, 8.94855);
INSERT INTO article_keyword VALUES (3, 'our', 4.47427);
INSERT INTO article_keyword VALUES (3, '(the', 4.47427);
INSERT INTO article_keyword VALUES (3, 'troposphere)', 4.47427);
INSERT INTO article_keyword VALUES (3, 'climate', 4.47427);
INSE
Here is one line of my new query:
INSERT INTO article_keyword (aid,keyword,weight) VALUES (3, 'gases',
13.42282);
I get the same error:
You have an error in your SQL syntax near '; INSERT INTO article_keyword
(aid,keyword,weight) VALUES (3, 'gases', 13.42282)' at
It turns out phpMyAdmin actually splits up the queries and does them
singaly.
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
"Cornelia Boenigk" <[EMAIL PROTECTED]> wrote in message
00ef01c23580$2ed210c0$7f54fea9@zwerg98">news:00ef01c23580$2ed210c0$7f54fea9@zwerg98..
In the mysql command line ; is used to signify the ending of the current
query
"Jj Harrison" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> It turns out phpMyAdmin actually splits up the queries and does them
> singaly.
&
I know how to delete stuff from a db.
Now I want to delete all the earliest entires from the database except the
latest 75 entries.
Is it easy or hard?
I know about limit but it doesn't seem to work the other way.
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
--
PHP Database Ma
..
this would fixed the problem with coloumns with the same name also
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
"Herman Verkade" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> Well, I'm just a beginner myself, but
thx.
"Dan Koken" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>
> Jj Harrison wrote:
>
> > I know how to delete stuff from a db.
>
>
> > Now I want to delete all the earliest entires from the database
How, using the group by and where statments can I return the percentage of
something?
ie:
pid| oid| uid |
1 |2 |1
1 |2 |1
1 |2 |1
1 |1 |1
would return
oid | percent
2| 75
1| 25
Thx,
--
JJ Harrison
[EMAIL PROTECTED
Plz ignore this. found it after more searching...
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
"Jj Harrison" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> How, using the group by and where statments can I return the percen
select count(poll_vote.vid) as total, (count(poll_vote.vid) /
'.$row['total_qs'].' * 100) as percentage, poll_option.poption from
poll_vote, poll_option where poll_vote.oid = poll_option.oid and
poll_vote.pid = '.$pid.' group by poll_vote.oid';
--
JJ Harrison
[EM
() is often used to store passwords and make them non-viewable.
if you are just looking for a unique number an auto-increment coloumn in
mysql or what ever should do it.
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
"Rainydays Sunshine" <[EMAIL PROTECTED]> wrote in message
[EMAIL
mySQL will tell you where your error is.
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
"Rich Hutchins" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have been wrestling with this off and on for the past couple days and
> would r
I may be wrong about the addslashes thing. Just trying to help :)
I would echo all of the post data. It appears as if very little was sent.
Check your form field names etc...
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
"Jj Harrison" <[EMAIL PROTECTED]> wrote in message
way to append more to an existing variable. Very useful in your
case.
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
> "Unknown Sender" <[EMAIL PROTECTED]> wrote in message
> 002701c23924$da9b1e40$539f4dd5@administrator">news:002701c23924$da9b1e40$539f4dd5@administrat
ame (which it shouldnt
be).
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
--
Please reply on the list/newsgroup unless the reply it OT.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks
I originally wasn't doing a cross-table join with that query so I forgot to
put the join in :-}
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
--
Please reply on the list/newsgroup unless the reply it OT.
"Michael Hazelden" <[EMAIL PROTECTED]
ble has article data. The other has article comments (which include a
rating).
With this query it only returns articles with comments. How can I get it to
return all of them? (and return 0 as avg if there are no comments)
I am really stuck here.
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.
26 matches
Mail list logo