So the database consists of jobs completed in a computer shop.
Every time a job is finished, the technician hit's complete and the date is put into 'closed'.
I need to run through all the days (1 - 30 (31)) for the selected month of the selected year so I can get the No. of Jobs each...
Okay, something seems to have worked, but now this is happening.
Here's my code (Which I know is a bit fucked up, I started getting stressed).
function getRows($user)
{
$q = mysql_query("SELECT day(closed) AS day, COUNT( closed ) AS c FROM ost_ticket WHERE year(closed)...
Hello,
I can't really explain this without description so here goes.
I need to have a year (2013), a month (January) and a user (Josh).
I have a big database and I want to see how many jobs Josh did throughout the month January of 2013.
Here's my current query:
SELECT Day( closed ) as D...
Made friend requests actual requests.
Friend requests are shown in the navigation bar like "Friend Requests ([NUM])".
Added about me section with in-line editing (Thanks to jQuery).
Added profile pictures.
Added navigation bar.
Added a little bit of styling.
Fixed the error when sometimes clicking "Like" or "Delete" on a post, user's were taken to a 404 page.
Hello, all.
Yesterday I started working on a Social Network.
Here's currently what I have done and what I need to do
Done
Register
Login
Text Status Updates
Adding people (I still need to add something which lets the user accept or deny the request because right now they can just add you...
"To combine new and old query strings, use the [QSA] flag"
Source: http://httpd.apache.org/docs/current/mod/mod_rewrite.html
"The "NC" flag indicates the condition is case-insensitive"
Source: http://www.addedbytes.com/cheat-sheets/mod_rewrite-cheat-sheet/
"The [L] flagterminates rewriterule...
Right now I have something like this in my htaccess
RewriteEngine On
RewriteRule ^index$ index.php [L]
RewriteEngine On
RewriteBase /
RewriteRule ^index/page/([a-z-0-9]+)/?$ index.php?page=$1 [NC,QSA,L]
It allows you to put localhost/index/page/[num] instead of index.php?page=[num]
Maybe...
No.
I'm doing the program.
I need someone to help (help is the keyword there Kaz).
I can do most of it myself, but at the rate I'm going now, it would take forever - as college is coming to an end, things are getting pretty hectic.