Raised This Month: $ Target: $400
 0% 

Problem with MySQL


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
ng1200
Member
Join Date: May 2005
Old 12-11-2007 , 07:03   Problem with MySQL
Reply With Quote #1

Hi,
How would I check if there were no rows returned by the query?
If I use the following:
Code:
if (dbi_num_rows(result_var) > 0)

I get this error:
Code:
Invalid DBI result handle 0
And If I use this:
Code:
if (dbi_query(db_var, query_var) == 0)

I get a tag mismatch warning.



Thanks in advance.
ng1200 is offline
Zenith77
Veteran Member
Join Date: Aug 2005
Old 12-11-2007 , 08:11   Re: Problem with MySQL
Reply With Quote #2

Might want to post all your code. I also recommend using SQLX, as it's the most up to date version of the SQL/Database libraries (unless of course you have reason to specifically use DBI).
__________________
Quote:
Originally Posted by phorelyph View Post
your retatred
Zenith77 is offline
ng1200
Member
Join Date: May 2005
Old 12-12-2007 , 03:43   Re: Problem with MySQL
Reply With Quote #3

Alright, Thanks.
Is there any documentation on using SQLX?
ng1200 is offline
purple_pixie
Veteran Member
Join Date: Jun 2007
Location: Winchester, England
Old 12-12-2007 , 05:55   Re: Problem with MySQL
Reply With Quote #4

The documentation I used was called "Searching for plugins that use it and read their source"
purple_pixie is offline
alien
Senior Member
Join Date: Aug 2005
Location: London || Slovakia
Old 12-12-2007 , 11:37   Re: Problem with MySQL
Reply With Quote #5

SQLx tutorial
__________________
alien is offline
Send a message via ICQ to alien
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:02.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode