View Single Post
  #9 (permalink)  
Old 08-21-08, 10:12 AM
snakeob snakeob is offline
Newbie Coder
 
Join Date: Jun 2008
Posts: 42
Thanks: 0
Thanked 0 Times in 0 Posts
i added
PHP Code:

$query mysql_query("SELECT * FROM biller WHERE account LIKE ($_POST[number]) AND calldate LIKE '%($_POST[month])%' AND calldate LIKE '%($_POST[year])%'"); 

and i get stuff in my table now!
my only problem is that now my logic is ignoring my two calldate querys

basicly you have a selection of account, month, and year
my account seems to be working fine.

im using the $_POST[month] as a way of selecting the month and year for year from a different database so that i dont get any jiberish from the mysql data, and trying to search using what you have selected from previous.

mysql> SELECT * FROM biller WHERE account LIKE 8669605227 AND calldate LIKE '%Feb%';

if i type this into mysql it works fine, i just cant seem to get these $_POST to work
Reply With Quote