User Profile

Collapse

Profile Sidebar

Collapse
faif
faif
Last Activity: Dec 20 '07, 02:19 PM
Joined: Sep 20 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • faif
    started a topic mysql 5 UTF and ISO website compatibility

    mysql 5 UTF and ISO website compatibility

    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.
    See more | Go to post

  • Thanks again. ............... ............... .........
    See more | Go to post

    Leave a comment:


  • faif
    started a topic javascript breaks when element not visible... :(

    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') ;...
    See more | Go to post

  • faif
    replied to insert with nested select problem
    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.
    See more | Go to post

    Leave a comment:


  • faif
    replied to insert with nested select problem
    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....
    See more | Go to post

    Leave a comment:


  • faif
    replied to insert with nested select problem
    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...
    See more | Go to post

    Leave a comment:


  • faif
    started a topic insert with nested select problem

    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.
    See more | Go to post
    Last edited by mwasif; Sep 20 '07, 12:44 PM. Reason: Replaced [CODE] with [CODE=mysql]
No activity results to display
Show More
Working...