Re: [PHP-DB] basic form entry

2007-10-08 Thread OKi98
most likely you have a problem in your query but you dont understand how to use mysql_error. from http://www.php.net/manual/en/function.mysql-error.php : string *mysql_error* ( [resource $link_identifier] ) Returns the error text from the last MySQL function echo mysql_error(mysql_connect($ho

Re: [PHP-DB] basic form entry

2007-10-07 Thread [EMAIL PROTECTED]
echo('$username','$last') ??? what was your intention with this line? assuming your table's field names are as set in your query then everyuthing is OK. which brings me to the line above (which is quite oddly syntaxed!). Please explain what you meant by this and I may be able to help you furthe

Re: [PHP-DB] basic form entry

2007-10-07 Thread Rich Hutchins
ED]> To: "sm" <[EMAIL PROTECTED]> Cc: Sent: Sunday, October 07, 2007 4:47 AM Subject: Re: [PHP-DB] basic form entry INSERT inserts new data to database. If you want to update data, use UPDATE instead of INSERT. Olavi Ivask I have been racking my brains trying to figure ou

Re: [PHP-DB] basic form entry

2007-10-07 Thread T K
> mysql_query ("INSERT INTO users (First,Last,Phone,Mobile,Email,Web) VALUES > ('$first_name','$last','$phone,'$mobile','$email','$web') "); > > echo('$username','$last') This doesn't work. You need to make a variable for the executed query, like, $query = mysql_query(.); After that, you get

Re: [PHP-DB] basic form entry

2007-10-07 Thread Olavi Ivask
INSERT inserts new data to database. If you want to update data, use UPDATE instead of INSERT. Olavi Ivask I have been racking my brains trying to figure out what I am doing wrong. > i > have created a basic form that calls requests user information...the form > then runs insert.php. No errors ar

[PHP-DB] basic form entry

2007-10-06 Thread sm
I have been racking my brains trying to figure out what I am doing wrong. i have created a basic form that calls requests user information...the form then runs insert.php. No errors are returned, however, my database does not update. Any suggestions? thanks The field names in the table are co