Code: Select all
SELECT * FROM merchant WHERE user_name = '{$_SESSION['logname']}' AND create_date<=DATE_SUB(CURDATE(), INTERVAL 30 DAY)
Moderator: General Moderators
Code: Select all
SELECT * FROM merchant WHERE user_name = '{$_SESSION['logname']}' AND create_date<=DATE_SUB(CURDATE(), INTERVAL 30 DAY)
Code: Select all
> mysql -uMyUsername -pMyPassword
mysql> SELECT * FROM merchant WHERE user_name = '{$_SESSION['logname']}' AND create_date<=DATE_SUB(CURDATE(), INTERVAL 30 DAY);
+---------------+
| some stuff |
+---------------+
x rows in result set. 0.43 secs
mysql> exit
Goodbye.
>Code: Select all
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'logname']}' AND create_date<=DATE_SUB(CURDATE(), INTERVAL 30 DAY)' at line 1Code: Select all
mysql> SELECT * FROM merchant WHERE user_name = 'JGilchrist1510' AND create_date
<=DATE_SUB(CURDATE(), INTERVAL 30 DAY);
+--------------+--------------+---------------+---------------------------------
----+---------------+-------------+------+--------+----------+----------------+-
-----------------+--------------+----------------------+---------------+--------
----+-------------+----------------+------------------+-------------------------
-----------------+-------------+
| phone_num | merchant_num | date_recieved | merchant_name
| purchase_type | lease_score | amex | app_id | discover | user_name |
check_conversion | gift_loyalty | app_type | terminal | serial_
num | nms | ckmerchant_num | giftmerchant_num | comments
| create_date |
+--------------+--------------+---------------+---------------------------------
----+---------------+-------------+------+--------+----------+----------------+-
-----------------+--------------+----------------------+---------------+--------
----+-------------+----------------+------------------+-------------------------
-----------------+-------------+
| 231-843-2058 | 286604381272 | 12/12/2006 | HAMLIN GROCERY
| Lease | B/C | Yes | NULL | Yes | JGilchrist1510 |
Yes | Yes | Retail with Debit | val pak 700 | NULL
| NULL | 641-630015-609 | 00012411 | MERCHANT COMPLETE
| 2006-12-15 |
| 231-873-4986 | 286604319502 | 12/05/2006 | WALKERS FINE DINING
| Lease | D/E | No | NULL | No | JGilchrist1510 |
Yes | Yes | Restaurant with Tips | VALUEPACK 700 | 2392743
| 800-440-770 | 641-629310-633 | 00012302 | NULL
| 2006-12-08 |
| 231-845-8777 | 286604368598 | 12/06/2006 | CREATIVE CUTS DAY SPA & TANNING
LLC | Lease | A | Yes | NULL | Yes | JGilchrist1510 |
Yes | Yes | Restaurant with Tips | VALUEPACK 700 | 2394754
| 800-440-770 | 641-629355-637 | 00012304 | NULL
| 2006-12-08 |
| 231-873-1820 | NULL | 12/7/2006 | COUNTRY BOY PRODUCTS INC
| Lease | N/A | No | NULL | No | JGilchrist1510 |
No | No | Retail | NULL | NULL
| NULL | NULL | NULL | PENDED OTHER LOCATION IS
NOT PROCESSING. | 2006-12-15 |
| 231-893-6688 | 28660000 | 12/20/2006 | JOHNSONS GREAT OUTDOORS
| Lease | N/A | No | NULL | Yes | JGilchrist1510 |
Yes | Yes | Retail with Debit | VALUEPACK 700 | NULL
| NULL | NULL | NULL | NULL
| 2006-12-26 |
| 231-861-7552 | 286604345869 | 12/21/2006 | SHIRT CITY USA
| Lease | B/C | No | NULL | No | JGilchrist1510 |
Yes | No | Retail | VALUEPACK 700 | NULL
| NULL | 641-630506-642 | NULL | NULL
| 2006-12-26 |
| 231-843-6756 | 286604337895 | 12/14/2006 | ALL SEASONS MOBILE MARINE
| Lease | D/E | No | NULL | Yes | JGilchrist1510 |
Yes | Yes | Retail | VALUEPACK 700 | 2407970
| 800-440-770 | 641-360106-608 | 00012468 | NULL
| 2006-12-26 |
| 231-894-8995 | 286604352844 | 12/28/2006 | jimmy's pub
| Lease | A+ | Yes | NULL | Yes | JGilchrist1510 |
Yes | Yes | Restaurant with Tips | valpak 700 | 2427710
| 800-440-770 | NULL | NULL | restaurant w tips and de
bit | 2006-12-28 |
+--------------+--------------+---------------+---------------------------------
----+---------------+-------------+------+--------+----------+----------------+-
-----------------+--------------+----------------------+---------------+--------
----+-------------+----------------+------------------+-------------------------
-----------------+-------------+
8 rows in set (0.00 sec)