Hi,
I have a printer friendly page that is passed a url param from the detail
page. On the detail page I have a series of questions that appear as they
should. However when I go to the printer friendly page I'm missing the
first question. I get all the others. I can't seem to find a reason for
this.
The printer friendly page has a single condition that takes the url param
and branches to the appropriate sql statement. The sql statements are
almost identical.
if($_SESSION['id'] == 4){
$query = "SELECT convert(text,questions) as questions, qt_topics
FROM SG_Questions as q, SG_Topics as t
WHERE q.qt_id = t.qt_id AND q.qt_id = '$ques'";
$result = MSSQL_QUERY($query) or die("Can not execute query
$query. ");
$myrow = mssql_fetch_array($result);
$topic = $myrow['qt_topics'];
[snip]...
while($row = mssql_fetch_array($result))
{
$question = $row['questions'] ;
echo "<tr><td>$question</td></tr>\n";
}
[snip]...
mssql_close();
}
else{
$query = "SELECT convert(text, questions) as questions, sg_aof
FROM SG_Questions as q, SG_AOF as a
WHERE q.sg_id = a.sg_id AND a.sg_id = '$focus'";
$result = MSSQL_QUERY($query) or die("Can not execute query
$query. ");
$myrow = mssql_fetch_array($result);
$topic = $myrow['sg_aof'];
[snip]...
while($row = mssql_fetch_array($result))
{
$question = $row['questions'] ;
echo "<tr><td>$question</td></tr>\n";
}
[snip]...
mssql_close();
}
alex
******************************************************************
The contents of this e-mail and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom it is addressed. The views stated herein do not
necessarily represent the view of the company. If you are not the
intended recipient of this e-mail you may not copy, forward,
disclose, or otherwise use it or any part of it in any form
whatsoever. If you have received this e-mail in error please
e-mail the sender.
******************************************************************
