Member Avatar for Kystadio

Right now, I have a PHP script which - ideally - selects "posts" from a table, based whether or not the the time in the post is greater than the current time.

if(isset($_POST['id'])) {
	$id=addslashes($_POST['id']);
	$time=date("h:i:s");
	$sql=mysql_query("SELECT * FROM public_wis WHERE mig_id='$id' AND time >= '$time'");
	if(mysql_num_rows($sql)!=0) {
		while($rows=mysql_fetch_array($sql)) {
			extract($rows);
			echo "<div class=entry><div class=hx><a href=\"/users/$author\">$author</a></div><div class=b>$b</div></div>";
		}
	}
	else {
		return false;
	}
}

Yet, every time it is requested, it merely returns "false" or nothing.

Any thoughts? :O

Edited by Kystadio because: n/a
  • 2 Contributors
  • 1 Reply
  • 96 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

How can there be a post in your table equal to or later then the current time ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.