$query = "SELEFT * FROM tutorials WHERE description LIKE ('% " . $searcgkeyword
. "%')"; try that
Derek Nugent <[EMAIL PROTECTED]> wrote: My
real dilema is how to use a variable in a query
$query = "SELECT * FROM tutorials WHERE description LIKE
('%"$searchKeyword"%')";
gives me the following error
Parse error: parse error, unexpected T_VARIABLE in
C:\wamp\www\DerekNugent\htdocs\index.php on line 14
I think I've got the syntax wrong.
Many thanks for getting back to me so fast!
AWESOME
Best regards
Derek Nugent
www.dereknugent.com
----- 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]
---------------------------------
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]
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/
