Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
Thread: Showing users with photos only
09-01-2002, 08:46 PM #1
Showing users with photos only
I'm not sure how to do this. I'm suing php with mysql, and in the photo field, it showing the info as /tmp/dsws etc. I've tried:
SELECT `id`,`username`,`photo` FROM `members` WHERE `photo` LIKE '%/tmp/' LIMIT 0, 30
But it shows no results. What am I doing wrong?
09-03-2002, 08:16 AM #2
- Join Date
- Jun 2002
- Thanked 0 Times in 0 Posts
if the string you are trying to match is something like '/tmp/dsws' then your wildcard needs to be at the end. '/tmp/%' instead of at the beginning.
09-03-2002, 01:45 PM #3
Thank you I never used wildcards before and phpMyAdmin put the % at the front, so that's where I thought it went It works now