From: "James Johnson" <[EMAIL PROTECTED]>
> I have a list contained in a session var. I want to loop through the list,
> getting the value of the current item, then do a query based on that
value.
> Is there an easy way to do this, or do I need to convert the list to an
> array first? In the code below, $id isn't being set.
>
> Here's my code (this is just testing stuff, sv_CampusList is set somewhere
> else):
> <?php
> session_start();
> $_SESSION['sv_CampusList'] = "1,2,4,5";
> for($i=1; $i<=strlen($_SESSION['sv_CampusList']); $i++){
> $id = strpos($_SESSION['sv_CampusList'],$i);
> echo $id;
> }
> ?>
What are you actually trying to accomplish here? I could tell you how to
loop through a list in a string and run a query for each number, but I'd
have the horrible feeling that you're using some inefficient method to
accomplish something.
For instance, if you're just trying to select data matching the numbers in
your list, you can do this:
$query = "SELECT * FROM Table WHERE campus_list IN
({$_SESSION['sv_CampusList']})";
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
