[Resolved] PHP variables in a mysql query

[jonki]

Hi, I am trying to do a mysql query but with a php variable in it.

Basically I am trying to make sure that no one puts more entries in the db than he/she is allowed. To do this I am checking the telephone numbers and counting the entries. This works fine when I put in a particular number but I can't get it to work for a variable.

$telephone = 647777111

$query = "SELECT *, count(*) as 'number' FROM `db` WHERE telephone = 647777111 group by name";
$result = mysql_query($query); 
$data = mysql_fetch_array($result); 

$number = $data['number'];

If I change the 647777111 above for $telephone - it doesn't work.

Not suprising - no. But I have no idea of how to do this.

Thanks a lot.

[furious5]

Instead of this:

$query = "SELECT , count() as 'number' FROM db WHERE telephone = 647777111 group by name";

Try:

$query = "SELECT , count() as 'number' FROM db WHERE telephone = '"& strTelephone &"' group by name";

[jonki]

Why is it that when ever you go to the dentist your toothache stops and when ever you post on phpbuilder your php seems to work.

I swear it didn't work 5 minutes ago but now it seems to work fine.

Thanks anyway guys.

[furious5]

I wouldn't use ampersands either, as I've just suggested I'd do this instead:
'".$Telephone."'

Thats what you get for coding in ASP all day!

[jonki]

Thanks for your help but a simple where telephone = $telephone seems to do the trick.

You guys are great - you manage to reply faster than my screen refresh ...... but that's what you get for living in a third world country I suppose ...

cheers