what you do when you find error in IN query in mysql
Error
Select * from Tablename where Ciy IN()
when no id found in IN()
Pass Query Like that
Select * from Tablename where Ciy IN(‘Empty’)
Error
Select * from Tablename where Ciy IN()
when no id found in IN()
Pass Query Like that
Select * from Tablename where Ciy IN(‘Empty’)
<?php $resource = Mage::getSingleton(‘core/resource’); $readConnection = $resource->getConnection(‘core_read’); $query = ‘SELECT * FROM files where prod_id=’.$file_id; $results = $readConnection->fetchAll($query); if(!empty($results)){ echo “Download Files”; foreach($results as $resultsfile){ ?> <br/><a href=”http://www.infinityinfosystem.com/download.php?filename=<?php echo $resultsfile[‘prod_file’];?>”><?php echo $resultsfile[‘file_title’];?></a> <?php }}?>
function checkLogin() { var form_name = new Array(‘txtUserName’,’txtPassword’); var display_name = new Array(‘User Name’,’Password’); var count = 2; if(check_login(‘frmLogin’,form_name,display_name,count)) { } else { return false; } } function check_login(form_name,f_name,d_name,c_array) { var incre=0; for (incre=0; incre
<?php $vidID=”qCwAitjixMo”; //http://www.youtube.com/watch?v=voNEBqRZmBc $url = “http://gdata.youtube.com/feeds/api/videos/”. $vidID; $doc = new DOMDocument; $doc->load($url); $title = $doc->getElementsByTagName(“title”)->item(0)->nodeValue; $duration = $doc->getElementsByTagName(‘duration’)->item(0)->getAttribute(‘seconds’); print “TITLE: “.$title.”<br />”; print “Duration: “.$duration .”<br />”; ?>
<?php error_reporting(E_ALL); if(isset ($_POST[“send”])) { $upload_name=$_FILES[“upload”][“name”]; $upload_type=$_FILES[“upload”][“type”]; $upload_size=$_FILES[“upload”][“size”]; $upload_temp=$_FILES[“upload”][“tmp_name”]; $message=$_POST[“msg”]; $body=”; $subject = $_POST[“subject”]; $to=$_POST[“to”]; $separator = md5(time()); $eol = PHP_EOL; $from=’admin@spoolster.com’; $filename =’bankcopy.jpg’; if($message==””||$subject==””||$to==””) { echo ‘<font style=”font-family:Verdana, Arial; font-size:11px; color:#F3363F; font-weight:bold”>Please fill all fields</font>’; } else { $fp = fopen($upload_temp, “rb”); $file = fread($fp, $upload_size); $attachment = chunk_split(base64_encode($file)); $num = md5(time()); // main…