on page one do this instead.
<?php
session_start();
if(isset($_POST['Submit'])) {
$_SESSION['sv_CampusList']= "'".implode( "', '", $_POST['campus'] )."'";
header("Location: " . "search.php");
exit;
}
?>
Jim Lucas
----- Original Message -----
From: "James Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 11, 2003 1:29 PM
Subject: RE: [PHP] Array to List
> All,
>
> Thanks for your help, but this shouldn't be so freaking hard to do. <sigh>
>
> 1) I have a multiple select input on one page that is populated with a
list
> of campuses. The user selects which campus(es) to search on.
> 2) the user submits the form and goes to the next page.
> 3) I want a list of the selected campus(es) at the top of the page
>
> Page 1
> **** user sees this ****
> Select Campus(es)
> -------------------
> Cal State San Bernardino
> University of Redlands
> University of California, Riverside
> Universtiy of California, San Diego
> *************************
> -- code --
> <?php session_start();?>
> <?php
> if(isset($_POST['Submit'])){
> $_SESSION['sv_CampusList']= implode( ', ', $_POST['campus'] );
> header("Location: " . "search.php");
> exit;
> }
> ?>
>
> Page 2
> <?php session_start();?>
> <?php require_once('Connections/CCB.php'); ?>
> <?php
> $cList = $_SESSION['sv_CampusList'];
> mysql_select_db($database_CCB, $CCB);
> $query_GetCampuses = "SELECT * FROM campuses WHERE inst_id IN
> ($cList) ORDER BY name ASC";
> $GetCampuses = mysql_query($query_GetCampuses, $CCB) or
> die(mysql_error());
> $row_GetCampuses = mysql_fetch_assoc($GetCampuses);
> $totalRows_GetCampuses = mysql_num_rows($GetCampuses);
> $c = implode( ', ', $row_GetCampuses );
> echo $c;
> ?>
>
> <table>
> <tr><td>Campuses: <?php echo $c; ?></td></tr>
>
> ***** user is supposed to see this *****
> Campuses: Cal State San Bernardino, University of Redlands
>
> I did check the MySQL table and inst_id is an integer. When playing around
> with the Query in PhpMyAdmin, I found that I needed to surround the values
> in the IN clause with single quotes.
>
> Perhaps I'm going about this the wrong way. Any advice or suggestions
would
> be appreciated.
> Thanks,
> James
> -----Original Message-----
> From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 11, 2003 1:12 PM
> To: James Johnson; 'Chris Boget'; [EMAIL PROTECTED]
> Subject: Re: [PHP] Array to List
>
>
> From: "James Johnson" <[EMAIL PROTECTED]>
>
> > Actually, I'm using $campusList for a SQL statement:
> >
> > SELECT name FROM campuses WHERE inst_id IN ('$campusList');
> >
> > It wasn't working until I found out that $campusList needs to look
> > like '1','2','3'.
> >
> > $campusList = implode( ', ', $_POST['campus'] );
> >
> > Returns 4,2,3 (whatever was selected)
> >
> > I've looked in the manual on implode, but don't see how to surround
> > each value with single quotes. Is there another function that will do
> > this?
>
> You don't need the quotes if the values are integers, but if you insist...
>
> $campusList = "'" . implode("','",$_POST['campus']) . "'";
>
> The implode "pattern" is a single quote, comma, single quote, then
surround
> the whole implode result by single quotes to complete it.
>
> ---John Holmes...
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
