Variable substitution in DB SELECT stmt

[Anon]

I've been doing PHP for all of a few days and was wondering how to substitute a numeric value in a database statement. With string values it is straightforward, eg.

$Comment="hallo world";

$Query = "SELECT * FROM mytable WHERE comment = '$Comment'";

The above code will work fine, however what if I am substituting a number instead, eg.

$num = 1;

$Query = "SELECT * FROM mytable WHERE number = $num";

The above code doesn't work. Using the same syntax as before ie. '$num' doesn't work either. It shouldn't anyway because the field I am refering to isn't a string.

Thanks in advance for any help.

Pete...

[Anon]

try HAVING instead of WHERE

not sure i thought that last statement should have worked

Al

[Anon]

Thanks. Your reply made me rethink and I realise that I asked the wrong question. The code in my example is correct. What I actually need to do is convert a string to a number!!!

I was getting confused cos' the sql stmt wasn't working.

The HAVING clause is only used with GROUP BY to limit the results.