My first php program

I am using ADODB "http://adodb.sourceforge.net/" to get $results.

i then use

foreach ($results as result) {




}

now i need to parse a $result['value1'] in a $_SESSION['value1'] that
needs to be used in another select statement.

i cant use ?>
because that just stores the last "value1" into $_SESSION.
and the same goes for

any ideas im going crazy here :(

Re: My first php program

spacerat wrote:
> I am using ADODB "http://adodb.sourceforge.net/" to get $results.
>
> i then use
>
> foreach ($results as result) {
>
>
>
>
> }
>
> now i need to parse a $result['value1'] in a $_SESSION['value1'] that
> needs to be used in another select statement.
>
> i cant use > ?>
> because that just stores the last "value1" into $_SESSION.
> and the same goes for
>
> any ideas im going crazy here :(

You're not making a great deal of sense here.

First of all the "foreach ($results as result) {" would not work as it
should be "foreach ($results as $result) {"

Next the code would not output "" or "" as these are within
part of the php parsing (assuming that the foreach is part of it).
Leading on from that the "" shouldn't be there,
as it is already being executed by php.

Finally you say " i cant use $result['value1']; ?> because that just stores the last "value1"
into $_SESSION."
But you only said that you wanted to store "a" $result['value1'] and
the last one is as much a $result['value1'] as any other one. You then
go on to say that it is the same for $result[0]['value1']. The only way
that this can be true is if there is only one result row.

So how about thinking about this and telling us precisely what you want
to achieve?

Re: My first php program

forgive me for my ambuguity

by actual code is as follows


======START=====

require_once ('./includes/site_globals.inc.php');

$subject = $_SESSION['Subject'];
$year = $_SESSION['Year'];
$semester = $_SESSION['Semester'];

//Get all classes for a given subject , in an occurance of a
year/semester

$results = $db->GetAll("SELECT *
FROM classcode c
WHERE subject = '$subject' AND year = '$year' AND semester =
'$semester'");


?>

Re: My first php program

umm sorry.

somehow i managed to fix the bugger.