Using a string in SELECT query = Warning

Anon

I'm exhausted.

I've been trying to do something that should be simple--using a string in a QUERY, but I keep getting this warning error messages. It's really driving me nuts.

I have a sports schedule database. I want to display all the games that are upcoming say next week. I set a string $nextweek to equal today + 7 days (basically). Then I tell run my search against the date field in the schedule against the $nextweek string.

It works, I get the results I want, but I also get this warning:

Warning: Unexpected character in input: ' in /home/sites/home/web/testing7.php on line 11

Here is the releveant code:

$nextweek = date("Y-m-d", mktime(0,0,0, date(m), date(d)+7,date(Y)));

$query = "SELECT * FROM sport WHERE event = 'EPL' and yymmdd < '$nextweek' ORDER BY yymmdd

Anon

"; (on the prior line)

I've tried single marks ' and double marks " and escaped marks \" and escaped singles \' and ()'s and {}'s. I've also tried switching the string $nextweek to just a number (2001-08-25) which worked fine.

It seems anytime I have a $ in my SELECT I get an error. (I tried switching sport to $xqz=sport; select $xyz) and I got the same warning message.

Is it a server problem I have? I don't want to turn off warning levels, unless this is just some bug that will never fix itself.

frog_

Could there be a ' within your $nextweek variable?

Anon

I'm really at a loss to say. I don't think it was a ' in the value $nextweek as much as it was having a $ character in the line where I did.

For example, I took out the string $nextweek and replaced it with a set date 2001-09-01. I then changed another variable in the line, I think it was the table, to some random $string and kablamo, same problem.

However, I did find a workaround. I took all the variable out of the SELECT and put them into a string called $searchterms. I then said $Query = $searchterms and it works fine now. Now I have to write the results to a file (which I think is kind of easy) but we'll see.

Anon

if you are really pushed to find the reason why. just add an @ to the front of the mysql statment and an @ to the font of the variable.

eg: $query = @("SELECT @$my_var...

this will supress errors. Its not a good solution, so I'd not the problem and come back when you've cleared your mind.

Dave f