Professional Web Applications Themes

Update from a select - PHP Development

PHP + MYSQL. I've a table of articles in my database. in this table they are 2 fields: CounterLogResult and CounterClick Any user may search articles with some fields (a common search form). I would like that every time the article is in the result of the query, the CounterLogResult value is incremented. If the user click on the article (for seeing the details of a result), the counterClick is incremented. I know how to increment CounterClick (this is very easy), but how to increment CounterLogResult ??? Something like: Update Announce SET CounterLogResult = CounterLogResult+1 Where Announce.IDArticle in (Select IDArticle ...

  1. #1

    Default Update from a select

    PHP + MYSQL.

    I've a table of articles in my database.
    in this table they are 2 fields: CounterLogResult and CounterClick

    Any user may search articles with some fields (a common search form). I
    would like that every time the article is in the result of the query, the
    CounterLogResult value is incremented. If the user click on the article (for
    seeing the details of a result), the counterClick is incremented. I know how
    to increment CounterClick (this is very easy), but how to increment
    CounterLogResult ???

    Something like:
    Update Announce SET CounterLogResult = CounterLogResult+1 Where
    Announce.IDArticle in (Select IDArticle FROM Article WHERE Article.price >
    30 LIMIT 0,10);

    That's because the select query for my page returns only 10 results at one
    time. (in fact the Select is the same I use for showing the result of the
    form fields).

    BoB


    Bob Bedford Guest

  2. #2

    Default Re: Update from a select

    On Thu, 15 Jan 2004 18:46:00 +0100, "Bob Bedford"
    <bedford1YouKnowWhatToDohotmail.com> wrote:
    >PHP + MYSQL.
    >
    >I've a table of articles in my database.
    >in this table they are 2 fields: CounterLogResult and CounterClick
    >
    >Any user may search articles with some fields (a common search form). I
    >would like that every time the article is in the result of the query, the
    >CounterLogResult value is incremented. If the user click on the article (for
    >seeing the details of a result), the counterClick is incremented. I know how
    >to increment CounterClick (this is very easy), but how to increment
    >CounterLogResult ???
    >
    >Something like:
    >Update Announce SET CounterLogResult = CounterLogResult+1 Where
    >Announce.IDArticle in (Select IDArticle FROM Article WHERE Article.price >
    >30 LIMIT 0,10);
    >
    >That's because the select query for my page returns only 10 results at one
    >time. (in fact the Select is the same I use for showing the result of the
    >form fields).
    Production versions of MySQL don't yet support subqueries, only the beta
    versions.

    Execute the subquery separately then do an update per row returned.

    --
    Andy Hassall <andyandyh.co.uk> / Space: disk usage ysis tool
    <http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>
    Andy Hassall Guest

Similar Threads

  1. Can't select Acrobat Pro for update 8.1.2
    By Patrick_Tigue@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 3
    Last Post: October 22nd, 05:22 PM
  2. Select-And-Update in one statement?
    By Ignoramus23298 in forum MySQL
    Replies: 1
    Last Post: May 19th, 07:02 PM
  3. Select, Edit, Update Issue
    By Michael D. Murphy in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: January 29th, 09:52 PM
  4. update from select
    By Gary Stainburn in forum PERL Beginners
    Replies: 2
    Last Post: October 29th, 04:51 PM
  5. Update and Select Statement
    By hngo01 in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 4th, 01:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139