Hi guy's...
I'm totally lost here..because don't have any idea how to make a query for grab record using BETWEEN startdate and enddate since existing record are stored using this format datetime(dd/mm/yyyy hh:mm:ss) but my supplied $startdate and my $enddate are in this format date(dd/mm/yyyy) only....hope someone will shed me some light on this...is it possible to grab those record...??
Code: //example of my query..
$sqlquery = "SELECT * FROM sometable WHERE OFFENCE_NOTICE_STATUS = 'A' AND CREATED_DATE BETWEEN ".$start_date." AND ".$end_date;
//can't run this query because of the stored record in database are in different format datetime(dd/mm/yyyy hh:mm:ss)
//my supplied variable in date(dd/mm/yyyy) format...
Any help are appreciated TQ..
Feed Maker
Hi all.First of all I must say I am not a php developer so I am afraid I don't know much about it.I am using the bloging software on my site called Super Simple Blog. This software includes a file
how to easy edit text, with box? Help.
Hi.I have a little problem. I'm doing a webpage for my aunt and I would like to make it as easy for her as possible to edit the text. So, I am going to make a Admin site where she can login and then I
PHP error on MySQL insert
I'm sure it's the simplest of issues, but I can't recall why this isn't working.Code: [Select]<?php//setup our insert command$sql = "INSERT INTO `my_db_name`.`my_table_name` (`id`,
Floating Point Precision Loss
I'm writing a program to draw a three-dimensional cube (with a corner cut off) without using any 3D graphics APIs. The only API call I make is win32's SetPixel()
cURL proxy
Okay here is the thing... i know how to add proxysCode: curl_setopt($ch, CURLOPT_PROXYTYPE, CURLPROXY_HTTP);curl_setopt($ch, CURLOPT_PROXY,"[i][b]PROXYHERE[/b][/i]");Here are my questions..
Get relative path from absolute path
How would one go about getting the relative path to a file from its absolute path?
article site help remaining text
Hi all hope you will be fineI am creating a article site in this site i want to put some text on main page and link it via "read more" text from articles page and complete article will be
Help with translating C code into assembler code
Hi im doing a project that moves a robot around a maze avoiding walls and need some help with converting C code into assembly code.#include <stdio.h>int left_feeler;int right_feelerint
Time script, set to my time zone?
I am using this line to get the date and timeCode: $time = date(F." ".d.", ".Y." ".g.":".i.":".sa,time());How could I change this to my time zone here
Gridview Not updating in Update Panel
I have a gridview, three dropdown list boxes, and a button on my form. What is displayed in the gridview depends on the values entered in the dropdown list boxes. The button calls a stored procedure
