[PHP-DB] AUTO_INCREMENT

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',

[PHP-DB] How can I implement Yahoo-like search?

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

Re: [PHP-DB] How can I implement Yahoo-like search?

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

Re: [PHP-DB] AUTO_INCREMENT

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

[PHP-DB] Re: Join statement and output

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

Re: [PHP-DB] Mail Form error

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

SV: [PHP-DB] AUTO_INCREMENT

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

[PHP-DB] thankx (AUTO_INCREMENT)

thankx for the reply's on my mail Joris Kluivers

[PHP-DB] NEWEST CRAZE

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

[PHP-DB] Looking for free temp hosting; php w/ oracle support

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

[PHP-DB] MySQL - Problem with multiple INSERTs?

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