Professional Web Applications Themes

ESTRAZIONE IMMAGINI - MySQL

Hi everyone!I havo to extract the images from a table in mysql.. I'm using the query SELECT * FROM img WHERE id = '.$_GET['id']; but it doesn't work..what's wrong? Thank you!...

  1. #1

    Default ESTRAZIONE IMMAGINI

    Hi everyone!I havo to extract the images from a table in mysql.. I'm
    using the query

    SELECT * FROM img WHERE id = '.$_GET['id'];

    but it doesn't work..what's wrong?
    Thank you!

    sonia.cotroneo@gmail.com Guest

  2. #2

    Default Re: ESTRAZIONE IMMAGINI

    > SELECT * FROM img WHERE id = '.$_GET['id'];
    the query is invalid:
    $query="SELECT * FROM img WHERE id = '".$_GET['id']."'";

    and you should not use $_GET['id'] without any validation for security
    reason.

    regards,
    R


    aaooo54 Guest

  3. #3

    Default Re: ESTRAZIONE IMMAGINI

    On 24 Jul, 15:17, com wrote: 

    For future reference, the statement "it doesn't work" is about as
    useful as a chocolate teapot!

    Next time include details of the error that you are getting.

    Captain Guest

  4. #4

    Default Re: ESTRAZIONE IMMAGINI

    On Tue, 24 Jul 2007 16:56:36 +0200, aaooo54 <onet.pl> wrote: 
    > the query is invalid:
    > $query="SELECT * FROM img WHERE id = '".$_GET['id']."'";[/ref]

    Unless it's an integer...
     

    Very true.

    OP: impossible to say, echo mysql_error() to see what's wrong.
    --
    Rik Wasmus
    Rik Guest

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