Re: [PHP-DB] Connecting PHP to MySQL on Windows

2011-01-07 Thread Gavin Chalkley
Mike, A plain HOST file should have the commented part at the top, and only 1 reference to localhost unless you are creating Virtual hosts. I would suggest removing the ::1 line BR Gavin On Fri, Jan 7, 2011 at 4:18 AM, michael manning michaelgmann...@gmail.comwrote: Hi, I swapped out

[PHP-DB] PHP.ini file

2011-04-30 Thread Gavin Chalkley
Afternoon all. I have a dev server using XAMPP, and am wondering if somone could point how to add a custom php.ini file? I have the ability to do this on the live server but am unsure how to make this read on the dev server? -- Best regards, Gavin C -- PHP Database Mailing List

Re: [PHP-DB] PHP.ini file

2011-05-02 Thread Gavin Chalkley
suggest making a backup of your existing php.ini file first. Regards, Barry On Sat, Apr 30, 2011 at 4:27 AM, Gavin Chalkley gavin.chalk...@gmail.com wrote: Afternoon all. I have a dev server using XAMPP, and am wondering if somone could point how to add a custom php.ini file? I have

Re: [PHP-DB] ORDER BY DESC

2011-06-20 Thread Gavin Chalkley
Chris, Try this: http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html On 20 June 2011 20:56, Chris Stinemetz chrisstinem...@gmail.com wrote: I have the bellow sql query. What is the correct way to add ORDER BY posts.post_date DESC I would like to add it to the end of my query,

Re: [PHP-DB] Insert query error

2011-08-06 Thread Gavin Chalkley
Chris, Why not escape, and extract the data prior to Insert string? On 06/08/2011 05:41, Chris Stinemetz wrote: I am getting the following error trying to run the below query. Any suggestions on what I am doing wrong? Thank you, Something went wrong while inserting your store visitCannot add

Re: [PHP-DB] Learning bound variables ??

2011-08-29 Thread Gavin Chalkley
Dian, I appreciate what it does and understand the redirect. What I am more refering to is the manner to which it is written On 29/08/2011 12:02, dian.armstr...@gmail.com wrote: It's redirect script on php. Cmiiw --Original Message-- From: Gavin Chalkley To: php-db@lists.php.net

Re: [PHP-DB] Learning bound variables ??

2011-08-29 Thread Gavin Chalkley
syntax it would be written as header(Location: . $referrer) regds amit The difference between fiction and reality? Fiction has to make sense. On Mon, Aug 29, 2011 at 4:33 PM, Gavin Chalkley gavin.chalk...@gmail.com mailto:gavin.chalk...@gmail.com wrote: Dian, I appreciate what

[PHP-DB] Mysqli_escape

2011-09-01 Thread Gavin Chalkley
Hey all, Just a quick question about escaping. Is it good practise to strip tags and trim prior to escaping? or is this just over the top? Cheers Gavin C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Prepared Statements

2011-11-15 Thread Gavin Chalkley
Hi all, I am struggerling with a prepared statement (may not even be suited) $stmt = $db-stmt_init(); if($stmt-prepare(SELECT title,live,where FROM content)) { $stmt-bind_param('sii',$t,$l,$w); ## This bit here $stmt-execute(); $stmt-bind_result($title,

RE: [PHP-DB] PHP Database Problems

2012-05-02 Thread Gavin Chalkley
Ethan, Some coding you are using would be helpful (as far as i am aware attachments are not support on the mailing list's) Gav -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: 02 May 2012 19:54 To: php-db-lists.php.net; php-gene...@lists.php.net Subject:

RE: [PHP-DB] [PHP] PHP Database Problems -- Code Snippets - Any more Ideas?

2012-05-04 Thread Gavin Chalkley
Ethan, You have been given advise and break down on your code. Have you taken the advise given? Which part of the code isn't working? Not which chunk, but break it down and show which part BR, Gav -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: 04 May

RE: [PHP-DB] Multiple Database Connection Using Prepard Statements

2012-05-20 Thread Gavin Chalkley
Just remember to close the correct connection whn it is time to :) -Original Message- From: Matijn Woudt [mailto:tijn...@gmail.com] Sent: 19 May 2012 23:42 To: Ron Piggott Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Multiple Database Connection Using Prepard Statements On Sat, May

Re: [PHP-DB] Saving Image in mySQL

2013-03-20 Thread Gavin Chalkley
I am with Karl on this. Storing an image in the db is very heavy on lpad times. Upload the image to a folder with name saved with location On Mar 19, 2013 11:12 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hey Ron, I don't know how others feel, but I say save yourself a headache and dont