Programming

Code:

mysql -h $dbserver --pager=/usr/bin/less --user=$username --password=$password -e 'SELECT * FROM callings WHERE timestamp_date >= NOW() - INTERVAL 1 DAY  AND timestamp >= NOW() - INTERVAL 30 MINUTE AND extension = "$blahtest" AND to_number = "$phonenumber"' $DBNAME

Can someone help me fix the above so that I can pass variables to it?

I'm running the above from the command line and i'm passing variables to it. but mysql doesn't seem to like it.

i can tell the issue is with the "-e" and the single quotes that follow. but i need to pass be able to pass variables.

when i run the above command i always get:

Code:

ERROR 1054 (42S22) at line 1: Unknown column 'blahtest' in 'where clause'

even though the blahtest does exist.

Hi.

If you use single quotes after -e, $blahtest won't be evaluated.

Try changing to double quotes and escape the inner double quotes (\") (or replace those with single quotes if MySQL will accept that for syntax).