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] Quote Link to comment 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);?> Quote Link to comment 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.