Hey to everyone!!
Currently, i am working on some php codes and was wondering who can porvide a sample of an advance search coding.

I have a database in mySql and i want to link it to the database. Thanks alot!

what do you mean by advance searching? for example in the word "iloveyou" and the user wants to search the word "love" and the word "iloveyou" will still appears in the searched screen?

<center>good day...this is for you...

<img src="www.wedding-chapels.com/images/Single_Stem_off-white-rose.jpg" border=0>

hope you like it
</center>

Edited by - exoskeleton on 09 Nov 2006 04:07:21

I need the codes to create a search field whereby the users will key in the words like as you said "i love you" and the serach engine will quickly collect the required data from teh database and display the
result... i need to know the codes for the function...

Im currently using a freeware whereby i need to integrate this serach field for accessibilty... My database is using SQL... thanks for the help!!

hi hope you like the roses...well lets get back to work...in the word "i love you", "love" is in the middle of the given word so you mean if i search "love" even though it is in the middle/center of the given word, "i love you" will still appears in the search screen? if thats what you want then you make use of "LIKE" for example:

SELECT * FROM tbl_raquel WHERE column_name LIKE '%$variable_name%'";

you will use LIKE in the SQL then the percent sign...okidoki...

friends?




Edited by - exoskeleton on 10 Nov 2006 03:45:07

Thank you for the rose! It's lovely =) going back to the topic, yes you got it right... however i do need the full code for that to connect to my database cuz apparently the search function in the system im using is not functioning and i'd like to remove it...

So by removing it i ought to replace it by a good and fucntioning code... diba? so... ya... i do need the codes ... do you have it ??? or is there any website i can go to? cuz i went to php.net and so many php websites and couldnt find it..... =(

really? you like it? ahmmm <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle> ... ok...you mean there is no database connection in your system?

here's the connection code:

$dbcon = mysql_connect("server_name","user";
if(!$dbcon){
echo "Database connection error";
}
mysql_select_db("database_name",$dbcon);

....i have a classmate in singapore. his now a system admin of a certain company...are you a filipino? coz there's a diba? in your message... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

can i have your email? ahmmm just wanna be your friend?.. if its ok

<div align=right>
afraid NOT to FAIL for you learn NOTHING

www.nasbikesphilippines.bravehost.com
<img src="www.motorcyclephilippines.com/forums/signaturepics/sigpic14460_2.gif" border=0></div id=right>

hahaha... yeah the rose is lovely <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle> ... i do have a database... but... i want to get rid of the search field and put in a new one because the current search field cannot search anything... or is it ok if i give you see the codes and you helpe me check??

I will emaail you =) friends !

ah ok send it to me but...only if you chat with me tonight <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle> deal? maybe at 8pm is that ok <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

then send your files tonight

<div align=right>
afraid NOT to FAIL for you learn NOTHING

www.nasbikesphilippines.bravehost.com
<img src="www.motorcyclephilippines.com/forums/signaturepics/sigpic14460_2.gif" border=0></div id=right>