Hi
    I am using PHP with ODBC to connect to Database, I want to print a "No record Found" Message if there is no records found after connecting to the database and opening the recordset. How do I do it??

Praveen.;)

Hi,

Use the odbc_num_rows() function..

$result = odbc_exec($connection, $query);
$row_count = odbc_num_rows($result);

if ($row_count == 0)
{
    echo "No records found.";
}

See:
http://www.php.net/odbc_num_rows

ODBC functions:
http://www.php.net/odbc

hth,
: )
Rich

::::::::::::::::::::::::::::::::::::::::::
The Spicy Peanut Project
http://www.spicypeanut.net
::::::::::::::::::::::::::::::::::::::::::

Hi

     I am getting '-1' as a result of using odbc_num_rows ,I am using PHP with MS access over DSN connection through ODBC.How do I get the number of records?

Thanks
Praveen.

Hi

     I figured out another way to solve a problem using a counter and
odbc_fetch_row.


while (odbc_fetch_row($result_count))
{
   $count++;
}

echo "Title";

if ($count)
{
   echo "Total: <b>$count</b>.";
}
else
{
   echo "No Records Found.";
}

Thank You

Praveen