Hello there.
I'm using mysql 5 and php 5. For a particular reason (encoding problems), I need to encode a website as ISO, and the database as UTF. Is this possible, or both must use the same encoding?
Thanks.
User Profile
Collapse
-
mysql 5 UTF and ISO website compatibility
-
Thanks again. ............... ............... ......... -
javascript breaks when element not visible... :(
Hello,
I'm using a javascript function to pass the values of various form elements. The problem is that the script breaks when I'm trying to retrieve a value of an element that is not visible, because of category/subcategory dependency.
The function is:
[code="javascrip t"]
<script language="JavaS cript">
function reloadF(f)
{
var catV = document.getEle mentById('cat') ;... -
Finally, a two-step solution has been found. The solution is:
[code=mysql]
CREATE TEMPORARY TABLE temp
(select t2.field2, t2.field3
from table2 t2
where t2.field3="stri ng");
update table1 t1, temp t
set t1.field1=t.fie ld3
where t1.field2=t.fie ld2;
[/code]
Thank you all for the help.Leave a comment:
-
Thank you. I tried but mysql doesn't like it... :(
The error message is:
#1064 - You have an error in your SQL syntax near 'SELECT t2.field3
FROM table2 t2
WHERE t2.field' on line 2
Info: The inner query returns multiple rows....Leave a comment:
-
Thank you for the answer, but unfortunately I've already tried this and it is not what I'm looking for.
I want to copy the values of the fields of table2 to the fields
of table1. I use the t2.field4=table 1.field4 because I want to copy the contents in the appropriate records, and don't create new. When I'm using a copy of table1
in the inner query, new records are created in table1, and this doesn't solve my probl...Leave a comment:
-
insert with nested select problem
I want to implement a query similar to this in mysql:
[CODE=mysql]
insert into table1 (field1)
(select t2.field2
from table2 t2
where t2.field3="stri ng" and t2.field4=table 1.field4)
[/CODE]
the reference to table1 from the inner query (table1.field4) does not work.
Is there a way to achieve this?
Thank you.
No activity results to display
Show More
Leave a comment: