Gruzin Posted August 14, 2006 Share Posted August 14, 2006 hi again,one more question: I want to make a simple search, here is the code but it doesn't work, thnks for your help.[color=red]<?php$con = mysql_connect("localhost","3d","pass"); if(!$con){ die('Error:'.mysql_error()); // if not connected}mysql_select_db("3d",$con);$result = mysql_query("SELECT * FROM text WHERE text");while($row = mysql_fetch_array($result)) { if($row['text'] == $_POST['search']){ echo "Think I've found something"; echo "</br>"; echo $row['text']; } else { echo "no mathes found"; }}mysql_close($con);?>[/color] Link to comment https://forums.phpfreaks.com/topic/17513-question-about-search/ Share on other sites More sharing options...
JadedLucidity Posted August 14, 2006 Share Posted August 14, 2006 maybe this will help.<?php$con = mysql_connect('localhost','3d','pass') or die('Error:'.mysql_error()); // if not connected}mysql_select_db('3d',$con) or die ('Could not select database');<-----------SELECT col_name FROM tbl_name WHERE col_name > 0;----------> where requires a condition$result = mysql_query("SELECT * FROM text WHERE text");while($row = mysql_fetch_array($result)) { if($row['text'] == $_POST['search']){ echo "Think I've found something"; echo "</br>"; echo $row['text']; } else { echo "no mathes found"; }}mysql_close($con);?> Link to comment https://forums.phpfreaks.com/topic/17513-question-about-search/#findComment-74532 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.