mysql help

[swampy]

Currently I use the following code to show whether or not a record has an attached website.

if ($row["website"]);
{
blah blah blah...
}

Problem is that it doesn't work. How would I find out whether or not $row["website"] is a string or not?

Thanks again..

[Anon]

There's a function in PHP called mysql_field_type. It returns a string type variable with int, blob, char, etc..the complete syntax is:

string mysql_field_type(int result, int field_offset);

So, you could use:

$result = mysql_query("select * from table where record='myrecord'");
mysql_field_type($result,2);
//where 2 is the offset of your field in the row 'result'

Hope this helps!

[swampy]

thanks for the help, i'll have a go

[alastair]

I use this all the time and it works - you may have a default value in the 'website' field instead of an empty string.