I'm fairly new to PHP. I have a MySQL table called 'users' and a field called 'loggedin' which is in time() format.
I need a query that'll check how many players have logged in within the last 24-hours, but I'm not sure where to start. I already have the database connection setup, and just need the amount to be set to "$online24h"
Can anyone help me please?
preg-match with a string and numbers
Hi, I can't get the expression to work for my preg_match, what I'd like is for it to match the string, but only if it is accompanied by a letter, not a number. So if a string was found with a number
Displaying an image using echo command
I had done a query on my database, one of the fields being an image reference to a directory where an image is stored. e.g "/images/picture.jpg"I want to display this image by using
file downloaded can't be read !!
<?php $fileName = 'mypic.jpg';$mimeType = 'image/jpeg';header('content-disposition: attachment; filename=' . $fileName);header('content-type: ' . $mimeType);header('content-length: ' .
Facebook status update API
Hello,So, I'm trying to create my first Facebook application with PHP.Basic ideas for my application:My website includes feature called “tip of the week" and i would like to create a code
How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:Code: <?php$mydate = "";$daysaway = 400;$startdate = "5/5/2005";//I need
Disable Scrollbar in TableControl
Hello everbody,
True way to see if action was successful?
If this is a good way to see if action was successful to continue:Code: function changeGameState($GameId) { mysql_query("UPDATE challenges SET status=status+1 WHERE id='$GameId'");
Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
dinamic "textboxes"?
Ey all, my first post here, i hope its not a hard one I display mysql results in a tableEach row has a link which must send the title of the row to "result.php"
Delete records not in top 15
Hi,I'm creating a hall of fame page in my game and the page will only display the top 15 scores.So I want to delete the scores that get bumped down the list.How would I write the query to delete
