Error checking

[gregarion]

Hey guys i am facing a problem in my sql statement. I am trying to check if there is such a value in the database.

Code:

  string NewMovie = "ww";

  string queryText ;

queryText = "Select * from movie_info WHERE movie_title = '"+ NewTitle +"'";
MYSQL *conn;

  conn=mysql\_init(NULL);

 mysql\_real\_connect(conn,host,username,password,database,0,NULL,0);

mysql_query(conn,queryText.c_str());

   ????

  mysql\_close(conn);

   

  return 0;

The problem i am facing is how do i check if the value is found. I read up and found that a query will return a value of TRUE if the query is a success and a FAIL if there is an error. How do i call these values and then based the check on it?

[CPallini]

I guess you'll get 0 (i.e. success) either if the record is found and if it is NOT found, because, technically, the query succeeded. Why don't you query instead for the record count (using the COUNT SQL function)? :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]

[gregarion]

Yeap i tried smting like this...

string NewTitle = "ww";
      string queryText ;

queryText ="Select COUNT(*) from movie_info WHERE movie_title = '"+ NewTitle +"'";

if (mysql_query(conn,queryText.c_str()) )

{

}

but im not too sure how to get the values out? like if it reads 1 table? how can i call it out?

[CPallini]

The query is OK. Now you've to fetch the data (actually the single value). An example here [^] (check out the "Retrieving data from the database" section). :)

If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]