Re: mysql question #2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, February 10, 2008 12:12 pm, nihilism machine wrote:
> 	public function select_one($sql) {

> 		if ($this->auto_slashes) {
> 			return stripslashes($ret);

If you have to call stripslashes() on data coming FROM MySQL, then you
have really messed up...

You've put in data that was escaped TWICE, probably with Magic Quotes
"ON" followed by addslashes (or mysql_real_escape_string).

At any rate, just seeing this tells me that you've got a real mess on
your hands...

> 		} else {
> 			return $ret;
> 		}
> 	}
>
> how can i get the contents of a column in the returned row say for
> something called "Email" as the column name. here is my code now:

Since it's only returning ONE piece of data, how confused can it be?

$this->whatever['Email'] = $result;

-- 
Some people have a "gift" link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/from/lynch
Yeah, I get a buck. So?

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux