Re: database hell
| From: | Ashley Sheridan | Date: | Thu, 12 Jul 2012 12:51:41 +0000 |
| Subject: | Re: database hell | ||
| References: | 1 2 3 4 5 6 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-318443@lists.php.net to get a copy of this message | ||
"marco@behnke.biz" <marco@behnke.biz> wrote:
>
>
>
>Nick Edwards <nick.z..edwards@gmail.com> hat am 12. Juli 2012 um 14:00
>geschrieben:
>
>> On 7/12/12, Gibbs <linux@danielgibbs.net> wrote:
>>
>> > mysql_query("DELETE from userprefs where clientr='$User'",
>$connmy);
>
>
>Sidenote: And don't forget to validate user input and make use of mysql
>escape
>and prepared statements ;)
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
Another way if the access credentials are the same would be to specify the full 'path' to
the table in the query:
DELETE FROM database.table WHERE clause
Thanks,
Ash
http://ashleysheridan.co.uk