Hi this is Scorpionz

Reason of this thread:

I have created a small record sheet in which, I created 3 fields namely
('name, store_date, store_time') and handling this through PHP like i insert name in the field and press button it then saves (Present time as stated in machine and Present date).
I take date as type: date
and time in varchar in my database, I am using mysql as a DB.

and then showing a record on my browser that i add it with date and time

Now the question is that, If i want to see a record of those to whom
i added in last 24 hours, What should the query be??? As i mention in the query as well in comments field

Any response will be highly appreciated with great interest. Here is the code. my database table structure is this:

CREATE TABLE `name_store` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(20) collate latin1_general_ci NOT NULL,
`store_date` date NOT NULL,
`store_time` varchar(20) collate latin1_general_ci NOT NULL,

and below is the code its not difficult to run it as i have already mention the condition, that is of Time and date issue.

<table width="308" border="1">
    <td width="99"><em>Name</em></td>
    <td colspan="2"><label>
      <input type="text" name="name" />
    <td colspan="2"><label>
      <input type="submit" name="insert_name" value="Insert" />
    <td colspan="3">
				$name			=	$_POST["name"]
				$storing_date	=	date("Y-m-d");
				$storing_time	=	date('h:i:s A');
				$sql_insert_name	=	"insert into name_store(name,store_date,store_time)values('$name','$storing_date','$storing_time')";
  <tr bgcolor="#999999">
    <td align="center"><strong>Name</strong></td>
    <td width="87"><strong>Time</strong></td>
    <td width="100"><strong>Date</strong></td>
  	 $sql_get_data		=	"select * from name_store"; // What should i writer in where clause?
	 $result_get_data	=	mysql_query($sql_get_data);
	 while($rs_get_data	=	mysql_fetch_array($result_get_data))
	 	$name_get		=	$rs_get_data["name"];
		$date_get		=	rs_get_data["store_date"];
		$time_get		=	$rs_get_data["store_time"];
  <tr bgcolor="#CCCCCC">
    <td align="center"><?php echo $name_get; ?></td>
    <td align="center"><?php echo $date_get; ?></td>
    <td align="center"><?php echo $time_get; ?></td>

I hope i describeS it completely and in lite wordings


This article has been dead for over six months. Start a new discussion instead.