[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

[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 and

[PHP-DB] Re: [PHP] Problem getting PostgreSQL to compile

Yes, I've checked phpinfo() and not it is not compiled in. That is the problem. I have recompiled PHP with pgsql support and there is some problem. I'm not sure why it isn't compiling it in. I've tried everything I knowthe installation goes fine...no error messages, everything seems ok

[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 YO

[PHP-DB] thankx (AUTO_INCREMENT)

thankx for the reply's on my mail Joris Kluivers

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 > -Opp

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

[PHP-DB] Mail Form error

Can someone please tell me why this form doesn't work? I get the following error: Warning: Wrong parameter count for mail() in /home/www/projects/temp/mailform4.php on line 11 The code is as follows: Your information has been submitted.\n"; } else { echo "Use this form to submit your inform

[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] AUTO_INCREMENT

on 3/4/01 3:58 AM, Joris Kluivers at [EMAIL PROTECTED] wrote: > CREATE TABLE chatmessages (id tinyint(6) DEFAULT '0' NOT NULL > AUTO_INCREMENT, message text, username varchar(100), UNIQUE id (id); > with php. > But after some time i get the error: > ERROR 1062: Duplicate entry '127' for key 1 >

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 c

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 >TIA, >Lisa > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional comm

[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 adminis

[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', '$u

Re: [PHP-DB] Join statement and output

Use column-aliasing. To rename a column use the SQL "AS" syntax. Ie. SELECT first_name AS fname .. now "fname" is column name in the result set...Do this for each of your first_name's, obviously using different names and you are set. /cody caughlan Norman Tan wrote: > No actual code, but