mysql_fetch_assoc warning

[php_begins]

I have the following code

			$hidden_client_id_query = mysql_query("SELECT id from `pdp_client_info` WHERE lead_id='$post_lead_id'");
		$hidden_client_id=mysql_fetch_assoc($hidden_client_id_query);
		$this->view->hidden_client_id=$hidden_client_id['id'];

I get the following error for the above code. I wonder where I am wrong. I am getting the $post_lead_id as expected.

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean

[scootstah]

Because the query failed due to an error. After mysql_query, run

echo mysql_error();

[AyKay47]

also, i like to keep the sql and query call in separate variables, that way if an error occurs in the query, I can output both the SQL and the mysql_error() call.

[php_begins]

My bad..That was a database access problem in the ZEND framework. I had to modify my code according to the settings in my framework.

			$hidden_client_id_query = $this->db->query("SELECT id FROM pdp_client_info WHERE lead_id='$post_lead_id'");
		$hidden_client_id=$hidden_client_id_query->fetch();
		$this->view->hidden_client_id=$hidden_client_id['id'];

[scootstah]

So is it fixed?

[php_begins]

oh yes..The code that I reposted works for me.

[scootstah]

In the future, the little "topic solved" button helps us know the problem is resolved.