Hi.. i create a search button in my program..to search in a particular record in my database..what are the codes that i'll be using in order to search a record? tnx in advance..Godbless
takeshi
0
Junior Poster in Training
Recommended Answers
Jump to PostYou have to creater an SQL query. Search for SQL tutorial, if you dunno what it is, or how to work with it. After creating an SQL Query, use PHP to connect to your database, execute command and then display result.
Jump to PostOpen your FTP client and click on properties of that file, and set permissions to 0777, that is tick all the checkboxes and see if it works!
Jump to PostOh windows, um I dont have much idea about changing permissions in it, but in XP Sp3, Vista, 7 right click and select properties. Select security tab, and select Full Control for users below.
Jump to PostSearch.php page
<form action="show.php" method="post"> <input type="text" value="Enter Site ID" name="id" maxlength="30" onfocus="this.value=''"> </td> </tr> <tr> <td align="center" value="Search"/> </form>
show.php page
<?php $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } $a= $_POST["id"]; mysql_select_db("onm", $con); $result = mysql_query("SELECT * …
Jump to Postyou have to use the 'like' function of mysql... seet this link for a much detailed info.
http://w3schools.com/sql/sql_like.asp
All 19 Replies

GreenDay2001
takeshi
0
Junior Poster in Training

GreenDay2001
takeshi
0
Junior Poster in Training

GreenDay2001
smartness
-3
Junior Poster
takeshi
0
Junior Poster in Training
smartness
-3
Junior Poster
takeshi
0
Junior Poster in Training
ayesha789
7
Posting Pro in Training
takeshi
0
Junior Poster in Training
takeshi
0
Junior Poster in Training
smartness
-3
Junior Poster
takeshi
0
Junior Poster in Training
takeshi
0
Junior Poster in Training
takeshi
0
Junior Poster in Training
smartness
-3
Junior Poster
vaultdweller123
32
Posting Pro
takeshi
0
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.