for better results, try using MATCH->AGAINST statements
hth
----- Original Message -----
From: Derek Nugent
To: [email protected]
Sent: Monday, September 18, 2006 9:43 PM
Subject: Re: [php_mysql] simple search box
Thanks man
$searchKeyword = $_POST["searchField"];
//echo $searchKeyword;
// Performing SQL query
$query = "SELECT * FROM tutorials WHERE description LIKE
('"$searchKeyword"')";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
I've made a little bit of a break through using
mysql_fetch_object
instead of
mysql_fetch_array
just incase you ever need it my MSN messenger contact is [EMAIL PROTECTED]
Many many thanks
----- Original Message ----
From: kevin myers <[EMAIL PROTECTED]>
To: [email protected]
Sent: Monday, September 18, 2006 7:21:11 PM
Subject: Re: [php_mysql] simple search box
do you have a base code you are using right now? that would help us out, if
not, then give us the code you are suing so far
Derek Nugent <derekintexas@ yahoo.com> wrote: Thanks guys but it's the MySQL
stuff I'm stuck with
Then how to access the individual components
----- Original Message ----
From: kevin myers <shaggy2dope2126@ yahoo.com>
To: [EMAIL PROTECTED] ps.com
Sent: Monday, September 18, 2006 5:54:45 PM
Subject: Re: [php_mysql] simple search box
//first page
<form action = "second_page. php" method = "get">
<input type = "text" name = "search" value = "search">
<input type = "submit" name = "submit" value = "search">
//second page
$keyword = $_GET['search' ]
then you do the mysql stuff
Derek Nugent <derekintexas@ yahoo.com> wrote: How can I pass a form variable
from a previous page to a query in a second page?
I'm trying to set up a search box on my website.
Excellent response time on the last php enquirey!
AWESOME
[Non-text portions of this message have been removed]
------------ --------- --------- ---
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2ยข/min or less.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
____________ _________ _________ _________ _________ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail. yahoo.com
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/php_mysql/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
