Need help with SQL Queries
I snagged some code from the admin.sma trying to make a Temporary Admins plugin for my personal server. Everything is working except for the deletion code. I can make an admin and insert startdate and days into the table, no problem, but this code isn't deleting properly, no matter what I do.
startdate is a unix timestamp stored as an int in the database. Code:
public check_date() |
Re: Need help with SQL Queries
Few questions when are you calling check_date, are you connected to the database, do you have enough privileges to delete from the tables
Also do some debugging to know where the code is failing Would be helpful if you provided some error logs |
Re: Need help with SQL Queries
StartDate & Days are integers so you should use the following format:
PHP Code:
PHP Code:
PHP Code:
|
Re: Need help with SQL Queries
Quote:
What is the syntax if I wanted to check that days is not equal to 0? I'm using 0 as permanent rather than a whole lotta 9s. Edit: that was a simple google :P PHP Code:
|
| All times are GMT -4. The time now is 17:19. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.