Strange query problem php/mysql

[smilesinblues]

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

[Alvaro G Vicario]

*** sm***********@g mail.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
--

[smilesinblues]

Hi,

thanks but where is the help??

Bye

[deja]

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

Steve
smilesinbl...@g mail.com 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

[Sadara]

sm***********@g mail.com 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.

what's the data type of the field 'hits'?

<snip />

s

[Alvaro G Vicario]

*** sm***********@g mail.com wrote/escribió (5 May 2005 01:36:11 -0700):

thanks but where is the help??

My excuses... That was all the help I could provide with the information I
have. You posted a link to the resulting HTML and all I can tell you is
that your HTML is fine, the problem must be in the underlying code (either
PHP or SQL).

--
-- Á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
--

[smilesinblues]

Hi,
Forgive me for not giving the php code.

the datatype for hits is varchar(10).

The query is :

$query_mostwant ed = "SELECT * FROM table ORDER BY hits DESC";

I repeat the <tr> using:

<?php do { ?>
<tr>
<td><?php echo $serialid++; ?></td>
<td><?php echo $row_mostwanted['song']; ?> - <?php echo
$row_mostwanted['hits']; ?></td>
<td><?php echo $row_mostwanted['artist']; ?></td>
</tr>
<?php } while ($row_mostwante d = mysql_fetch_ass oc($mostwanted) ); ?>
Please help and let me know if you need any more info.

Thanks once again
Bye

[smilesinblues]

Hi,

I am so sorry but isnt there anyone who can help?

Thanks
Bye

[Jan Pieter Kunst]

sm***********@g mail.com wrote:

Hi,
Forgive me for not giving the php code.

the datatype for hits is varchar(10).

The query is :

$query_mostwant ed = "SELECT * FROM table ORDER BY hits DESC";

I repeat the <tr> using:

<?php do { ?>
<tr>
<td><?php echo $serialid++; ?></td>
<td><?php echo $row_mostwanted['song']; ?> - <?php echo
$row_mostwanted['hits']; ?></td>
<td><?php echo $row_mostwanted['artist']; ?></td>
</tr>
<?php } while ($row_mostwante d = mysql_fetch_ass oc($mostwanted) ); ?>
Please help and let me know if you need any more info.

Thanks once again
Bye

I find that style of mixing of code and HTML rather unreadable. How
about this:

<?php

$query_mostwant ed = "SELECT * FROM table ORDER BY hits DESC";
$result_mostwan ted = mysql_query($qu ery_mostwanted) ;
$serialid = 1;

while ($row_mostwante d = mysql_fetch_ass oc($result_most wanted)) {
echo
"<tr><td>$seria lid</td><td>{$row_mo stwanted['hits']}</td><td>{$row_mo stwanted['artist']}</td></tr>\n";
$serialid++;
}

JP

--
Sorry, <de*****@cauce. org> is a spam trap.
Real e-mail address unavailable. 5000+ spams per month.

[smilesinblues]

Hi,
I can't belive i can be such a big dump.....i just had to change the
varchar(10) to int. thats it. its working now.

thanks to everyone who tool out time.

Thanks