& in variable

[Jules00]

Hey 🙂

$query = "select * from training where class_name='SLC 500 Basics' and class_date='".$date."'";

The above returns nothing from my database but...

$query = "select * from training where class_name='SLC 500 Basics' and class_date='January 1, 2001';

Returns the appropriate info.

The dates have & signs in them, and when I set the $date vaiable, i think something happens to the & so the database cant recognize it.

Does anyone know how to solve this problem?

Thanks 🙂

[jpmoriarty]

why do the dates have ampersands in them?

[Jules00]

the dates are for classes which span multiple days.
ex. January 1 & 2, 2004

Anyone know what to do?

[Jules00]

anyone?