$query = "SELECT * FROM `tutorials` WHERE `description` LIKE '%$searchKeyword%'";
----- Original Message ----- From: Derek Nugent To: [email protected] Sent: Monday, September 18, 2006 1:52 PM Subject: [php_mysql] Using a variable in a query 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] 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/
