Start with a good tutorial on PHP and MySQL - there are scads of them around, and Julie Meloni has some excellent examples at www.thickbook.com.
At 04:41 PM 7/6/2003 -0300, Kevin Fradkin wrote:
hi... i have this secuence to insert data to my db
mysql_query ("INSERT INTO my_table( number,name,surname ) values ('$number','$name','$surname' )");
i want to ask what do i have to do if i want to modify instead of insert when this data already exists... for example.. i have in my_table number name surname 1 jhon smith
and i want to change the name...jhon --> john
Use a SELECT query to find if it exists (mysql_numrows() - check sp.)
then issue an UPDATE query to change it, making certain you have a unique key to identify the record.
otherwise, use your INSERT query.
This stuff isn't magic - you have to do a bit of work to get the desired results.
and if that not exist create it... number name surname 0 mary duke 1 charles emmerson
and add john's one.. ( to check if i can use only modify to add )
thnx!..
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
