pan wrote: > >Ah, sorry I didn't make it terribly clear. I meant that I only ever get > >a maximum of 255 chars returned. > > O.K. - then that makes it seem a truncation problem and not a > data definition problem. > > minor thing: in edit_exam_question.php there is > " print '<a align="left">Select Correct Answer:<br>'; " > > What's the <a tag? I don't know that one :)
It's a new tag I just invented :-) > You might want to add the 'readonly' attritbute to > that textarea - lessens chance of unwanted post variables. > You seem to be using that textarea only for displaying the > retrieved question_text These pages are for the "admin" user to be able to edit/delete any question or possible answers, As such I left the text area rw so that they could change it. > Either one of the unknown queries in edit_exam_question.inc > is truncating the data or the url parameter is truncated, or > dbconn.inc is the culprit. dbconn.inc only holds servername, username and password. I've attached it and the other missing file to this message - with differing passwords of course :-) > Three chances at answering the problem, not enough data. > Except for the url parameter passing - but only id and > question_id get passed so no chance on the parameter formatting Yes, I thought I'd keep url passing down to a minimum and only ever pass record id's. > ooops ... files attached only reiterate the problem and do not serve to > further illuminate the path to happiness. I've attached the two missing files, so this should help to diagnose what I've stuffed up. -- Rgds, Chris MacKenzie Windows: "Where do you want to go today ?" Mac OS: "Where do you want to be tomorrow ?" Linux: "Are you coming or what ?"
<?php include('dbconn.inc'); $sql="SELECT * FROM tbl_exam_questions WHERE question_id=$question_id;"; $sql1="select * from tbl_exam_answers WHERE question_id=$question_id order by id;"; $result=mssql_query($sql,$conn1); if(!$result) { print "No Records Found.<BR><BR>"; mssql_close($conn1); exit; } $result1=mssql_query($sql1,$conn1); if(!$result) { print "No Records Found.<BR><BR>"; mssql_close($conn1); exit; } # Can't seem to find a good way to copy the returned array # so I'll use a kludge and just re-submit the query. # There must be a better way, but I'm pressed for time :-( $result2=mssql_query($sql1,$conn1); if(!$result) { print "No Records Found.<BR><BR>"; mssql_close($conn1); exit; } $numrows = mssql_num_rows($result); $numrows1 = mssql_num_rows($result1); # $numrows2 = mssql_num_rows($result2); # # It doesn't matter if no rows are found as an empty table will be # presented to the web browser, which looks better than some # ugly text based error message anyway. # #if(!$numrows) { # print "Cannot load data into array.<BR>"; # mssql_close($conn1); # exit; #} ## TODO # I might add some code to alternate the background colour of the table cells # from a light grey and white to make it easier to read the table when a large # amount of data is returned or the page is printed to a hardcopy. $row = mssql_fetch_array($result); ?>
<?php $dbservername = "blp008"; $dbname = "entry_exam"; $dbusername = "someuser"; $dbpassword = "somepasswd"; $conn1=mssql_pconnect($dbservername,$dbusername,$dbpassword); if(!$conn1) { print "Cannot Connect to SQL Server. Please contact your system administrator."; exit; } $result=mssql_select_db($dbname,$conn1); if(!$result) { print "Cannot Select SQL Database.<BR>"; mssql_close($conn1); exit; } ?>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php