List:General Discussion« Previous MessageNext Message »
From:Joel Palenychka Date:July 14 1999 3:35pm
Subject:Re: Using mysql with php3 for first time
View as plain text  
My apologies to the list for this question. Turns out the error was
mine. mysql_error returns a truncated error message, which I incorrectly
interpreted as a truncated query string. Turns out my query string has
some other parsing error. 

At least the subject line was appropriate. :-)

Joel Palenychka wrote:
> 
> This is my first time using mysql with php3, and I've hit something that
> I want some confirmation on.
> 
> I'm attempting to use the php3 function:
>         $result = mysql_db_query("scene", $query);
> 
> This works for small query strings, but when I get beyond 80 characters
> in the query it appears to get truncated, resulting in a parsing error
> of course.
> 
> I've tried embedding '\n' characters in the hopes that perhaps mysql
> will interpret the query as a multi-line query, but no luck. I know this
> isn't a limitation of the $query variable in php3 as I am able to echo
> the whole query back to me. Is this a known limitation of mysql and is
> there some way to fix/get around it? Or am I doomed to limit my queries
> to 80 characters?
> 
> Many thanks in advance,
> Joel Palenychka
> 
> --
> ---
> ---
> 
> "[We] are paralyzed by the fact that cruelty is often amusing."
>         - Douglas Coupland
> 
> --- (palenychka@stripped) (( http://members.home.net/palenychka ))  ---
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread7183@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.

-- 
---                                                                   
---

"[We] are paralyzed by the fact that cruelty is often amusing."
	- Douglas Coupland

--- (palenychka@stripped) (( http://members.home.net/palenychka ))  ---
Thread
Using mysql with php3 for first timeJoel Palenychka13 Jul
  • Re: Using mysql with php3 for first timeJoel Palenychka14 Jul