Professional Web Applications Themes

Testing if a mysql table exists - PHP Development

Is there a simple way to test if a mysql table exists? JUST One line !...

Sponsored Links
  1. #1

    Default Testing if a mysql table exists

    Is there a simple way to test if a mysql table exists?
    JUST One line !


    Sponsored Links
    sam Guest

  2. #2

    Default Re: Testing if a mysql table exists

    On Fri, 17 Oct 2003 01:02:57 +0200, "sam" <rbaba99caramail.com> wrote:
    >Is there a simple way to test if a mysql table exists?
    >JUST One line !
    Depends how many commands you put on one line.

    $res = mysql_query("show table status like '$tablename'")
    or die(mysql_error());
    $table_exists = mysql_num_rows($res) == 1;

    --
    Andy Hassall (andyandyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
    Space: disk usage ysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])
    Andy Hassall Guest

Similar Threads

  1. Table exists?
    By liglin1 in forum Coldfusion Database Access
    Replies: 2
    Last Post: November 29th, 03:33 PM
  2. Check if table exists
    By Guy Rouillier in forum PostgreSQL / PGSQL
    Replies: 0
    Last Post: December 17th, 10:32 PM
  3. Testing if a value exists.
    By Andy Levy in forum PHP Development
    Replies: 3
    Last Post: October 30th, 11:03 AM
  4. Table Exists
    By TylerB in forum ASP Database
    Replies: 1
    Last Post: September 25th, 06:10 PM
  5. Testing whether a subroutine exists (symbolic ref)
    By Richard Voss in forum PERL Miscellaneous
    Replies: 5
    Last Post: September 4th, 12:25 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