[PHP] how to modify in the db

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 numb

Re: [PHP] mysql_query

Thnx! :) one last question for the day... if in one cell i have two names. ex 'mary eleanor' and i want to search by typing 'ele' with name LIKE '$name%' will not give me mary eleanor as a result... any ideas? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http:

Re: [PHP] mysql_query

the problem is if i put 821000 i will have as result all number > 821000 including 83 and i only need numbers begining with the numbers i entered.. i will try now the other thing!.. thnx! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.ph

[PHP] mysql_query

and now.. if in one cell i have for example... "John Matheus" when i do the query i have to put exactly john matheus to find it... is there any way to just write jo and search in every cell that contains those words? example... i have 1 column with 5 rows each 6 numbers inside : 821554 821674 81

[PHP] mysql_query

hi... 1 question... how can i show in a table the query i'm trying to make this is what i want : select * from my_table where var1='$val1' /* here comes the trouble cause i want to use 2 instead of only one... */ var2='$val2' how you have to use it for more than one? where var1='$val1' ??? var2

Re: [PHP] Re: Send $out embedded in a mail in HTML FORMAT

Thanks a lot!!.. finally.. i found what i was looking! nice having people who can help us! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Send mail in HTML FORMAT

I read from a template, insert data and save it as a new file with html code... i want to send that file that is the same as $out via mail embedded in it... i do $fifi = fopen ('/'.$cursada.$cuatrimestre.'/'.$registronro.'.htm', "w"); $fp = $fifi; fputs ($fifi, $out . ""); fclose ($fifi); mail("[

[PHP] Send $out embedded in a mail in HTML FORMAT

I read from a template, insert data and save it as a new file with html code... i want to send that file that is the same as $out via mail embedded in it... i do $fifi = fopen ('/'.$cursada.$cuatrimestre.'/'.$registronro.'.htm', "w"); $fp = $fifi; fputs ($fifi, $out . ""); fclose ($fifi); mail("[