1. 

   jtannous Guest

   Messages:

   8

   Likes Received:

   1

   Best Answers:

   0

   Trophy Points:

   0

   #1

   I would like to do something like this:
   

   $file = mysqli_fetch_assoc($mysqli->query("SELECT id,size,file,pas_prot,name FROM files WHERE substr(md5(id),0,7)='$id' LIMIT 1"));

   PHP:

   Can anyone help me please?
   

    

   jtannous, Nov 8, 2011 IP
   
2. 

   mfscripts Banned

   Messages:

   319

   Likes Received:

   4

   Best Answers:

   8

   Trophy Points:

   90

   Digital Goods:

   3

   #2

   Try MID() within MySQL:
   
   http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_mid

    

   mfscripts, Nov 9, 2011 IP

• Log in with Facebook

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in