I'm in indiana, USA. Its probally returning all the rows because of common
words that are in the search field. Thats why when you search on Yahoo or
Google, there are certian words that are not included, you might want to test
that theroy.
Derek Nugent <[EMAIL PROTECTED]> wrote: Thank
you 2 guys mega amounts.
The error is gone
The only problem now is it's bringing up all the records in the database and
not stopping.
Thanks for your help... I'm super excited about the progress this is awesome!
Where are you guys from?
I'm currently in Scotland.
<?php
$count = 0;
//echo $count;
//$article =mysql_fetch_object($result);
while ($line = mysql_fetch_object($result)) {
?>
<table border="0" cellspacing="0" cellpadding="0" width="328">
<tr>
<td width="328" height="41" class="pageName" >
<?php echo $line->title; ?>
</td>
</tr>
<tr>
<td class="bodyText">
<p>
<?php echo $line->description; ?>
</p>
<p> </p>
</td>
</tr>
</table>
<?php
$count ++;
};
print_r(mysql_fetch_assoc($result));
?>
----- Original Message ----
From: kevin myers <[EMAIL PROTECTED]>
To: [email protected]
Sent: Monday, September 18, 2006 8:18:06 PM
Subject: Re: [php_mysql] Using a variable in a query
$query = "SELEFT * FROM tutorials WHERE description LIKE ('% " .
$searcgkeyword . "%')"; try that
Derek Nugent <derekintexas@ yahoo.com> 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 <shaggy2dope2126@ yahoo.com>
To: [EMAIL PROTECTED] ps.com
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]
[Non-text portions of this message have been removed]
---------------------------------
Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small
Business.
[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/
