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..
ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp
Wierd if else problem
Hi guys, this probably aint wierd for you, but it seems like php is playin up to me. may b i missed something. so i'm kinda needing another set or may more sets of eyes. lol.this is the
my two tables
table1 : col1 = topicid , col2 = topictable2 : col1 = sentid, col2 = sentenceCode: require_once("includes/connection.php"); $trends = mysql_query("SELECT topicid, topic FROM
search query in mysql in php problem
my search query wont work, i know, that my codes are correct.please helpCode: [Select]<table width="300" border="0" align="center" cellpadding="0"
simple script won't work. Please help
I'm new to php, and I am having trouble displaying a simple script in my web browser. My php code executes fine but the html tags in my script are treated as text and displayed on the page. This is
Help adding strtolower( to my in_array
strtolower i need to add it to this to work, iuno how.Code: $moderators = array('Admin', 'banana', 'orange');if (in_array("{$_SESSION['user_name']}", $moderators)) print('Found it!');i
code help - pagination
Hi all, I have this code, basically a user logs into my site and they get this page. The problem I have is that the pagination isn't working, and I can figure out why. I dont get any errors.Can you
Is there a function ... auto send IP
Is there some function that can be sent to a ddns service that returns the ip address of a ddns forward. I am working on a script that uses a dvr from a home and the owner wants to have the dvr stream
$variable = $variable
HelloSorry if this is a really simple question but I have run out of ideas. Is there a really simple way of doing the following:$animal_dog = $something_something[$i]['animal_dog'];$animal_cat =
why this query can delete duplicates ?
why this query can delete duplicates ? Anybody can give me the detailed explanation ?
