help with if statement

[MDanz]

every record in the table has a timestamp

 

$time= $row['posted'];

 

how do i say in php

 

if $time less than 30 seconds compared to present time where username=$username?

 

[MartinGr]

I don't know what you exactly mean by username=$username, but

 

if ( ($time > (time()-30)) && ($username == 'sth') ) {}

 

The code gets executed, if the value of $time is less than 30 seconds compared to present time and username equals the one you want.

[MDanz]

its not working.. it just echos "success!" even when i just posted a second ago.  The only time i should see "success" is after 50 seconds.. Where did i go wrong?

 

$username = $_SESSION['username'];
  mysql_connect("localhost", "Master", "password");
mysql_select_db("dbk");
$result = mysql_fetch_assoc(mysql_query("SELECT * FROM Stacks"))or die (mysql_error());
$user = $result['username'];
$time = $result['posted'];

if ( ($time > (time()-50)) && ($username == $user) )

    {
  echo "<font color=white>You must wait 30 seconds between submits</font>";
}

else {
echo "Success!";
}

[KevinM1]

Think it out:

 

If there's less than 50 seconds difference between the current time and the time in the db, deny access -

 

if ((time() - $time < 50))
{
   //posted too soon
}

 

Make sure that $time is a Unix timestamp.

[grissom]

Add this debugging line to your code just before your IF statement

 

echo "The value of my variable $time is : ".$time." The value of time() is : ".time()." The difference between the two is : ".$time-time();

 

Let me know what you get.

[PFMaBiSmAd]

It's also probably not working because you are querying the database for everything in it, then just using whatever values are in the first row retrieved.

[MDanz]

Add this debugging line to your code just before your IF statement

 

echo "The value of my variable $time is : ".$time." The value of time() is : ".time()." The difference between the two is : ".$time-time();

 

Let me know what you get.

 

i tried that and i get this -1253024435 it doesn't even say the words  just -1253024435

 

 

still not working.. 

<?php
session_start();
include("connect.php");
$username = $_SESSION['username'];
  mysql_connect("localhost", "ustackc1_Master", "KOWstHbK");
mysql_select_db("ustackc1_Ustack");
$result = mysql_fetch_assoc(mysql_query("SELECT * FROM Stacks WHERE username='$username'"))or die (mysql_error());
$user = $result['username'];
$time = $result['posted'];




if ((time() - $time < 50))

    {
  echo "<font color=white>You must wait 30 seconds between submits</font>";
}

else

{
echo "success";
}

[PFMaBiSmAd]

Here is a troubleshooting hint: when a comparison fails, echo out the value(s) being used in the comparison so that you know exactly what it is.

 

Are you even sure that there is a row in Stacks for the username? Your code is not checking if the query worked or failed and that there is a row in the result set.

 

What do you get when you add the following two lines of code immediately after your first opening <?php tag -

 

ini_set("display_errors", "1");
error_reporting(E_ALL);

[MDanz]

still get the same page

 

the query is working, there is a row in Stacks for that username..  each row has a timestamp

 

when i do this

 

echo "The value of my variable $time is : ".$time." The value of time() is : ".time()." The difference between the two is : ".$time-time();

 

it displays

"-1253026593"

 

it doesn't even show the text in the echo just "-1253026593"

 

when i echo $time i get this  2009-08-31 23:41:52

 

 

they are in two different formats?