Problem retrieving data

[Lassie]

I have a simple query and need to print the result.

My code does not print a resulr but the query is valid and returns a result.

Any help appreciated.

$query = ("SELECT * FROM wp_book WHERE Author_ID = '$Author_ID'");

            $result = mysql_query($query) or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error());
            echo mysql_error();
            if (!$result) {
                echo "<br />";
                echo"No Result";
            }
            echo"Result";
            

            while($row = mysql_fetch_assoc($result)){
            
            echo $row['WorkingTitle'];

            }

[Pikachu2000]

How are you sure the query isn't returning an empty results set?

[Lassie]

Hi Thanks,

Well I put the !$result in to check just that and the db does hol data for this query. ?

[Pikachu2000]

That will determine if the query fails with an error. An empty result set is not a query failure, it's simply an empty results set. To determine if the query returns any results, you'd need to use mysql_num_rows.

[shankarganesh]

Hi,

 

Please try it with this updated query,

 

$query = ("SELECT * FROM wp_book WHERE Author_ID = '".$Author_ID.'"");

 

Thanks.

[dzelenika]

and of course remove parenthesis from code:

 

$query = ("SELECT * FROM wp_book WHERE Author_ID = '".$Author_ID.'"");