www.webdeveloper.com

Search:

Type: Posts; User: marcosql

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    2,376

    INSERT based on another record's data

    OK, maybe I didn't describe my problem the right way, or I am now making some progress figuring it out by myself...

    Here's my need:

    I have a table, called attributes, which contains just 3...
  2. I'm using mySQL, and I believe it is version...

    I'm using mySQL, and I believe it is version 5.0.22, not sure about it but that's the info I see when I access it through Sequel Pro...

    Also, when I think about it, I am not sure it is an UPDATE...
  3. Yes, precisely, that's what I'm looking to...

    Yes, precisely, that's what I'm looking to accomplish. But I get lost in my 'WHERE' clause since I'm looking to affect 'rows' (attribute 33, and 34) for each userid WHERE attribute 14 is LIKE...
  4. UPDATE statement in 'dynamic' attribute table

    Table name : attributes
    Only 3 fields: userid, attributeid, value

    Table before required UPDATE statement :
    userid attributeid value
    1 14 2000-11-29
    1 ...
  5. Duh! Sometimes we really 'think it too...

    Duh!

    Sometimes we really 'think it too hard'... OK, this one is closed. Let me add this tidbit for other's future reference: since I have rows with names different than 'att', and I didn't want...
  6. Dear NogDog, It works at my end. That's for...

    Dear NogDog,

    It works at my end. That's for the 'one-row-at-a-time' update. What if we wanted to update all 14 rows in a single query, say for att1 through att14 ?

    Also, on a theoritical...
  7. Hi NogDog, No, no, no... sorry... let me...

    Hi NogDog,

    No, no, no... sorry... let me clarify. The data parts of my example are just to reflect 'some data'. You should view them more as variables, not as the actual data itself. I just...
  8. This did it for me. Thanks a lot Bear. Marco

    This did it for me.

    Thanks a lot Bear.

    Marco
  9. Copy field from a record to another in same table

    Here's my table structure:

    Table1
    id, name, data
    1, att1, Lorem ipsum 1
    1, att2, Lorem ipsum 2
    1, att3, Lorem ipsum 3
    1, att4, Lorem ipsum 4
    2, att1, Lorem ipsum 1B
    2, att2,...
  10. Replies
    0
    Views
    752

    Intersect or except queries

    I've just posted a more specific question about the equivalent of EXCEPT clause for mysql, but I would like to get help on the right keywords to search for in order to learn how to perform...
  11. [RESOLVED] Equivalent of EXCEPT or MINUS clause in mysql

    Table = SUBSCRIBEDLISTS
    Fields = userid, listid
    (All users can subscribre to many lists)
    Example:
    1, 1 (user 1 subscribes to list 1)
    1, 2 (user 1 subscribes to list 2)
    1, 3 (user 1 subscribes...
  12. Replies
    0
    Views
    1,057

    3 tables join query ? (PHPList)

    Newbie question here for what I think requires a 3 table join query.

    I'm close, but I just can't seem to figure it out through search, wikis and howtos...

    My tables:

    USERS (pkey = id)...
  13. Replies
    0
    Views
    561

    PHPlist custom labels ?

    Hi,

    I am a TOTAL newbie to PHP. Using it mainly for a few forms handling (through purchached scripts) and managing our customers database with PHPlist. So far I've been successful installing and...
  14. Replies
    0
    Views
    1,128

    PHPlist custom labels ?

    Hi,

    I am a TOTAL newbie to PHP. Using it mainly for a few forms handling (through purchached scripts) and managing our customers database with PHPlist. So far I've been successful installing and...
  15. Yes I did and it works fine. Except when I used...

    Yes I did and it works fine. Except when I used the JOIN query, I was able to use the alias name (e.g. cust_city in this case) and the query worked fine. Now it seems like I can only use the...
  16. Thanks Jon, it works very elegantly :-) Now...

    Thanks Jon, it works very elegantly :-)

    Now if I pushed my luck and wanted to use a WHERE clause to find a subset of users, what would be the appropriate synthax ? I tried using:

    WHERE...
  17. I have a fairly simple join query (eventually a...

    I have a fairly simple join query (eventually a view) that I would like to be able to create. Here's a quick glance at my tables and fields:

    Table1: USERS
    Field1: id
    Field2: email
    (and a few...
  18. I already tried OR rather than AND, and the query...

    I already tried OR rather than AND, and the query seems to 'loop', it runs forever, not returning any results nor error message...
  19. Using AND in join query without limiting results ?

    Hi,

    I'm trying to build a join query between 2 tables using the following synthax:


    SELECT
    id,
    email,
    a1.value AS first_name,
    a2.value AS last_name,
  20. Replies
    2
    Views
    1,105

    Thank you so much NogDog, this is EXACTLY what...

    Thank you so much NogDog, this is EXACTLY what I've been looking for, for way too long before finding this forum! I can now understand the logic of my tables and query them as I please by trial and...
  21. Replies
    2
    Views
    1,105

    Join Query: Table with a list of attributes

    Hi, I'm fairly new to SQL, using MySQL 5 with PHP 4, and PHPList to be more specific. I am access my tables and creating queries directly using SQLyog client. Since I don't even no how to 'name' my...
Results 1 to 21 of 21
HTML5 Development Center



Recent Articles