redarrow Posted April 10, 2006 Share Posted April 10, 2006 Can you see why this part of my code not working from below please cheers.[code]//if there no result echo message using mysql_num_rows.if (mysql_num_rows($result) == 0){echo" sorry no results";echo $link;exit;}[/code][code]<html><head><title> serch me</title><body><h2>Search result</h2><?// link for user to go back to.$link="<br><a href='http://xxxxxxxxxxxxxxxxx'>Please Search Agin</a>";//trim name input box for spaces in input box.$name=trim($fname);//if name not there echo message.if(!$name) {echo"search result nothink sorry";echo $link;exit;}//connect to database for data result useing like and %wildcard$db=mysql_connect("xxxx","xxxx","xxxx");mysql_select_db("xxxx" , $db);$query="select xxxxx from xxxx where xxxx like '%".$name."%'";$result=mysql_query($query);//if there no result echo message using mysql_num_rows.if (mysql_num_rows($result) == 0){echo" sorry no results";echo $link;exit;}//Fetch the data using asscote array if result there.while($record=mysql_fetch_assoc($result)){while(list($title,$data)=each($record)){echo "<br>".$title.":".$data."<br>";}echo $link;}?>[/code] Quote Link to comment https://forums.phpfreaks.com/topic/7008-code-not-working-please-help/ Share on other sites More sharing options...
redarrow Posted April 10, 2006 Author Share Posted April 10, 2006 how do you add a statement to the aboveif the user dosent enter the exact word there is no results so the user can not just put an example r and get all.i tried this way but dosent seem to work[code]if($name > 4 ) {//go for it}else{echo "sorry no result";echo $link;exit;}[/code][code]if($name == $result ) {//go for it}else{echo "sorry no result";echo $link;exit;}[/code]THIS IS THE PROPER WAY BUT DOSENT SEEM TO WORK ON HERE LOL[code]// GET THE LENTH OF NAME$lenth=strlen($name);//IF THE NAME LESS THEN 3 LETTERS ECHO MESSAGE.if($lenth < 3) {echo" sorry you must enter a larger name";// ELSE RUN THE REST.}else{do somethink}[/code] Quote Link to comment https://forums.phpfreaks.com/topic/7008-code-not-working-please-help/#findComment-25463 Share on other sites More sharing options...
redarrow Posted April 10, 2006 Author Share Posted April 10, 2006 [!--sizeo:4--][span style=\"font-size:14pt;line-height:100%\"][!--/sizeo--]solved [!--sizec--][/span][!--/sizec--]cheers[code]//if name not there echo message.if(!$name) {echo"search result nothink sorry";echo $link;exit;}else{//if type less then 2 letters echo message.$lenth=strlen($name);if($lenth <= 2) {echo"Type a longer word!";echo $link;exit;}[/code] Quote Link to comment https://forums.phpfreaks.com/topic/7008-code-not-working-please-help/#findComment-25471 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.