Re: [PHP] database hell

2012-07-16 Thread Ressy
On 15/07/2012 17:07, Nick Edwards wrote: On 7/12/12, Ashley Sheridan a...@ashleysheridan.co.uk wrote: ma...@behnke.biz [5] ma...@behnke.biz [6] wrote: Nick Edwards nick.z.edwa...@gmail.com [2] hat am 12. Juli 2012 um 14:00 geschrieben: On 7/12/12, Gibbs li...@danielgibbs.net [1]

Re: [PHP] database hell

2012-07-15 Thread Nick Edwards
On 7/12/12, Ashley Sheridan a...@ashleysheridan.co.uk wrote: ma...@behnke.biz ma...@behnke.biz wrote: Nick Edwards nick.z.edwa...@gmail.com hat am 12. Juli 2012 um 14:00 geschrieben: On 7/12/12, Gibbs li...@danielgibbs.net wrote: mysql_query(DELETE from userprefs where clientr='$User',

Re: [PHP] database hell

2012-07-12 Thread Gibbs
On 12/07/12 12:29, Nick Edwards wrote: Hi We have a program that manages users, throughout all database calls created as: $connect = mysql_connect($db_host--other variables); mysql_query(Delete from clients where id=$User); All this works good, but, we need, in the delete function to delete

Re: [PHP] database hell

2012-07-12 Thread Nick Edwards
On 7/12/12, Gibbs li...@danielgibbs.net wrote: On 12/07/12 12:29, Nick Edwards wrote: Hi We have a program that manages users, throughout all database calls created as: $connect = mysql_connect($db_host--other variables); mysql_query(Delete from clients where id=$User); All this works

Re: [PHP] database hell

2012-07-12 Thread Stuart Dallas
On 12 Jul 2012, at 12:29, Nick Edwards wrote: We have a program that manages users, throughout all database calls created as: $connect = mysql_connect($db_host--other variables); mysql_query(Delete from clients where id=$User); All this works good, but, we need, in the delete function to

RE: [PHP] database hell

2012-07-12 Thread Adam Nicholls
-Original Message- From: Nick Edwards [mailto:nick.z.edwa...@gmail.com] Sent: 12 July 2012 12:30 To: php-general@lists.php.net Subject: [PHP] database hell Hi We have a program that manages users, throughout all database calls created as: $connect =

Re: [PHP] database hell

2012-07-12 Thread Gibbs
On 12/07/12 12:38, Nick Edwards wrote: On 7/12/12, Gibbs li...@danielgibbs.net wrote: On 12/07/12 12:29, Nick Edwards wrote: Hi We have a program that manages users, throughout all database calls created as: $connect = mysql_connect($db_host--other variables); mysql_query(Delete from clients

Re: [PHP] database hell

2012-07-12 Thread Nick Edwards
On 7/12/12, Adam Nicholls adam.nicho...@hl.co.uk wrote: -Original Message- From: Nick Edwards [mailto:nick.z.edwa...@gmail.com] Sent: 12 July 2012 12:30 To: php-general@lists.php.net Subject: [PHP] database hell Hi We have a program that manages users, throughout all database

Re: [PHP] database hell

2012-07-12 Thread Nick Edwards
On 7/12/12, Gibbs li...@danielgibbs.net wrote: $connmy=mysql_connect(host,user,pass, TRUE); http://php.net/manual/en/function.mysql-connect.php Thanks, will give that a shot I forgot to add your queries will need the new link too. So mysql_query(DELETE from userprefs where

Re: [PHP] database hell

2012-07-12 Thread ma...@behnke.biz
Nick Edwards nick.z.edwa...@gmail.com hat am 12. Juli 2012 um 14:00 geschrieben: On 7/12/12, Gibbs li...@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

Re: [PHP] database hell

2012-07-12 Thread Ashley Sheridan
ma...@behnke.biz ma...@behnke.biz wrote: Nick Edwards nick.z.edwa...@gmail.com hat am 12. Juli 2012 um 14:00 geschrieben: On 7/12/12, Gibbs li...@danielgibbs.net wrote: mysql_query(DELETE from userprefs where clientr='$User', $connmy); Sidenote: And don't forget to validate user input