I have a variable $BrokerID that i'm trying to place into the query for Mysql. I think the synax is wrong it will not work. YET when I replace = $BrokerID with = \'50786\' it works fine. I think my synax is wrong. I'm new to php and mysql help would be highly appreciated.
Thanks in advance!!
$BrokerID = 50786;
$query = "SELECT * FROM
Sold Office ID = $BrokerID LIMIT 0, 1 ";