Re: SQL Syntax..?
| From: | (Richard Lynch) | Date: | Wed, 12 Jul 2000 22:27:39 +0000 |
| Subject: | Re: SQL Syntax..? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-6319@lists.php.net to get a copy of this message | ||
In article <fc.006ad2e8001a54ff3b9aca00e8cbf680.1a551b@nxco.com>,
czelenak@nxco.com (Chris Zelenak) wrote:
,messages.message,SUBSTRING(messages.message,IF((INSTR(messages.message,'".addslashes($phrase)."')-12)<0,INSTR(messages.message,'".addslashes($phrase)."')-12,0),".(strlen(addslashes($phrase))+24).")
> as a_message,
>
> That's just an extract from an SQL query I'm sending to MySQL. However,
> when I try to access $row["a_message"]; , it returns nothing.
Are you doing error_checking on the return value from mysql_query()?
--
Richard Lynch | If this was worth $$$ to you, buy a CD
US Customer Support Director | from one of the artists listed here:
Zend Technologies USA | http://www.L-I-E.com/artists.htm
http://www.zend.com | (this has nothing to do with Zend,
duh!)