Professional Web Applications Themes

MySql temporary tables - PHP Development

I did this blog where I create a temporary table to store entries while editing them (spell checking, preview, etc). The problem I was having is that sometimes the temporary table is created sometimes not. For every transaction with MySql I used mysql_pconnect(). Since I changed to using mysql_connect and regular tables instead of temporary tables everything seems to work fine, has anyone experienced problems with temporary tables with MySql? ____ Regards, Andu Novac...

  1. #1

    Default MySql temporary tables

    I did this blog where I create a temporary table to store entries while editing
    them (spell checking, preview, etc). The problem I was having is that sometimes
    the temporary table is created sometimes not. For every transaction with MySql I
    used mysql_pconnect(). Since I changed to using mysql_connect and regular tables
    instead of temporary tables everything seems to work fine, has anyone experienced
    problems with temporary tables with MySql?

    ____
    Regards, Andu Novac
    Andu Guest

  2. #2

    Default Re: [PHP] MySql temporary tables

    On Monday 15 September 2003 10:26, andu wrote:
    > I did this blog where I create a temporary table to store entries while
    > editing them (spell checking, preview, etc). The problem I was having is
    > that sometimes the temporary table is created sometimes not. For every
    > transaction with MySql I used mysql_pconnect(). Since I changed to using
    > mysql_connect and regular tables instead of temporary tables everything
    > seems to work fine, has anyone experienced problems with temporary tables
    > with MySql?
    Temporary tables are only accessible from the MySQL connection that created
    them. Using pconnect it was a crap shoot as to whether you would get the
    same connection on the next page load.

    Temporary tables should only be used (from within PHP) for the current page
    view.

    -Jackson
    >
    > ____
    > Regards, Andu Novac
    --
    jackson miller

    cold feet creative
    615.321.3300 / 800.595.4401
    [email]jacksoncoldfeetcreative.com[/email]


    cold feet presents Emma
    the world's easiest email marketing
    Learn more [url]http://www.myemma.com[/url]
    Jackson Miller Guest

Similar Threads

  1. cf 7 and mysql 5 stored procedures and temporary tables
    By gnurulz in forum Coldfusion Database Access
    Replies: 2
    Last Post: December 10th, 02:58 AM
  2. Handling temporary tables in Informix
    By Suket in forum Informix
    Replies: 4
    Last Post: September 5th, 07:17 AM
  3. Temporary Tables
    By Phil Jackson in forum IBM DB2
    Replies: 2
    Last Post: August 22nd, 05:05 AM
  4. global temporary tables
    By Blair Adamache in forum IBM DB2
    Replies: 0
    Last Post: July 31st, 07:44 PM
  5. Temporary tables visible to all sessions
    By Konstantin Kudin in forum Oracle Server
    Replies: 3
    Last Post: July 10th, 11:28 PM

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