php-mysql database

autocolismo

how do i change values in MySQL database' fields??
Thanks!!!

autocolismo

$sql="insert into myfield from mytable ($value)";
is it something like that?

examancer

something like this:

$sql = "INSERT INTO users SET username = \"$username\", password = \"$PASSWORD\"";

autocolismo

fine, thanks, now just one more thing this creates a new record,
how to change an existing what do i change here?

autocolismo

ok just to say i figured that by replacing the INSERT by REPLACE
🙂
i think this is it.
thanks i'll buy you a beer

autocolismo

sorry, how do i delete the record ?

skodman

If you want to change data in record (MySQL) use this:

"update mytable set myfield1=$var1, myfield2=$var2,myfield3=$var3 where myfiel4=$var4"

iif you want to delete record try:

"delete from my table where myfield=$var"

when you delete records from table DO NOT FORGET TO DEFINE WHERE PART . if you don't define WHER then entire table will be deleted.

skodman

autocolismo

thank u very much,
if you need any help with flash or other macromedia tools, just ask me i'll help you.
😃

filch

I have been noticing that many of you use backslashes in your SQL queries. What's up with that?

I know the sql insert query to be: INSERT INTO someDb (column1, column2) VALUES ('value1', 'value2');

What is with the '\' I see you guys using?

Cheers

filch

autocolismo

I just know that i tried before without the slashes and it didn't work, with them works fine.

skodman

look guys
if you want to enter quotation inside quotations then you can do that in two 3 ways:

" some mysql sintax where name='skodman' "
' some mysql sintax where name="skodman" '
" some mysql sintax where name=\"skodman\" "
' some mysql sintax where name=\'skodman\' '

So if you want to use same character inside quotations then you have to use "\". otherwise PHP will tell you that there is a parse error since it considers second quotation as the end of a string.

skodman

filch

So the key here would be to use the right quotation mark in the right order? Owing to my lack of experience with PHP, I am not sure if there would ever be a compelling reason to have to use bqckslashes ... would there? Or is there instances where you cannot avoid having to use them?

Cheers,

filch

skodman

Of course that this can happen. Espatialy when you use php for echoing HTML code like

echo "<a href='javascript:my_function(\"skodman\");' >.....";

understand?

😃 skodman

filch

So, it is an escape character?

filch

skodman

yep

skodman