Re: [PHP-DB] Placing a form on a page

2013-05-06 Thread David Robley
it to align with floating elements?/rhetorical -- Cheers David Robley Freedom is just chaos with better lighting. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Processing Account Login

2013-02-06 Thread David Robley
putting into production is high quality and not hap hazard. Thank you for any help you are able to provide me with. Ron Piggott www.TheVerseOfTheDay.info Try 'php mysql login' as your Google search string -- Cheers David Robley File not found. Should I fake it? (Y/N) -- PHP

[PHP-DB] Re: Query will not work - SOLVED

2013-02-03 Thread David Robley
Ethan Rosenberg, PhD wrote: What am I doing wrong?? Not checking the errors that mysql returns? -- Cheers David Robley Tennis in the Bible: Moses served in Pharaoh's court... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: SQL syntax

2013-01-15 Thread David Robley
'.mysqli_real_escape_string($yesterday).') Personally I would have used a lookup table for the order status. -- Cheers David Robley A cynic smells flowers and looks for the casket. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2012-09-21 Thread David McGlone
. Good ol blood sweat and tears. :-) -- David M. David's Webhosting and consulting.

[PHP-DB] table join

2012-09-04 Thread David McGlone
be a wise way to go about this type of thing. PS I'm not looking for code, just some feedback on logic. -- Regards David M.

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] Wow, this is weird

2012-09-03 Thread David McGlone
David M.

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] 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
On Monday, August 27, 2012 03:36:41 PM Matt Pelmear wrote: David, Try using $_FILES['image']['name'] (like you do elsewhere in the script) instead of $_POST['image'] ? I just your tried suggestion and now it does insert something into the database, but it's inserting Array[name] instead

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

[PHP-DB] Comma separated list

2012-08-25 Thread David McGlone
of a slightly better way like if($_POST['first'] || $_POST['second'] || $_POST['third'] ==){ bla bla } I think I could also use empty(), not sure though, But I belive there are much easier ways. What would anyone here do? If it were me, I'd use the one that uses the or operator. David M.

[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] Re: PDO Mysql data truncation missing error

2012-08-20 Thread David Robley
attribute may do what you want? Cheers -- David Robley I'm not rude, I'm attitudinally challenged. Today is Pungenday, the 14th day of Bureaucracy in the YOLD 3178. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP MySQL High CPU on Query

2012-06-12 Thread David Christensen
this is happening? I'd expect some overhead, but that much of a difference seems wrong. Thanks for your advice, David Christensen = This electronic mail is solely for the use of the intended recipient, and may contain information that is privileged

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

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

[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

[PHP-DB] Re: Multiple Access to Database

2012-01-15 Thread David Robley
://dev.mysql.com/doc/refman/5.5/en/privilege-system.html Cheers -- David Robley Heads I win, tails you lose. Today is Setting Orange, the 15th day of Chaos in the YOLD 3178. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] isError ADODB

2012-01-05 Thread David McGlone
the answer. I'll keep plugging to see what I can do. -- David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] isError ADODB

2012-01-02 Thread David McGlone
to undefined function isError() in /home/david/www/wam/include/database.php on line 16 -- David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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] Abstraction library

2011-12-30 Thread David McGlone
on something that's not guaranteed :-/ -- David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

[PHP-DB] Re: Problem with mysql and php

2011-11-29 Thread David Robley
of that. I'd hazard a guess that there might be indexing problems. http://dev.mysql.com/doc/refman/5.1/en/using-explain.html Cheers -- David Robley Insert inevitable trivial witticism of your choice. Today is Pungenday, the 41st day of The Aftermath in the YOLD 3177. -- PHP Database Mailing

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] sqlite

2011-11-28 Thread David McGlone
.. ; die( brbrQuery Closed !!! $error); } echo Database loaded successfully ; I get the expected output, but can't figure out how to change the above script to echo the contents of the DB. I just get the two messages and that's it. -- Thanks, David M. -- PHP Database Mailing List (http

[PHP-DB] Re: PHP + SQLite - Issues with update

2011-10-20 Thread David Robley
of flush that needs to happen which happens only if the script errors out. Any help is appreciated. Thanks, Prashant. Spelling matters :-) $row = $res-fecth(); Wrong $row = $res-fetch(); Right Cheers -- David Robley Caterpillar: Scratching post. Today is Prickle-Prickle, the 2nd

[PHP-DB] Re: Odd MySQL Problem...

2011-10-14 Thread David Robley
the leading zeros you'll need to store them in a char type and quote them when INSERTing or UPDATEing Cheers -- David Robley The information went data way Today is Boomtime, the 68th day of Bureaucracy in the YOLD 3177. -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: Working with large datasets

2011-10-10 Thread David Robley
. http://dev.mysql.com/doc/refman/5.0/en/using-explain.html Amongst other things With the help of EXPLAIN, you can see where you should add indexes to tables so that the statement executes faster by using indexes to find rows. Cheers -- David Robley I've been to San Francisco said Tom heartlessly

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

2011-05-27 Thread David McGlone
this makes sense. Regards, David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

Re: [PHP-DB] PHP.ini file

2011-05-03 Thread David Robley
-- David Robley The calm confidence of a Christian with four Aces. - M.Twain Today is Pungenday, the 50th day of Discord in the YOLD 3177. Celebrate Discoflux -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: jpgraph and mysql passing array

2011-03-23 Thread David Robley
)) { $datay[] = $row[MBusage]; $datax[] = $row[Distance]; } echo TEST DATA PRINT; print_r($datay,false); ? snip Thank you, Chris If $datay shows as empty, my first step would be to check that your SQL query doesn't return an empty set. Cheers -- David Robley This ocean

[PHP-DB] Re: [PHP] Jquery

2011-02-15 Thread David Harkness
I see firebug-lite-debug.js but not jquery.js. Does firebug include jquery? David

[PHP-DB] Re: Prepared Statements

2011-02-11 Thread David Robley
/pdostatement.fetch.php looks to be one solution. Or http://php.net/manual/en/pdostatement.fetchall.php which gives you an array of all the result set rows. Cheers -- David Robley To shoot a mime, do you use a silencer? Today is Pungenday, the 43rd day of Chaos in the YOLD 3177. -- PHP Database Mailing

[PHP-DB] Re: Prepared Statements and mySQL

2010-12-27 Thread David Robley
it; I imagine the same applies for prepared statements #3) Dates are entered aas strings, so need to be quoted as strings Disclaimer; I have also not used prepared statements, but have looked quickly at the mysqli docs :-) Cheers -- David Robley My software never has bugs. It just develops random

Re: [PHP-DB] Re: [PHP] Problems w/ goto

2010-12-20 Thread David Hutto
On Mon, Dec 20, 2010 at 7:37 AM, Daniel Brown danbr...@php.net wrote: On Sat, Dec 18, 2010 at 17:02, David Hutto smokefl...@gmail.com wrote: or maybe it's saturday morning and i'm drunk?    This seems to be the most likely, and considering how all messages are permanently and independently

[PHP-DB] Re: [PHP] Problems w/ goto

2010-12-18 Thread David Hutto
On Sat, Dec 18, 2010 at 12:45 PM, Geoffrey Bernardo Van Wyk geoffrey.van@gmail.com wrote: Ethan, I tried to test your code, but I get this error next to the labels and goto statements: As a 'professional' programmer, working for an entity, we deal with these problems as we go. As

[PHP-DB] Re: [PHP] Problems w/ goto

2010-12-18 Thread David Hutto
You approved all of us, no matter the peer review, when you signed up or the list. The accumulation of knowledge, is insurmountable when delivered as a whole, but devourable if you need satiation of appetite. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: [PHP] Problems w/ goto

2010-12-18 Thread David Hutto
or maybe it's saturday morning and i'm drunk? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] Problems w/ goto

2010-12-18 Thread David Hutto
check out my new sig. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: PHP Search DB Table

2010-12-14 Thread David Robley
$query . 'br /'; $result = mysql_query($query); And see what is actually in the query. Cheers -- David Robley Reality is nothing but a collective hunch. Today is Pungenday, the 56th day of The Aftermath in the YOLD 3176. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

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] Re: Escaping an '

2010-10-16 Thread David Robley
Ron Piggott wrote: For a query similar to: SELECT * FROM `tablle` WHERE `column` LIKE 'Sally's Hair Parlor' how do I escape the ' for 's? It's in the manual - assuming you use mysql, see http://php.net/manual/en/book.mysql.php Cheers -- David Robley I just won 1000 dollars, Tom said

[PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread David Robley
, and make sure you aren't using stripslashes somewhere? Also, echo the actual query that is being passed to mysql to check what is happening. Cheers -- David Robley Life is Roff when yer Stewpid Today is Sweetmorn, the 70th day of Confusion in the YOLD 3176. -- PHP Database Mailing List (http

[PHP-DB] Re: MySQL Wildcard

2010-05-07 Thread David Robley
reporting function? If so, try using it. Note that to retrieve all records, you could skip the WHERE, or use WHERE 1 Cheers -- David Robley Machine-independent: does not run on any existing machine. Today is Pungenday, the 55th day of Discord in the YOLD 3176. -- PHP Database Mailing List (http

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

2010-05-03 Thread David McGlone
, David M. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Another UNION ALL query

2010-04-29 Thread David Murphy
be another engine. David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Mysql completing Query fast but mysql-query() takes long time to return even single selects/updates

2010-04-12 Thread David Murphy
this is is not really repeatable as is occurs only sometimes and not with a predictable frequency it would be very hard to do the roll back. Also since its in the mysql class of functions I cant even debug into it to try to see much of anything (since its c++ code not userland functions). David -Original

[PHP-DB] Mysql completing Query fast but mysql-query() takes long time to return even single selects/updates

2010-04-09 Thread David Murphy
| This is to a remote system ( but on same GigE switch), however mysql profiling would log transit type if this was a select . Thanks David Murphy

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 M

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] 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

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-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
. What say ppl? This could be the best place for a beginner to learn about PHP stuff :) Let me know your thoughts about it? Best, Guru. -- 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

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

[PHP-DB] Re: Rounding up results

2010-03-09 Thread David Robley
not let you access the mysql documentation? http://dev.mysql.com/doc/refman/5.1/en/mathematical-functions.html Cheers -- David Robley CTRL-ALT-DEL is the key to success Today is Pungenday, the 68th day of Chaos in the YOLD 3176. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Upgrading PHP Version 5.1.6

2010-03-05 Thread David McGlone
will not remove any MySQL tables. -- 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: http://www.php.net/unsub.php

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] 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

[PHP-DB] Random pick

2009-12-14 Thread David McGlone
need to use PHP also? My hunch is mixing the two, but I'm not very prolific with mysql at this point so I thought It would be better to ask before I go and get myself all mixed up. Any suggestions? -- Blessings David M. I have been driven to my knees many times by the overwhelming conviction

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

[PHP-DB] Re: mysql_query

2009-08-10 Thread David Robley
check the mysql section of the documentation, where you will find http://php.net/manual/en/function.mysql-affected-rows.php which will tell you how many rows were affected by your INSERT. Alternatively, if you are using Innodb tables, you could look at using transactions. Cheers -- David Robley

[PHP-DB] Re: PHP and table/view names with '$'

2009-04-23 Thread David Robley
Try enclosing your query in single quotes so php doesn't try to expand what it sees as the variable $sql. For example $stmt = OCIParse($conn, 'SELECT * FROM v$sql'); Cheers -- David Robley I am Homer of Borg. Prepare to be assim... , donuts. Today is Pungenday, the 40th day of Discord

[PHP-DB] RE: [PHP-WIN] Which ORM tool for Windows with Microsoft SQL Server 7/2000/2005.

2009-04-19 Thread David Sceppa
Richard, As pointed out on other branches of the thread, PDO_ODBC is currently your best option for accessing SQL Server via PDO and technologies that rely on PDO. We are investigating producing a PDO driver for SQL Server Driver going forward. David Sceppa Program Manager - Microsoft SQL

[PHP-DB] Re: session variable in select query showing picture from database

2009-02-12 Thread David Robley
will give you some useful information. Cheers -- David Robley I hate Chablis, Tom whined. Today is Pungenday, the 43rd day of Chaos in the YOLD 3175. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Queries / variables

2008-12-06 Thread David Robley
are returning all the language fields for each query but only using one. Why not just retrieve the specified language instead, based on the content of $language? Cheers -- David Robley Circular Definition: see Definition, Circular. Today is Sweetmorn, the 49th day of The Aftermath in the YOLD 3174

[PHP-DB] Re: Apache HTTP Server has encountered a problem and needs to close

2008-11-12 Thread David Robley
S, Murgesan (GE, Corporate, consultant wrote: Hi, I have posted an error in http://bugs.php.net/?id=46519 Please help me to resolve it. Probably the best thing you can do at this stage is submit a backtrace as you were asked on the bugs site. Cheers -- David Robley Recovery

[PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
in mysql. It's like if it delete it first and after select. I have not error in php log. If somebody can help me, because I try since few hours... Best regards, David DURIEUX Tel : +33 (0)4.74.04.81.34 Port : +33 (0)6.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
At the begining $var is $_GET['id'] and after I try directly $var = 10 but no changes. On the server directly, I can only try with the values : $sql = 'SELECT * FROM table WHERE id=10 '; and for this no problem. The problem is when I use a variable in query Best regards, David DURIEUX Tel

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, I have print and it's OK, the query is good like if I put the value directly in the query Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, No changes :/ I have always the same things Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 11:29:29 +0200

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, string(40) SELECT * FROM table WHERE id=107 string(3) 107 string(38) DELETE FROM table WHERE id=107 string(3) 107 Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, No error for mysql_error for all 2 queries. In fact the first return 0 results Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône ID is INT. It's ok before. I have errors : Warning: Wrong parameter count

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, string(0) int(1) string(0) int(1) string(0) int(1) Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 03 Sep 2008 05:23

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, array(2) { [module]= string(12) sousdomaines [deleteid]= string(3) 133 } Note : The ID is good deleted but no select return Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, I Have now : string(3) 134 int(0) Lunch... NOT, I haven't the time today :p but cheese and sausage is good :) Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Are you sur it is 3 ? it is 134 no? Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 14:17:59 +0200 Evert

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Humm with this query I have forgotten to tell you the ID is DELETED Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Yes record exist before the query and is deleted after Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 14:24

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, No, I must test a little more, I tell in few minutes Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 20

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Yes I'm using this query and no row select Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 20:43:25 +0200

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, PHP 5.2.6 on FreeBSD 7.0 i386 associate with apache 2.0.63 Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, Yes DELETE is executed and I have on my page : string(3) 140 int(0) Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, The problem come from the a href= in the input submit With a href=text/a It works It is very Space Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400

Re: [PHP-DB] Probleme with MySQL queries

2008-09-03 Thread David DURIEUX
Bonjour, I have make this to have a button, it's an error, it's the first time I have a problem with this. I'm sorry to have get your time. Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : [EMAIL PROTECTED] Site Web : http://www.siprossii.com/ SIPROSSII 847

[PHP-DB] Re: Zend Optimizer for PHP on Linux

2008-08-05 Thread David Thorne
I too am looking into this though with PHP5. Does anyone have any experience of this - I am also interested in benchmark results in terms of performance improvments/hits when using the optimizer both with and without SSL based websites. Reagrds, David naren pendyal wrote: Hello, Can any one

[PHP-DB] Can't get PHP PGSQL module to load

2008-06-03 Thread Zimmerli, David
as well. (I have enable_dl = On in php.ini.) My set up is as follows: WinXP Professional Apache 2.2.4 PHP 5.2.6 PostGreSQL 8.3 I am installing everything from pre-built binaries. Any help would be much appreciated. Regards, David Z.

RE: [PHP-DB] Can't get PHP PGSQL module to load

2008-06-03 Thread Zimmerli, David
. and the extension_dir should be best specific with full path such as extension_dir = e:\webroot\php5\ext\ I tried that too. It still doesn't load. -- David Z. -Original Message- From: Eric [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 11:37 AM To: Zimmerli, David; php-db

  1   2   3   4   5   6   7   >