taroo2ah
Last Activity: Feb 28 '08, 01:14 PM
Joined: May 14 '07
Location: Cairo, Egypt
-
Ok, I give up with "user variables". Is there anyway to reverse 2 values of 2 columns of a MySQL database?!! -
What is wrong with this SQL statement?!
Enviroment: MySQL 5, PHP 5, Windows, Apache.
Database: MyTable [id, Field1, Field2].
Case: I want to reverse the value of Field1 and Field2 where Field2 = $SomeVal. I have wrote the following statement but it didn't work:
Question: What is wrong with the above statement since it allways affects 0 rows...Code:'update MyTable set Field1 = @OldField2 := Filed2, Field2 = @OldField1 := Field1 where Field2 = 1250';
-
Backing up a utf-8 charset database remotely.
Hi,
I use PHP5 with MySQL5 on Windows with Apache. I do store "Arabic" in my tables using utf-8 charset. I have a "Linux" hosting where I create & store my databases. Because of Windows problems and the need to reinstall Windows, I allways need to restore my databases from on my hosting account. The problem is: When I make a backup & restore it on my PC, "Arabic" data in database arrive runed and don't... -
Hi,
You can use the explode() function giving it the comma as the first parameter, and the string as the second and it will fill an array for you. It should look like the following:
$ArrayOfNames = explode(',' , $StringOfCommaS eparatedNames);
In the line above the variable $ArrayOfNames should now hold all the names contained in the variable $StringOfCommaS eparatedNames. You can then display the names as follow:...Leave a comment:
-
Arabic Language
Hello everybody,
Making backup of a MySQL database allways ruins the data inside it! I have tried many things and I am now againest something that I need to know: what is the deference between utf8_unicode_ci and utf8_general_ci ? Should I set all my mysql databse Collations to utf8_unicode_ci or utf8_general_ci ? Or I may need to set some with the first and others with the second! Please, help me and if anybody of you could before to backup...
No activity results to display
Leave a comment: