problem with odbc_fetch row

manjeman

Hello all,

I have problem here with odbc_fetch_row, I'm already try all the suggested answer posted by other members..but I still can't get what I want.

Here is my code

$query = "SELECT * FROM ticket ORDER BY t_id";

$result = odbc_exec($odbc_link,$query);

How I can use odbc_fetch_row to get the empty result or no matches found in my ticket table??

Any suggestion are really..really..really..appreciated..🙂

Anon

Meaning what exactly? This query will return all of the rows in the table. For specifiying a criteria, you have to put it into your SQL query, like:

SELECT * FROM ticket WHERE customer NOT IN(3,4,5) ORDER BY t_id

That would return any row where customer (assuming there is a field with that name) is not 3,4, or 5

As for odbc_fetch_row, i suppose it will work OK as long as the SQL is well-built.

I hope this is your question. Post ALL of the code for more answers (especially that with the odbc_fetch_row() function)

Hope this helps

fLIPIS

nostradamus

You have to make sure that there are any datasets in your table, or you will get an error message. So try the following :

$query1 = "select count() as count from ticket";
$result1 = odbc_exec($odbc_link, $query1);
odbc_fetch_row($result1);
if odbc_result(0) <> 0
{
$query = "select from ticket order by t_id";
$result = odbc_exec($odbc_link, $query);
.
.
.
}
else
{
THE ACTION YOU WOULD LIKE TO HAVE WHEN YOUR TABLE "TICKET" IS EMPTY
.
.
.
}

manjeman

actually, i am using that select statement for search matching. user will key in the keyword and it will search thru ticket table. if matches found, it will display all information about the ticket. if not, error message will display.