--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I have a search page and a results page. It's a
> dynamic search. It works great with just the main
> table, but as soon as I add in the table joins (to
> translate the codes) it just dumps out all the
> records
> regardless of criteria.
>
> H
You can concat to the 1º filter statement the 2º. ex:
SELECT * FROM atable WHERE (fieldname = fieldvalue) AND (fieldname2 =
fieldvalue2)
For the user to search twice in the same field i think you have to use the
LIKE operator instead of the = and use the % in the string as wildcard. ex:
1º Searc
CHANGE:
TO:
if( mysql_num_rows($result) > 0 )
{
echo "$contact_list";
}
else
{
echo "$msg";
}
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Search results
I have done a search pa
On Wed, 6 Feb 2002, Todd Williamsen wrote:
Please keep discussion on the list.
> Doesn't execute the $msg variable. And it doesn't return any results:
Have you checked that your query does indeed return results?
> I tried this:
>
> if ($result == 0) {
> echo "$msg";
> }
> else {
> echo "$c
On Wed, 6 Feb 2002, Todd Williamsen wrote:
> that doesn't work
Bit terse? What do you get? Error? Nothing?
--
Jason Wong
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
that doesn't work
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> On Thursday 07 February 2002 02:16, Todd Williamsen wrote:
> > I have done a search page based on a specific column name, but in some
> > columns there is no results to be returned..
> >
> > What I wo
On Thursday 07 February 2002 02:16, Todd Williamsen wrote:
> I have done a search page based on a specific column name, but in some
> columns there is no results to be returned..
>
> What I would like to do is display an error message stating that there is
> no results .. something like "Sorry you
Use in your select-query 'LIMIT'. (See MySQL manual)
It's possible then to specify the range and the startingpoint. So?
Only the right buttons: i.e.
Simple, isn't?
Daniel Kieviet
Xsarus Internetdiensten
www.xsarus.nl
- Original Message -
From: "David Drummond" <[EMAIL PROTECTED]>
To: <
I've not seen the limit function, but it sounds quite uselfull. Whatever method,
you could
pass the first or last keys related to the current page and an indication as to
whether you
are going forwards or backwards - I suppose that in PHP it could all be done in
one file,
self-referential-like, a
In article <001301c0bafa$34d15be0$[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("David Drummond") wrote:
> Can anyone tell me what is the best way to implement displaying multiple
> search results using next and previous buttons to cycle through all the
> results. I see this method done on a lot of
10 matches
Mail list logo