result count

[tik]

$sql = "select from table1
select from table2
select * from table3";

$result = mssql_query($sql, $link)

using the above code, how can I tell how many tables are in $result? Obvisouly I have 3, but how can I tell in code? I tried count($result); but that didn't work.

Thanks

tk

[roscor]

You can use the one SELECT statement then just and between table's. Then use

[code=php]$result = mysql_query($sql) or die(mysql_error());[/code]

[bpat1434]

I know of no way to use mySQL to tell how many tables you are querying. You'll have to do it the old fashioned way: manually count.

Otherwise, you can probably come up with a regular expression to search for all instances of "FROM" "JOIN" instances. Then, do an array_unique on the resulting array and count the array. That should give you a good estimate of how many tables are being queried.