yes you can switch the type of var for examle with:

$number = (integer)$textvar;

But if you do store it as a textfield you want be able to do some special
sql stuff directly in mysql.

For example if you store the date as text in the db you want be able to
filter out entries which are between x and y.

Good luck,


Global Travellers Network!

"Matthew Nock" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> I am about to build a database of products that will store features fore
> product in a separate table.
> I need to be able to store both text and numeric values in this table, but
> be able to perform mathmatical functions on the numeric variables.
> is it possible to have PHP covert numbers that are stored as text strings
> back into values it can calculate with?

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to