[PHP-DB] Query from Hell (for me anyway)

2002-06-02 Thread Chris MacKenzie
tbl_student_details.study_mode = tbl_study_mode.id; Basically I'm after a query that returns student_id, name, the student study mode and their answer to question 19. Any help/clue stick whacks are most welcome ! :-) -- Rgds, Chris MacKenzie Windows: Where do you want to go today ? Mac OS: Where do you want

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-05-04 Thread Chris MacKenzie
receive the first 255 chars. What's the go here, is this just another microsoft thing ? -- 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 Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
Hi All, I've come across an interesting problem. I'm trying to retrieve some text data (in this case a question up to 400 chars), but each time I perform a select statement I only receive the first 255 chars. What's the go here, is this just another microsoft thing ? -- Rgds, Chris MacKenzie

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
pan wrote: From: Chris MacKenzie [EMAIL PROTECTED] I've come across an interesting problem. I'm trying to retrieve some text data (in this case a question up to 400 chars), but each time I perform a select statement I only receive the first 255 chars. What's the go here, is this just

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
that I only ever get a maximum of 255 chars returned. -- 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Maximum field length with PHP 4.1.2/MSSQL v7 ?

2002-04-27 Thread Chris MacKenzie
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

[PHP-DB] Submitting Dynamic Form

2002-04-03 Thread Chris MacKenzie
? :-/ -- 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php