Numbers From a MySQL database

SP8600

Hi could some one please tell me if its possable to create a script that will detect if there is only numbers in a feild brought back from a database and if there is then display an image called spacer.gif but if there is text in the feild then do the other action which i have done.

What would the code be for this.

Thanks for any help.

getDizzle

Function: [man]is_int[/man] and [man]is_double[/man]

Code Example:

<?

$x = 9.44;

if ( is_int($x) || is_double($x) ) {
        echo "$x is a number";
} else {   

        echo "$x is not a number";
}

?>

You did not mention if you're looking for doubles or integers or both so I provided code for both.

EDIT: You also might want to check out [man]is_numeric[/man]. There's a whole slew of "is_" functions that should help.

SP8600

there is a t-string error in that code, it seams to be the echo tag, how can it be stoped.

SP8600

any ideas why i get this error

SP8600

ok i got a better idea, is there i way that i can display the spacer.gif if the word in the mysql databse is returned as SPACER. Please some one help me out with this, as i need to git done.

Thanks