mysql_query() not working
| From: | Vinayak Korape | Date: | Thu, 04 Mar 2010 13:47:23 +0000 |
| Subject: | mysql_query() not working | ||
| Groups: | php.webmaster | ||
| Request: | Send a blank email to php-webmaster+get-7457@lists.php.net to get a copy of this message | ||
Hello Sir,
My code is as following.
* $query0 = "START TRANSACTION";
mysql_query($query0) or die(mysql_error());
*
* $query1 = "SELECT * FROM CallingData WHERE FileId = '$fileid' AND
CalledDataId = '0' AND RecordStatus = 'Not
Reading' AND AgentId = '0' AND RecordId >= '$startid' AND RecordId <=
'$endid' LIMIT 0, 1";*
* $result1 = mysql_query($query1) or die(mysql_error());
echo $query1;
echo "<br>";
echo $result1;
$count1 = mysql_num_rows($result1);
echo "<br>";
echo $count1;
*
When i run the result of echo $query1 in phpmyadmin it returns me one
recordset, but the result of echo $count1 is 0(Zero).
May be the query1 is not getting executed. What are the possible reasons for
that and how can i fix this problem. Please help me.
thanks in advance.