lovephp

ok i got it wroking on wamp server but now that i try it on my webhost one a subfolder as /blog i am getting 404 page not found error :-( here is the rewrite rule in .htaccess file RewriteEngine On RewriteRule ^blog/([a-zA-Z0-9-/]+)$ article.php?$1 RewriteRule ^blog/([a-zA-Z0-9-/]+)$ article.php?$1 in my root folder i also have another .htaccess file which is as follow RewriteEngine On DirectoryIndex index.php ErrorDocument 404 http://www.site.com ErrorDocument 403 http://www.site.com RewriteCond %{HTTP_HOST} ^site\.com$ [NC] RewriteRule ^(.*)$ http://www.site.com/$1 [R=301,L] <IfModule mod_deflate.c> <FilesMatch "\.(css|x?html?|php)$"> SetOutputFilter DEFLATE </FilesMatch> </IfModule> <IfModule mod_expires.c> ExpiresActive On ExpiresByType text/css A100 ExpiresByType text/html A100 </IfModule> what is wrong here? the url is as following http://www.site.com/blog/ID1/2015/06/22/neque-porro-quisquam-est-qui-dolorem-ipsum-quia-dolor-sit-. and in article.php this is how i am fetching the results <?php session_start(); require_once("dbcontroller.php"); $db_handle = new DBController(); include("log.php"); $url = mysql_real_escape_string($_SERVER['REQUEST_URI']); $url = str_replace('/blog/', '', ucwords($url)); $sql=mysql_query("SELECT id,blog_title,blog_image,blog_youtube,blog_article,created,views FROM article WHERE blog_url='".$url."'"); mysql_query("UPDATE article SET views = views +1 WHERE blog_url ='".$url."'"); $count = mysql_num_rows($sql); $row=mysql_fetch_array($sql); if($count <1){ header("ERROR: 404"); exit(); } ?>

Create a function function Sendemail(){ Query and stuff here } Then include it on ur config file etc

Ok so I created this blog and also managed to successfully store the title of the topic as blog_url now how on earth I fetch it on browser to display as www.mysite.com/TOPICID1/2015/06/20/my-topic-for-the-blog.php Help out from here please in a secure way. Regards

hey all, what am i doing wrong here that on android device when i try to upload a file the session gets lost while browsing through files on the phone. on PC and on latest android devices it seems ok but on some im facing this issue. how could i keep the session active for a month if the user does not logout? my login.php codes are session_start(); function get_client_ip() { $ipaddress = ''; if ($_SERVER['HTTP_CLIENT_IP']) $ipaddress = $_SERVER['HTTP_CLIENT_IP']; else if($_SERVER['HTTP_X_FORWARDED_FOR']) $ipaddress = $_SERVER['HTTP_X_FORWARDED_FOR']; else if($_SERVER['HTTP_X_FORWARDED']) $ipaddress = $_SERVER['HTTP_X_FORWARDED']; else if($_SERVER['HTTP_FORWARDED_FOR']) $ipaddress = $_SERVER['HTTP_FORWARDED_FOR']; else if($_SERVER['HTTP_FORWARDED']) $ipaddress = $_SERVER['HTTP_FORWARDED']; else if($_SERVER['REMOTE_ADDR']) $ipaddress = $_SERVER['REMOTE_ADDR']; else $ipaddress = 'UNKNOWN'; return $ipaddress; } if(isset($_SESSION['LOGGED_IN']) && trim($_SESSION['LOGGED_IN']) == true) { header("Location: index.php"); } if(isset($_POST["submit"])) { $email = mysql_real_escape_string(trim(strip_tags($_POST['email']))); $password = mysql_real_escape_string(trim(strip_tags($_POST['password']))); $rs = mysql_query("select userID from users where user_email='$email'"); $duplicates = mysql_num_rows($rs); $rs1 = mysql_query("select userID,user_email,user_password from users where user_email='$email' AND user_password='".sha1($password)."'"); $maychpass = mysql_num_rows($rs1); $error = ''; if($email == "") { $error = 'E-mail address is required.'; }elseif(!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email)){ $error = 'E-mail address is invalid.'; }elseif ($duplicates < 1){ $error = 'E-mail address not found.'; } elseif($password == "") { $error = 'Password is required.'; }elseif(strlen($password) < 6){ $error = 'Password is too short.<small>(Min 6 Chars)</small>'; }elseif ($maychpass < 1){ $error = 'Wrong password.'; } else{ $qry="select userID,user_full_name,user_email,user_password from users where user_email='$email' AND user_password='".sha1($password)."'"; $result=mysql_query($qry); //Check whether the query was successful or not if($result) { if(mysql_num_rows($result) == 1) { //Login Successful session_regenerate_id(); $user = mysql_fetch_assoc($result); $_SESSION['LOGGED_IN'] = true; $_SESSION['MAT_USER_ID'] = $user['userID']; $_SESSION['MAT_USER_FULL_NAME'] = $user['user_full_name']; $_SESSION['MAT_USER_EMAIL'] = $user['user_email']; $_SESSION['MAT_USER_IP'] = get_client_ip(); setcookie("matLogged", "".$_SESSION['MAT_USER_EMAIL'].""); setcookie("matLogged", "".$_SESSION['MAT_USER_EMAIL']."", time()+43200); $ip = get_client_ip(); session_write_close(); echo("<p align='center'><font color='green' size='5'>Success:</font> Login successful, redirecting to members page.<br/><img src='img/loader.gif' alt='Loader'></p>"); mysql_query("UPDATE users SET ip = '".$ip."' WHERE userID = '".$user['userID']."'"); echo ('<meta http-equiv="refresh" content="5;url=index.php">'); exit(); }else { //Login failed echo("<p align='center'><font color='red' size='5'>Error:</font> Something went wrong, redirecting to login page.<br/><img src='img/loader.gif' alt='Loader'></p>"); echo ('<meta http-equiv="refresh" content="5;url=login.php">'); exit(); } } } } would really appreciate your help and time

thanks alot bro..

got it i added unset($_SESSION['criteria']); this works

got it, actually there was issues with the names of fields in search.php but facing another issue if there isnt any search query the sesseion still displays results from more.php thought i added unset($criteria); if(isset($_POST['page'])): $paged=mysql_real_escape_string($_POST['page']); if(isset($_SESSION['criteria']) && !empty($_SESSION['criteria'])) { //assign to local var if available $criteria = $_SESSION['criteria']; $sql="SELECT * FROM profiles WHERE " . implode(' AND ', $criteria)." ORDER BY UserID DESC"; if($paged>0){ $page_limit=$resultsPerPage*($paged-1); $pagination_sql=" LIMIT $page_limit, $resultsPerPage"; } else{ $pagination_sql=" LIMIT 0 , $resultsPerPage"; } $result=mysql_query($sql.$pagination_sql); $num_rows = mysql_num_rows($result); if($num_rows>0){ while($data=mysql_fetch_array($result)){ $fname=$data['dob']; $lname=$data['Lname']; echo "<table border='0'> <tr> <td width='20%'> <img src='uploads/profiles/1432715714.jpg' class='loadimg'> </td> <td width='80%'> <h3>Balaswami Surraminiam</h3> <b>Age:</b> 60 <br/> <b>Caste:</b> $fname <br/> <b>Height:</b> 4' 5'' <br/> <b>Profession:</b> Chartered Accountant <br/> <b>Location:</b> Badarpur Rly Township <br/> <a href='#'>view profile</a> </td> </tr> </table>"; } } if($num_rows == $resultsPerPage){?> <li class="loadbutton"><button class="loadmore" data-page="<?php echo $paged+1 ;?>">More. </button></li> <?php }else{ echo "<li class='loadbutton'><span class='endload'> No more. </span></li>"; unset($criteria); } } endif; ?>

im trying to set the $criteria to session but when i print only the $criteria[] = "Employment = '".$employment."'"; and $criteria[] = "YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '".$agefrom."' AND '".$ageto."'"; are getting the values of print_r($criteria); Array ( [0] => Employment = 'Employed' [1] => YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '18' AND '25' ) if(isset($_POST['submit'])){ $employment = mysql_real_escape_string($_POST['employment']); $mstatus = mysql_real_escape_string($_POST['mstatus']); $agefrom = mysql_real_escape_string($_POST['agefrom']); $ageto = mysql_real_escape_string($_POST['ageto']); $criteria = array(); if($employment !='') { $criteria[] = "Employment = '".$employment."'"; } if($mstatus !='') { $criteria[] = "Maritalstatus = '".$mstatus."'"; } if($agefrom !='' && $ageto !='') { $criteria[] = "YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '".$agefrom."' AND '".$ageto."'"; } $_SESSION['criteria'] = $criteria; } print_r($criteria);

there is an issue here i did it like this <?php if(isset($_POST['submit'])){ $employment = mysql_real_escape_string($_POST['employment']); $mstatus = mysql_real_escape_string($_POST['mstatus']); $agefrom = mysql_real_escape_string($_POST['agefrom']); $ageto = mysql_real_escape_string($_POST['ageto']); $criteria = array(); if($employment !='') { $criteria[] = "Employment = '".$employment."'"; } if($mstatus !='') { $criteria[] = "Maritalstatus = '".$mstatus."'"; } if($agefrom !='' && $ageto !='') { $criteria[] = "YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '".$agefrom."' AND '".$ageto."'"; } $_SESSION['criteria'] = $criteria; $query=mysql_query("SELECT * FROM profiles WHERE " . implode(' AND ', $criteria)." ORDER BY UserID DESC LIMIT 0 , $resultsPerPage"); while($data=mysql_fetch_array($query)){ $fname=$data['dob']; $lname=$data['Lname']; echo "<table border='0'> <tr> <td width='20%'> <img src='uploads/profiles/16022014045.jpg' class='loadimg'> </td> <td width='80%'> <h3>Balaswami Surraminiam</h3> <b>Age:</b> 60 <br/> <b>Caste:</b> $fname <br/> <b>Height:</b> 4' 5'' <br/> <b>Profession:</b> Chartered Accountant <br/> <b>Location:</b> Badarpur Rly Township <br/><br/> <a href='#'>view profile</a> </td> </tr> </table>"; } } print_r($_SESSION); ?> now when i select employment, mstatus and age anyways by default selected from 18 - 25 the query only outputs employment and age the mstatus does not show. what wrong am i doing here??? also the session outputs like this Array ( [criteria] => Array ( [0] => Employment = 'Government Employed' [1] => YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '18' AND '25' ) )

there is an issue here i did it like this <?php if(isset($_POST['submit'])){ $employment = mysql_real_escape_string($_POST['employment']); $mstatus = mysql_real_escape_string($_POST['mstatus']); $agefrom = mysql_real_escape_string($_POST['agefrom']); $ageto = mysql_real_escape_string($_POST['ageto']); $criteria = array(); if($employment !='') { $criteria[] = "Employment = '".$employment."'"; } if($mstatus !='') { $criteria[] = "Maritalstatus = '".$mstatus."'"; } if($agefrom !='' && $ageto !='') { $criteria[] = "YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '".$agefrom."' AND '".$ageto."'"; } $_SESSION['criteria'] = $criteria; $query=mysql_query("SELECT * FROM profiles WHERE " . implode(' AND ', $criteria)." ORDER BY UserID DESC LIMIT 0 , $resultsPerPage"); while($data=mysql_fetch_array($query)){ $fname=$data['dob']; $lname=$data['Lname']; echo "<table border='0'> <tr> <td width='20%'> <img src='uploads/profiles/16022014045.jpg' class='loadimg'> </td> <td width='80%'> <h3>Balaswami Surraminiam</h3> <b>Age:</b> 60 <br/> <b>Caste:</b> $fname <br/> <b>Height:</b> 4' 5'' <br/> <b>Profession:</b> Chartered Accountant <br/> <b>Location:</b> Badarpur Rly Township <br/><br/> <a href='#'>view profile</a> </td> </tr> </table>"; } } print_r($_SESSION); ?> now when i select employment, mstatus and age anyways by default selected from 18 - 25 the query only outputs employment and age the mstatus does not show. what wrong am i doing here??? also the session outputs like this Array ( [criteria] => Array ( [0] => Employment = 'Government Employed' [1] => YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '18' AND '25' ) )

no hope bro it helped alot i got this done yay thanks a ton..

sorry bout that mate. ok here is my search.php which i include in the php pages <form action="results.php" method="post"> <select id="employment" name="employment" > <option value=" " disabled="disabled" selected="selected">Select Employment</option> <option value="Unemployed">Unemployed</option> <option value="Employed">Employed</option> <option value="Self Employed">Self Employed</option> <option value="Government Employed">Government Employed</option> </select>, <select id="maritalstatus" name="maritalstatus" > <option value=" " disabled="disabled" selected="selected">Select Marital Status</option> <option value="Never Married">Never Married</option> <option value="Married">Married</option> <option value="Awaiting Divorce">Awaiting Divorce</option> <option value="Divorced">Divorced</option> <option value="Widowed">Widowed</option> <option value="Annulled">Annulled</option> </select>, Age: <select name ='agefrom'> <option value='18'>18</option> <option value='19'>19</option> <option value='20'>20</option> <option value='21'>21</option> <option value='22'>22</option> <option value='23'>23</option> <option value='24'>24</option> <option value='25' s>25</option> <option value='26'>26</option> <option value='27'>27</option> <option value='28'>28</option> <option value='29'>29</option> <option value='30'>30</option> </select> to: <select name ='ageto'> <option value='18'>18</option> <option value='19'>19</option> <option value='20'>20</option> <option value='21'>21</option> <option value='22'>22</option> <option value='23'>23</option> <option value='24'>24</option> <option value='25' selected="selected">25</option> <option value='26'>26</option> <option value='27'>27</option> <option value='28'>28</option> <option value='29'>29</option> <option value='30'>30</option> </select>, Height: <select name="Min_Height" id="Min_Height"> <option value="1">4' 0" (1.22 mts)</option> <option value="2">4' 1" (1.24 mts)</option> <option value="3">4' 2" (1.28 mts)</option> <option value="4">4' 3" (1.31 mts)</option> <option value="5">4' 4" (1.34 mts)</option> <option value="6">4' 5" (1.35 mts)</option> <option value="7">4' 6" (1.37 mts)</option> <option value="8">4' 7" (1.40 mts)</option> <option value="9">4' 8" (1.42 mts)</option> <option value="10">4' 9" (1.45 mts)</option> <option value="11">4' 10" (1.47 mts)</option> <option value="12">4' 11" (1.50 mts)</option> <option value="13">5' 0" (1.52 mts)</option> <option value="14">5' 1" (1.55 mts)</option> <option value="15">5' 2" (1.58 mts)</option> <option value="16">5' 3" (1.60 mts)</option> <option value="17">5' 4" (1.63 mts)</option> <option value="18">5' 5" (1.65 mts)</option> <option value="19">5' 6" (1.68 mts)</option> <option value="20">5' 7" (1.70 mts)</option> <option value="21">5' 8" (1.73 mts)</option> <option value="22">5' 9" (1.75 mts)</option> <option value="37">7' (2.13 mts) plus</option> </select> to: <select name="Max_Height" id="Max_Height"> <option value="1">4' 0" (1.22 mts)</option> <option value="2">4' 1" (1.24 mts)</option> <option value="3">4' 2" (1.28 mts)</option> <option value="4">4' 3" (1.31 mts)</option> <option value="5">4' 4" (1.34 mts)</option> <option value="6">4' 5" (1.35 mts)</option> <option value="7">4' 6" (1.37 mts)</option> <option value="8">4' 7" (1.40 mts)</option> <option value="9">4' 8" (1.42 mts)</option> <option value="10">4' 9" (1.45 mts)</option> <option value="11">4' 10" (1.47 mts)</option> <option value="12">4' 11" (1.50 mts)</option> <option value="13">5' 0" (1.52 mts)</option> <option value="14">5' 1" (1.55 mts)</option> <option value="15">5' 2" (1.58 mts)</option> <option value="16">5' 3" (1.60 mts)</option> <option value="17">5' 4" (1.63 mts)</option> <option value="18">5' 5" (1.65 mts)</option> <option value="19">5' 6" (1.68 mts)</option> <option value="20">5' 7" (1.70 mts)</option> <option value="21">5' 8" (1.73 mts)</option> <option value="22">5' 9" (1.75 mts)</option> <option value="37" selected="selected">7' (2.13 mts) plus</option> </select> <input type="submit" name="submit" value="Find" class="submit"> </form> then here comes the results.php which displays results accordingly <?php if(isset($_POST['submit'])){ $employment = mysql_real_escape_string($_POST['employment']); $mstatus = mysql_real_escape_string($_POST['mstatus']); $agefrom = mysql_real_escape_string($_POST['agefrom']); $ageto = mysql_real_escape_string($_POST['ageto']); $criteria = array(); if($employment !='') { $criteria[] = "Employment = '".$employment."'"; } if($mstatus !='') { $criteria[] = "Maritalstatus = '".$mstatus."'"; } if($agefrom !='' && $ageto !='') { $criteria[] = "YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '".$agefrom."' AND '".$ageto."'"; } $query = "SELECT * FROM profiles WHERE " . implode(' AND ', $criteria); $result = mysql_query($query); while ($row = mysql_fetch_array($result)){ echo $age = userAge($dob= $row["dob"]).''; } } print_r($_POST); ?> like the first posted above i wish to have option to load just 5 search by default and then a button to load more results matching the selected criteria from search.php im not getting any idea how to achieve it

anyone?

ok currently i use these below coding to load more results from database JS and HTML on index.php <script type="text/javascript"> $( document ).on( 'click', '.loadmore', function () { $(this).text('Loading...'); var ele = $(this).parent('li'); $.ajax({ url: 'load.php', type: 'POST', data: { page:$(this).data('page'), }, success: function(response){ if(response){ ele.hide(); $(".news_list").append(response); } } }); }); </script> /////////////////////////////////////////////////////////////////////////// <div id="container"> <ul class="news_list"> <?php $query=mysql_query("SELECT * FROM profiles WHERE Gender ='female' ORDER BY UserID DESC LIMIT 0 , $resultsPerPage"); while($data=mysql_fetch_array($query)){ $fname=$data['Fname']; $lname=$data['Lname']; echo "<table border='0'><tr><td><h3>$fname</h3></td><td>$lname</td></tr></table>"; } ?> <li class="loadbutton"><button class="loadmore" data-page="2">More Records...</button></li> </ul> </div> load.php <?php if(isset($_POST['page'])): $paged=$_POST['page']; $sql="SELECT * FROM profiles WHERE Gender ='female' ORDER BY UserID DESC"; if($paged>0){ $page_limit=$resultsPerPage*($paged-1); $pagination_sql=" LIMIT $page_limit, $resultsPerPage"; } else{ $pagination_sql=" LIMIT 0 , $resultsPerPage"; } $result=mysql_query($sql.$pagination_sql); $num_rows = mysql_num_rows($result); if($num_rows>0){ while($data=mysql_fetch_array($result)){ $fname=$data['Fname']; $lname=$data['Lname']; echo "<table border='0'><tr><td>$fname</td><td>$lname</td></tr></table>"; } } if($num_rows == $resultsPerPage){?> <li class="loadbutton"><button class="loadmore" data-page="<?php echo $paged+1 ;?>">More Records...</button></li> <?php }else{ echo "<li class='loadbutton'><span class='endload'> No More Data... </span></li>"; } endif; ?> what im trying to acheive is get search records the similar way when user submits the form on search.php then on the results.php few records show and when click on load more and more search records display. Anyone?

ok what i am looking for is to be able to fetch users phone number from database and then display it over an image so that no copy paste business happens. any help?

issue solver :-D all i had to do was first upload the image then watermark $fileUpload = move_uploaded_file($tmp_name,"../uploads/profiles/".$image_name); $image_name=time().".".$ext; watermark_image($tmp_name,"../uploads/profiles/".$image_name);

here is what i tried but no output $image_path = "watermark.png"; function watermark_image($oldimage_name, $new_image_name){ global $image_path; list($owidth,$oheight) = getimagesize($oldimage_name); $width = $height = 500; $im = imagecreatetruecolor($width, $height); $img_src = imagecreatefromjpeg($oldimage_name); imagecopyresampled($im, $img_src, 0, 0, 0, 0, $width, $height, $owidth, $oheight); $watermark = imagecreatefrompng($image_path); list($w_width, $w_height) = getimagesize($image_path); $pos_x = $width - $w_width; $pos_y = $height - $w_height; imagecopy($im, $watermark, $pos_x, $pos_y, 0, 0, $w_width, $w_height); imagejpeg($im, $new_image_name, 100); imagedestroy($im); unlink($oldimage_name); return true; } if(isset($_GET['id'])) { $qry = "SELECT * FROM tbl_emp where id=".$_GET['id']; $result = mysql_query($qry); $row = mysql_fetch_array($result); if($_SERVER["REQUEST_METHOD"] == "POST") { $name = $_POST["name"]; IF($_FILES['file']['name']!='') { $file='../uploads/profiles/'.$row['image']; @unlink($file); $tmp_name = $_FILES["file"]["tmp_name"]; $namefile = $_FILES["file"]["name"]; $ext = end(explode(".", $namefile)); $image_name=time().".".$ext; $fileUpload = move_uploaded_file($tmp_name,"../uploads/profiles/".$image_name); watermark_image($namefile, $image_name); } else { $image_name=$row['image']; } $sqlAdd ="update tbl_emp set name='".$name."', image='".$image_name."' where id=".$_GET['id']; mysql_query($sqlAdd); header("Location:add.php?id=".@$_GET['id']."&msg=success"); exit; }

mates the following code below i use to update uploaded images but i need help adding watermark to the images during upload if($_SERVER["REQUEST_METHOD"] == "POST") { $name = $_POST["name"]; IF($_FILES['file']['name']!='') { $file='../uploads/profiles/'.$row['image']; @unlink($file); $tmp_name = $_FILES["file"]["tmp_name"]; $namefile = $_FILES["file"]["name"]; $ext = end(explode(".", $namefile)); $image_name=time().".".$ext; $fileUpload = move_uploaded_file($tmp_name,"../uploads/profiles/".$image_name); } else { $image_name=$row['image']; } $sqlAdd ="update tbl_emp set name='".$name."', image='".$image_name."' where id=".$_GET['id']; mysql_query($sqlAdd); header("Location:add.php?id=".@$_GET['id']."&msg=success"); exit; } your help is appreciated

wow finally fixed it $query = "SELECT * FROM profiles WHERE " . implode(' AND ', $criteria); $result = mysql_query($query); while ($row = mysql_fetch_array($result)){ echo $age = userAge($dob= $row["dob"]).''; } now it shows results, thanks you all soo much, you all taught me quite alot of new things, really appreciate it cheers

sorry i did this way, have edited the post $query = "SELECT * FROM profiles WHERE " . implode(' AND ', $criteria); $result = mysql_query($query); if(!$result){ echo 'failed: '.mysql_error(); }

did this $query = "SELECT * FROM profiles WHERE " . implode(' AND ', $criteria); echo 'Error: '.mysql_error(); nothing shows still not even an error also added '=' if($gender !='') { $criteria[] = "Gender = '".$gender."'"; } if($religion !='') { $criteria[] = "Religion = '".$religion."'"; } if($caste !='') { $criteria[] = "Caste = '".$caste."'"; } if($state !='') { $criteria[] = "State = '".$state."'"; } if($employment !='') { $criteria[] = "Employment = '".$employment."'"; } if($mstatus !='') { $criteria[] = "Maritalstatus = '".$mstatus."'"; }

oh got it. now i removed all LIKE = if($gender !='') { $criteria[] = "Gender = '$gender'"; } if($religion !='') { $criteria[] = "Religion '$religion'"; } if($caste !='') { $criteria[] = "Caste '$caste'"; } if($state !='') { $criteria[] = "State '$state'"; } if($employment !='') { $criteria[] = "Employment '$employment'"; } if($mstatus !='') { $criteria[] = "Maritalstatus '$mstatus'"; } still no output all i get is SELECT * FROM profiles WHERE Gender = 'female' AND YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '18' AND '25' what am i doing wrong? or is it because no mysql_query is used so not getting any results?

oh yes i corrected the $agefrom !='' && $ageto !='' and yes there are data in table which i tried to search but nothing displays even tho i echoed i only get to the the echoed query as SELECT * FROM profiles WHERE Gender LIKE = '%female%' AND YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '18' AND '30'

cool thanks, so now my code looks like this, please take a look and tell me if its ok or not? <?php include("manage/connect.php"); if(isset($_POST['submit'])){ $gender = mysql_real_escape_string($_POST['gender']); $religion = mysql_real_escape_string($_POST['religion']); $caste = mysql_real_escape_string($_POST['caste']); $state = mysql_real_escape_string($_POST['state']); $employment = mysql_real_escape_string($_POST['employment']); $mstatus = mysql_real_escape_string($_POST['mstatus']); $agefrom = mysql_real_escape_string($_POST['agefrom']); $ageto = mysql_real_escape_string($_POST['ageto']); $criteria = array(); if($gender !='') { $criteria[] = "Gender LIKE = '%".$gender."%'"; } if($religion !='') { $criteria[] = "Religion LIKE = '%".$religion."%'"; } if($caste !='') { $criteria[] = "Caste LIKE = '%".$caste."%'"; } if($state !='') { $criteria[] = "State LIKE = '%".$state."%'"; } if($employment !='') { $criteria[] = "Employment LIKE = '%".$employment."%'"; } if($mstatus !='') { $criteria[] = "Maritalstatus LIKE = '%".$mstatus."%'"; } if($agefrom && $ageto !='') { $criteria[] = "YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN '".$agefrom."' AND '".$ageto."'"; } echo $query = "SELECT * FROM profiles WHERE " . implode(' AND ', $criteria); while ($row = mysql_fetch_array($query)){ echo $age = userAge($dob= $row["dob"]).''; } } ?> everything seems ok but no results from database displays. what would be the issue?

still not getting it mate. this is kind of new to me. could you show me example please? also this following query display all records of whichever gender selected SELECT * FROM profiles WHERE Gender LIKE '%".$gender."%' OR Religion LIKE '%".$religion."%' AND YEAR(FROM_DAYS(DATEDIFF(CURDATE(), dob))) BETWEEN $agefrom AND $ageto what is wrong im doing?