Using PHP in a MySQL statement?

MtPHP2

Is it possible to use PHP in a MySQL statement?
For example, could I do
...AND $row['signedup'] == "$allowedtime >= $time"
If not, how would I go about this?

volleytotal_ch

can't figure up what you want to do. can you post the whole query and describe what you want to do exactly?

shelby

Hello,

If I understand what you're asking, you want to dynamically create an SQL query, right?

If so, simply create a string to hold the SQL query that you build up, and then pass that string into your SQL function.

...AND $row['signedup'] == "$allowedtime >= $time"

Something along these lines should work:

$query = ".....AND $row['signedup'] == \"$allowedtime >= \"$time"; 
$resultID = mysql_query($query,$connID);

Remember to escape the double quotes you want to include in the text of your query, or use the "." operator to concat different sections of your query together.

Hopefully my response is helpful. 🙂
shelby

MtPHP2

Sorry, I should explain myself better.
Ok imagine I have this...
$time = date("His");
$allowedtime = date("His") + 100;
Then I want to run this query
DELETE FROM users WHERE signedup = '$allowedtime >= $time'
How would I do that?

volleytotal_ch

doesn't work because mySQL can't compare!
you have to write something like

...AND signedup <= '".$the_time."'

this will be true, if the value of the field 'signedup' is lower or equal to the TIME you put in the variable $the_time.

Make sure, that $the_time has the same format as the field declaration of 'signedup'. If you use 'time' as field format, it would be something like "hh:mm:ss"

Hope that helps

MtPHP2

Ok, so how would I do this

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

if current time is 60+ minutes past the time in 'signedup' delete record ELSE don't delete it...

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

Thanks In Advance

volleytotal_ch

Just in case the format of the SQL field for signedup is 'HH:MM:SS', you can use the following code:

$the_time = time()-3600;
// this result in $the_time to be a UNIX-timestamp from 60 minutes = 3600 seconds before the actual time.
// See function time() for more information about that!
$the_time = date("H:i:s",$the_time);
// Converts the $the_time in mySQL friendly format.

...AND signedup <= '".$the_time."'
// This will be true if the value of field 'signedup' is 60 minutes in the past from the current time!

or even shorter:

...AND signedup <= '".date("H:i:s",time()-3600)."'

hope that helps!

altexis

you are actually looking for a proper SQL statement ... not PHP
In PHP you could read all record of that table and compare times in php code, then keep a string with all the IDs of the records that must be deleted and finally run a query like:
DELETE FROM mytable WHERE ID IN (33,45,63,92)

where these 33,45,63,92 numbers would be the ID numbers of the records to be deleted.

Its preferable to search in www.mysql.com for a more SQL oriented solution on this.
I am afraid I am not that good in SQL to give you a straight answer ... maybe in the Databases forum someone more specialised could help you more

MtPHP2

Thanks all! Volley I am going with your suggestion of

AND signedup <= '".date("His",time()-3600)."'

So thankyou!