List:General Discussion« Previous MessageNext Message »
From:Joel Palenychka Date:July 13 1999 6:30pm
Subject:Using mysql with php3 for first time
View as plain text  
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 ))  ---
Thread
Using mysql with php3 for first timeJoel Palenychka13 Jul
  • Re: Using mysql with php3 for first timeJoel Palenychka14 Jul