奇怪的查询问题php / mysql [英] Strange query problem php/mysql

问题描述

大家好，


我有一张包含很多歌曲的桌子。所有歌曲都有一个叫做点击的字段。

每次看到一个歌曲页面点击成为++，一切顺利

去。


我还有一个页面，我运行查询


select * from table order by hits DESC


没有错误一切都很好，但有歌曲上面没有显示1000多首点击

有50次点击的歌曲...直到...他们越过1500.


这是一个奇怪的问题。 />

页面在这里 http://tinyurl.com/b8qr8


所有超过100次点击的歌曲都会消失...但是他们在数据库中并且

点击量正在上升但他们不会显示在这个页面上，直到他们

再多一个数字。


请帮助我的查询有问题。


我使用mysql 4.022和php 4.3.11


再次感谢


再见

解决方案

*** sm***********@gmail.com 写道/escribió（2005年5月4日23:05:44 -0700）：

请帮助我的查询有问题。

是的，你的代码可能有问题。

-

- álvaroG。Vicario - 西班牙布尔戈斯

- http://bits.demogracia.com - Mi sitiosobreprogramaciónweb

- 不要给我发电子邮件，把它们发给小组

-

谢谢，但帮助在哪里？


再见

你可以在你循环的地方发布代码并输出结果吗？


史蒂夫

smilesinbl ... @ gmail.com写道：

我有一张桌子上有很多歌。所有歌曲都有一个名为
hits的字段。每当看到一个歌曲页面时，点击就会变成命中++，一切都很顺利

我还有一个页面用于运行查询

select * from table order by命中DESC

没有错误都没有错，但是有超过1000次点击的歌曲没有显示在上面的歌曲中，有50次点击...直到...他们的音乐超过1500.

页面在这里 http：// tinyurl.com/b8qr8

所有超过100次点击的歌曲都会消失...但是他们在数据库中并且点击率正在上升但是它们不会出现在这个页面，直到他们交叉了一个数字。

请帮助我的查询有问题。

我使用mysql 4.022与php 4.3.11

再次感谢

再见

Hi all,

I have a table with a lot of songs. All songs have a field called hits.
Everytime a song page is seen hits becomes hit++, everything smooth
going.

I also have a page where I run the query

select * from table order by hits DESC

No error all fine but songs that have 1000+ hits is not shown above
songs with 50 hits...until... they cross 1500.

This is a strange problem.

the page is here http://tinyurl.com/b8qr8

all songs that cross 100+ hits disapear...but they are in the DB and
the hits are going up but they wont show up on this page until they
cross one more digit.

Please help is something wrong with my query.

I use mysql 4.022 with php 4.3.11

Thanks once again

Bye

解决方案

*** sm***********@gmail.com wrote/escribió (4 May 2005 23:05:44 -0700):

Please help is something wrong with my query.

Yep, there''s probably a problem with your code.
--
-- álvaro G. Vicario - Burgos, Spain
-- http://bits.demogracia.com - Mi sitio sobre programación web
-- Don''t e-mail me your questions, post them to the group
--

Hi,

thanks but where is the help??

Bye

Can you post the code where you loop and output the results?

Steve
[e-mail] wrote:

Hi all,

I have a table with a lot of songs. All songs have a field called hits. Everytime a song page is seen hits becomes hit++, everything smooth
going.

I also have a page where I run the query

select * from table order by hits DESC

No error all fine but songs that have 1000+ hits is not shown above
songs with 50 hits...until... they cross 1500.

This is a strange problem.

the page is here http://tinyurl.com/b8qr8

all songs that cross 100+ hits disapear...but they are in the DB and
the hits are going up but they wont show up on this page until they
cross one more digit.

Please help is something wrong with my query.

I use mysql 4.022 with php 4.3.11

Thanks once again

Bye

这篇关于奇怪的查询问题php / mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！