hi,
i have a problem
i have a database table created with the statement:
CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL AUTO_INCREMENT, message
text, username varchar(100), UNIQUE id (id);
I insert records with:
INSERT INTO chatmessages (message, username) VALUES ('$message',
How can I implement Yahoo-like search?
For example:
+WinZip +Mac
in one of my field in my table 'software' ?
TIA,
Lisa
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
Hi
You can use the parsing functions of PHP 4.0 to replace the '+' with AND or
OR and '-' with NOT and generate a SQL query into your table.
Then, use links like
a href='resultlink.php?id=12link=Link%20Result%20PageYour search
result/a to display the results.
Hope this helps
Sridhar
At 12:58 PM 3/4/01 +0100, Joris Kluivers wrote:
hi,
i have a problem
i have a database table created with the statement:
CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL
AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id);
I insert records with:
INSERT INTO
Norman,
The SQL statement is this:
select s.first_name AS s_name, t.first_name AS t_name, f.date from
members s, members t,
schedule f where s.first_name=f.member1 and t.first_name=f.member2
The AS is optional but it works the same as aliasing table names in the
FROM clause.
$s_name | $t_name
Thanx for all the help, it was so quick. I would have helped if I checked
the manual first though :)
Expecting the world to treat you fairly because you are a good person is a
little like expecting the bull not to attack you because you are a
vegetarian."
Unix specialist Web Developer
Bonzai
change
CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL
AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id);
to
CREATE TABLE chatmessages (id int(11) DEFAULT '0' NOT NULL
AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id);
mvh
Knut
thankx for the reply's on my mail
Joris Kluivers
Hey...Janet Here... We Haven't Talked In So Long!!
How Have You Been? Thought I would Forward you this email!
I usually delete these but I opened this one, like what I saw,
and thought you would like to see this.
http://www.geocities.com/anewmarket/
IF THE LINK IS NOT HIGHLIGHTED OR
Hi.
This semester I am enrolled in a database management class using Oracle. A
couple of the projects we have to do ( coming in a few weeks ) is embedded
SQL. I have convinced my instructor to let me use PHP for these projects.
The problem is that our school server does not have PHP installed
Howdy,
I'm getting weird problems trying to INSERT to two different tables, in
consecutive mysql_queries. Before, I had 3 queries going, and only 2 would
work at any time. It seemed like it was 'rotating' the bad query - first
the 1st query would fail (the other two were fine), then I'd empty
11 matches
Mail list logo