yjim

ok, i need help on how i could code this in php. i have a mysql table that stores the user's timestamp when he clicked on the link and it resets every 24 hours with a new timestamp and the hits also will reset. here's an example table: -------------------------------- USER TABLE -------------------------------- user | timestamp | hits ------------------------------------------------- user1 1261946304 1 user2 1261944605 2 user3 1261944530 2 user4 1261944470 1 user5 1261944067 2 im not sure how to approach this, but how could i get the total average number for the hits in the last 24 hours only?

fixed, thanks. mysql_query("SELECT * FROM `media_cat` WHERE substring(name,1,1) RLIKE '[0-9]'");

that works for the rows that start with 0 digits, but i also have rows that start with other numbers that arent being displayed.

empty results

neither works..i have several items that start with integers 0-9 also.

ok i have this code SELECT * FROM media_cat WHERE name LIKE '(0-9)%' ORDER BY name ASC its not working. im trying to get all the results that start with a number value.

how can i issue a mysql search where the first letter of my item is A or B etc.. or if it starts with a number?

ah that did it, thx.

says call to undefined function

idk its supposed to count the total number of downloads from all the items but its not working. can u fix it?

how can i count the sum of downloads that is stored in several mysql rows i tried this: $query = mysql_query("SELECT downloads FROM items WHERE downloads != 0"); while ($row = mysql_fetch_array($query)) { echo $row['downloads']; } but it doesnt add all the rows together.

bumpity

anyone?

lol, why? php is more than capable. <?php $loop = 'true'; while ($loop == 'true') { echo '<style type="text/css"> .containerdiv { float: left; position: relative; } .cornerimage0 { position: absolute; top: 325px; left: 114px; } </style> <div class="containerdiv"> <img src="{T_IMAGESET_PATH}/site.jpg" width="900" height="380"/> <a href=page1.php><img class="cornerimage0" src="./images/random0.php"/> </dev>'; } ?>

<Directory /test> Deny from all </Directory>