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>

foreach (img as true) { /* img here */ } on loops

i have premium acct btw

apache directives / .htaccess would probably be ur best bet. <Files test.txt> Deny from all </Files>

how can i login my megaupload acct using curl? it uses javascript on its form i think...

im trying to replace < > how can i do this?

nvmd this works: mysql_query("SELECT * FROM items ORDER by (uid+0) asc");

im trying to order my mysql table by a varchar column that contains integers and php spits it out like this: 1,10,11,12,13,14,2,20,21,21 .. instead of 1,2,3,4,5,6,7,8,9,10,11 etc.. any idea how to fix this? here is my code: $query = mysql_query("SELECT * FROM items ORDER by uid asc"); while ($data = mysql_fetch_assoc($query)) {

no, by multiple lines of code i mean code thats submitted in a textarea box column all at the same time, not a single text field.

how can i create a form in php that allows me to submit multiple lines of code into an array to have it inserted into an SQL string.

ok well im trying to check if a user is logged in on one other site that i own but its on another domain. im trying to have it integrated / work with my website that is on a different domain. how should i do this? i thoght checking cookies would be a good idea but seems to be impossible.