[PHP-DB] Random pick

2009-12-14 Thread David McGlone
Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month and I'm wondering if this can be accomplished with just a mysql query or would I

Re: [PHP-DB] Random pick

2009-12-14 Thread David McGlone
On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month

Re: [PHP-DB] Random pick

2009-12-15 Thread David McGlone
On Monday 14 December 2009 21:44:24 Chris wrote: Chris wrote: David McGlone wrote: On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise

Re: [PHP-DB] Random pick

2009-12-21 Thread David McGlone
PM, David McGlone wrote: On Monday 14 December 2009 21:44:24 Chris wrote: Chris wrote: David McGlone wrote: On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need

Re: [PHP-DB] Upgrading PHP Version 5.1.6

2010-03-05 Thread David McGlone
On Friday 05 March 2010 12:35:43 Vinay Kannan wrote: Hello, I am currently using php version 5.1.6 and now m thinking of upgrading, i got php installed long time back using WAMP, i wanted to know if theres an easy way to upgrade directly, without having to remove this version, i also have

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-03-14 Thread David McGlone
I would love to see something like this. Something like this would build confidence for me. -- Blessings David M. I have been driven to my knees many times by the overwhelming conviction that I had nowhere else to go. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-03-14 Thread David McGlone
On Sunday 14 March 2010 12:26:13 Johnny Mac wrote: I'm wondering how this would work? How would the person giving the presentation do it on a mailing list or forum or whatever else there could be? I would be interested. Sounds good Johnny Mac -Original Message- From: nagendra

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-03-14 Thread David McGlone
On Sunday 14 March 2010 20:02:01 you wrote: well sounds interesting. It will be on a forum/blog/maillist or something Well if we could get a plan together, I can provide the forum or mailing list or blog. like that. 2010/3/15 David McGlone da...@dmcentral.net On Sunday 14 March 2010 12

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-03-15 Thread David McGlone
Hi David, I am glad that you are in. However don't worry about the presentation stuff. If you Google Online free presentation, you will find your answer. So, Guys lets start making some plan. I have created a Google spreadsheet. Please put your Ideas and topics about the meeting. Here

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-03-18 Thread David McGlone
I think we should either consider audio or video Audio would make it impossible for the hearing impaired :-( -- Blessings David M. I have been driven to my knees many times by the overwhelming conviction that I had nowhere else to go. -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-03-19 Thread David McGlone
http://www.youtube.com/watch?v=y2c_S_90Syc /sob it took me 2 hours to build this decent tutorial please have look on my work *that's include the subtitle (english) I don't do dubbing.. sry This was very nice. I liked the subtitles. -- Blessings David M. I have been driven to my knees

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-03-19 Thread David McGlone
perhaps u can editing.. u perhaps not have something to share.. but you can give something like.. comment or anything that helpfull How does a tutorial on setting up and using SMARTY sound? I use SMARTY in a lot of my projects and could probably give a tutorial on that. -- Blessings David

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-03-19 Thread David McGlone
that's good idea u have another tutorial to share? Not at the moment. I'll start with SMARTY and as things progress, I'll add more. How does that sound? I'll can also give a tutorial on using PEAR with SMARTY. On Fri, Mar 19, 2010 at 7:02 PM, David McGlone da...@dmcentral.net wrote

Re: [PHP-DB] how to upgrade php in linux

2010-05-03 Thread David McGlone
On Monday 03 May 2010 07:02:35 Chaitanya Yanamadala wrote: Hai i have installed php in the cent os 5.4. the one which is installed is 5.1.6 now what i want to do is upgrade it to latest one 5.3.2, as i am new to linux environment it is quite hard for me to configure that, can any one guide

Re: [PHP-DB] Re: ezmlm warning

2010-11-05 Thread David McGlone
On Fri, 2010-11-05 at 06:58 -0500, Karl DeSaulniers wrote: Hi, Can anyone admin please explain this to me? I received one myself. -- Blessings, David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] extracting id from db from a form field

2011-05-27 Thread David McGlone
Hello everyone, I need a little help. I've never tried to extract from a db in the manner I'm trying. It's pretty simple and straightforward I believe, but for some reason I can't figure out how. What I have is a form with 1 simple field, and this field takes the ID of the row I want returned.

Re: [PHP-DB] extracting id from db from a form field

2011-05-27 Thread David McGlone
On Fri, 2011-05-27 at 14:48 -0500, Karl DeSaulniers wrote: Hi David, Try this.. if(!isset($_POST['ErrorCode'])) { die('You did not enter an error code!'); } else { $errorcode = $_POST['ErrorCode']; $sql = mysql_query(SELECT * FROM Sheet1 WHERE errorcode='. $errorcode.'

[PHP-DB] sqlite

2011-11-28 Thread David McGlone
Hi everyone, I've never fooled with sqlite before and I'm trying to do a simple query on an sqlite db, but I don't seem to be doing anything correct. I can't figure out how to just simply open a db file in the directory and query it and echo back the contents. Here's some code I've been messing

Re: [PHP-DB] sqlite

2011-11-29 Thread David McGlone
On Tue, 2011-11-29 at 16:31 -0600, Tamara Temple wrote: David McGlone da...@dmcentral.net wrote: places.sqlite is mozilla's bookmarks db and I was trying to read this db, but so far I've been unsuccessful. sqlite ver: 2.8.17 PHP version: PHP 5.3.3-1ubuntu9.6 with Suhosin-Patch php5

[PHP-DB] Abstraction library

2011-12-30 Thread David McGlone
Hi everyone I got a quick question. I'm wondering if anyone is using a DB abstraction layer such as PEAR DB. I've used PEAR DB in the past and knew it's been on it's way to extinction, but never looked into alternatives or any other way to replace it. Now this has come back to bite me in the rear

Re: [PHP-DB] Abstraction library

2011-12-30 Thread David McGlone
On Fri, 2011-12-30 at 12:27 +, Lester Caine wrote: David McGlone wrote: Hi everyone I got a quick question. I'm wondering if anyone is using a DB abstraction layer such as PEAR DB. I've used PEAR DB in the past and knew it's been on it's way to extinction, but never looked

Re: [PHP-DB] Abstraction library

2011-12-30 Thread David McGlone
On Fri, 2011-12-30 at 11:23 -0500, David McGlone wrote: On Fri, 2011-12-30 at 12:27 +, Lester Caine wrote: David McGlone wrote: Hi everyone I got a quick question. I'm wondering if anyone is using a DB abstraction layer such as PEAR DB. I've used PEAR DB in the past and knew it's

Re: [PHP-DB] Abstraction library

2011-12-31 Thread David McGlone
On Fri, 2011-12-30 at 17:36 +, Lester Caine wrote: David McGlone wrote: On Fri, 2011-12-30 at 11:23 -0500, David McGlone wrote: On Fri, 2011-12-30 at 12:27 +, Lester Caine wrote: David McGlone wrote: Hi everyone I got a quick question. I'm wondering if anyone

[PHP-DB] isError ADODB

2012-01-02 Thread David McGlone
Hi all, I've been trying to start using ADOdb instead of PEAR and I've ran into a snag.. I cannot figure out the equivalent of isError in ADOdb, does anyone know? class DbManager { public $db; //open and close the database connection in the constructor function

Re: [PHP-DB] isError ADODB

2012-01-05 Thread David McGlone
On Mon, 2012-01-02 at 20:34 -0600, Karl DeSaulniers wrote: I am not ADO savvy, but the error message you got is the same as what I get in MySQL. On this line, try.. If($this-isError($this-db)) Hoping that fixes it for you. Best, Thanks Karl. I finally got to try this and it wasn't the

[PHP-DB] php adodb book suggestins

2012-01-25 Thread David McGlone
can anyone suggest any good up to date books out there on php adodb. -- David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php adodb book suggestins

2012-01-26 Thread David McGlone
On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php adodb. The only documentation on ADOdb is the website http://adodb.sourceforge.net/#docs ... has ANYBODY seen it described in a php book? While I

Re: [PHP-DB] php adodb book suggestins

2012-01-27 Thread David McGlone
On Thu, 2012-01-26 at 11:59 +, Lester Caine wrote: David McGlone wrote: On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote: David McGlone wrote: can anyone suggest any good up to date books out there on php adodb. The only documentation on ADOdb is the website

[PHP-DB] I'm completely lost here

2012-08-24 Thread David McGlone
This is so simple, done it many times, but something isn't right.. The database gets updated with a record, but all the fields end up being empty in the db. Can anyone see what's out of whack here? I'd appreciate the help. http://pastebin.com/RKw6vtqW David M.

Re: [PHP-DB] I'm completely lost here

2012-08-24 Thread David McGlone
On Friday, August 24, 2012 08:13:42 PM David McGlone wrote: This is so simple, done it many times, but something isn't right.. The database gets updated with a record, but all the fields end up being empty in the db. Can anyone see what's out of whack here? I'd appreciate the help. http

Re: [PHP-DB] I'm completely lost here

2012-08-24 Thread David McGlone
On Friday, August 24, 2012 08:53:40 PM Bastien Koert wrote: On Fri, Aug 24, 2012 at 8:34 PM, Gary Chambers gwch...@gwcmail.com wrote: David, The database gets updated with a record, but all the fields end up being empty in the db. Can anyone see what's out of whack here? I'd appreciate

Re: [PHP-DB] I'm completely lost here

2012-08-24 Thread David McGlone
On Friday, August 24, 2012 09:27:31 PM Gary Chambers wrote: David, Just did that like Richard had suggested also and I do get the expected results. I suspect I need to put the same thing in my query correct? like this: mysql_query (INSERT INTO inventory(image, year, make, model,

[PHP-DB] Comma separated list

2012-08-25 Thread David McGlone
Hi all I've moved on to learning checking forms for valid imput and when doing thing that are repetive, like if ($_POST['first'] == ) { $errors .= 'Please enter a valid name.'; } if ($_POST['second'] == ) { $errors .= 'Please enter a valid name.'; } I can think of a

Re: [PHP-DB] Comma separated list

2012-08-27 Thread David McGlone
{ ... then if they need individual checking like password or email I don't have to check to see if they are empty. Thanks Karl. This is something good for me to ponder over. I'm going to play around with the concept and see what I come up with. David M. Best, Karl On Aug 25, 2012, at 8:15 PM, David

Re: [PHP-DB] Wow, this is weird

2012-08-27 Thread David McGlone
On Monday, August 27, 2012 10:11:32 PM lists-php wrote: Original Message Date: Monday, August 27, 2012 06:04:28 PM -0400 From: David McGlone da...@dmcentral.net To: php-db@lists.php.net Subject: [PHP-DB] Wow, this is weird Hi Everyone I have written

Re: [PHP-DB] Wow, this is weird

2012-08-27 Thread David McGlone
/27/2012 03:04 PM, David McGlone wrote: Hi Everyone I have written some code that works almost 100% like I expect, but for the life of me I cannot figure out why the image name is not being inserted into the database. I've posted the code on pastebin, can anyone spot something amis

Re: [PHP-DB] Wow, this is weird

2012-08-27 Thread David McGlone
= $target_path . $_FILES['image']['name']; if(move_uploaded_file($_FILES['image']['tmp_name'], $target_path)) { if (getimagesize ($target_path)){ echo its an imagebr /; David M. On 8/27/2012 7:32 PM, David McGlone wrote: On Monday, August 27, 2012 10:11:32 PM lists-php wrote

Re: [PHP-DB] Wow, this is weird

2012-08-27 Thread David McGlone
['image']['name']}' in it. or this: This is my string with ' . $_POST['image']['name'] , ' in it, using the concatenate operator. -Matt On 08/27/2012 04:43 PM, David McGlone wrote: On Monday, August 27, 2012 03:36:41 PM Matt Pelmear wrote: David, Try using $_FILES['image

Re: [PHP-DB] Wow, this is weird

2012-08-28 Thread David McGlone
On Tuesday, August 28, 2012 12:41:19 AM you wrote: On Mon, Aug 27, 2012 at 8:03 PM, David McGlone da...@dmcentral.net wrote: I got it. All I needed to do was change $_POST[image] to $image in my query like so: mysql_query (INSERT INTO inventory(image, year, make, model, milage, price

Re: [PHP-DB] Wow, this is weird

2012-09-03 Thread David McGlone
On Wednesday, August 29, 2012 01:33:20 PM you wrote: snip I think you must be missing the '{}' brackets, or something, because with this added to the snippet from before: $sql = INSERT INTO inventory(image, year) VALUES('{$_FILES['image']['name']}', '$_POST[year]'); echo 'h2$sql =

[PHP-DB] table join

2012-09-04 Thread David McGlone
Hi everyone I'm having a whole lot of fun playing with this project. It just keeps expanding and taking me to new territory and I'm really enjoying it. I got a quick question though. I've been playing around with table joins and I tried to join based on the ID but I quickly realized this is

Re: [PHP-DB] table join

2012-09-04 Thread David McGlone
On Tuesday, September 04, 2012 06:27:43 PM David McGlone wrote: Hi everyone I'm having a whole lot of fun playing with this project. It just keeps expanding and taking me to new territory and I'm really enjoying it. I got a quick question though. I've been playing around with table joins

Re: [PHP-DB] Why the sudden dis-interest?

2012-09-21 Thread David McGlone
On Friday, September 21, 2012 10:07:56 AM Jim Giner wrote: What's with all the people suddenly wanting to unsubscribe? Did they suddenly become experts - no longer needing the community for support? Or did they suddenly discover they had actually enlisted for the influx of emails they were