[PHP-DB] Tricky MySQL / php Script

2004-08-18 Thread Vern
I have a bunch of thumbnails that are pulled from a recordset based on a user profile. Each thumbnail opens the picture into another page so that the picture is larger and I want to now have that user's pictures accessible by clicking a previous and/or next arrow. The first recordset of

Re: [PHP-DB] Tricky MySQL / php Script

2004-08-18 Thread Peter Ellis
I assume you mean the 1052367746 portion of that URL? Am I right? If so: $id = basename($photoid, .jpg); That would work, I think, if you just wanted the numeric portion of the path. Not sure if this is what you want. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant

Re: [PHP-DB] Tricky MySQL / php Script

2004-08-18 Thread Vern
That's not what I mean at all. I actually have no idea where you got that from. :) Basically what I'm trying to say is this. The following is my url: mypage.php?photoID=uploads/1052367746.jpguserID=215 photoID = uploads/1052367746.jpg userID = 215 I want to point to a record in a

Re: [PHP-DB] Tricky MySQL / php Script

2004-08-18 Thread Peter Ellis
Ach, and the light bulb goes on. Sorry, wasn't really thinking about it completely earlier. Here's a less dimbrained suggestion: could you encode the user ID as part of the filename itself? Like, for instance, write the script so that it would read something like: blah.jpg.215 and strip off

Re: [PHP-DB] Tricky MySQL / php Script

2004-08-18 Thread Vern
Sorry but that doesn't make and sense either. I have no problems passing the variables along. Why are you trying to tag that to the image? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Tricky MySQL / php Script

2004-08-18 Thread Jason Wong
On Thursday 19 August 2004 09:23, Vern wrote: Basically what I'm trying to say is this. The following is my url: mypage.php?photoID=uploads/1052367746.jpguserID=215 photoID = uploads/1052367746.jpg userID = 215 I want to point to a record in a recordset. That records id is