[RESOLVED] Check query for errors vs a reuslt

[gwerner]

Ok. I thought I had this straight.

I thought that the following checked to see if the query contains any errors. Not if it returns any results. This just basically need to see if an item already exists in the cart. I need it to just continue along regardless if there is a match. What I have returns FALSE when there isn't a match.

What I thought I knew is that if(!mysql_query) checks if there is an error in the query (bad code, wrong variable, etc.). And, if(!result) or mysql_num_rows will check if there are actually any results or data.

$cartSelect = "SELECT cart_quantity
			   FROM cart
			   WHERE cart_productid = '$id' AND cart_session = '$cart'";
if(!mysql_query($cartSelect)) {
	return FALSE;
}

Go easy on me guys.

[bradgrafelman]

As the manual states, [man]mysql_query/man will return boolean FALSE if there is an error executing the query. Thus, I would expect that your code should work as expected since an empty result set is perfectly fine.

Instead of returning false, try outputting [man]mysql_error/man as well as the query string itself.

[gwerner]

That's what I thought and exactly what I read before posting. However, the obvious thing to do eluded me again. Print out the dang error!

It was a matter of this page wasn't even making a connection to the database because I didn't require my config file on this page. This file is set up a little different than others I've been working on and I didn't notice it missing.

Oh, and thanks!