Re: [PHP-DB] problems inserting in specific row From: Bojan Gajic (bojan <email protected>)
Date: 11/21/00

Maybe you wan't to use update, instead of insert?

bojan

Jeof Oyster wrote:

> Can you tell me what is wrong with my code?
>
> What I'm doing is this:
> I have a form that users answer questions and then submit. The Action
> calles GET the same document, with all the form variables inserted in.
> What is supposed to happen is that php is supposed to enter the user's
> answers into our database, but only in the proper record (based on
> variable username). So the info for Joe_Smith is entered only into the
> record where the username field equals "Joe_Smith". I keep getting an
> error in query and don't know where I'm going wrong.
>
> $server = "aaaa";
> $user = "bbbbb";
> $pass = "ccccc";
> $db = "dddddt";
> $connection = mysql_connect($server, $user, $pass);
> // formulate and run query
> $query = "insert into
> et01app_gen(lisalvation,lireasons,lifamilylife,lileadership,statusinterview)
> values('lisalvation','lireasons','lifamilylife','lileadership','statusinterview')
> where username=\'username\'";
> mysql_db_query($db,$query,$connection) or die("Error in query");
>
> Thanks!
> Jeof Oyster
> Top Flight Leadership
>
> PS- Please hit reply to all so I receive a copy of your reply, and then
> come back to read more. Thanks
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>