Re: [PHP-DB] Re: [EMAIL PROTECTED] PHP/MySQL and COUNT() problem

2008-04-26 Thread Yves Sucaet
I notice your query says SELECT x,y,COUNT(y),z FROM ... GROUP BY y It was my understanding that when using aggregate function, you need to group by each field in your select-clause, so your query should be: SELECT x,y,COUNT(y),z FROM ... GROUP BY x, y, z Hope this helps, Yves Sucaet Iowa

Re: [PHP-DB] playing longblob media

2008-04-27 Thread Yves Sucaet
What kind of media are you trying to retrieve? Are you trying to retrieve the MySQL data and stream that through your script to the client? How big is the BLOB? If nothing else, you'll need to adapt the MIME-type in the header of your HTTP-message. HTH, Yves - Original Message -

Re: [PHP-DB] playing longblob media

2008-04-28 Thread Yves Sucaet
that will retrieve it from the db as a wav format already. thank you Yves Sucaet wrote: What kind of media are you trying to retrieve? Are you trying to retrieve the MySQL data and stream that through your script to the client? How big is the BLOB? If nothing else, you'll need to adapt the MIME

Re: [PHP-DB] session handling

2008-04-28 Thread YVES SUCAET
Hi nhadie, 1. Unlike, ASP or ASP.NET, PHP only has a Session object, not an Application object. A session is only available to one single user only, and you can't share information between Sessions using PHP (you'd use the Application object for this in ASP(.NET)). While you can probably hack

Re: [PHP-DB] session handling

2008-04-28 Thread YVES SUCAET
2. This is trickier. What do you mean with access? Are you talking about lost updates? Are you talking about simple read-operations? Actually, even as you claim you're a newbie, you're asking questions that are keeping us all up at night! :-) The solutions vary depending on your situation.

Re: [PHP-DB] Query Criteria

2008-04-28 Thread YVES SUCAET
An easier way would be to use the built-in MySQL functions directly. That way, you avoid issues with date-format conversions between PHP and MySQL. Look at: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html You code then becomes: switch ($type) { case today: $sql = ... where

[PHP-DB] Alternative for MySQL Admin tools

2008-05-01 Thread Yves Sucaet
Just like to point out http://www.sqlyog.com, an alternative stand-alone desktop tool to manage you MySQL servers. The free community edition is very good! I've been using it for 3 years now and never had to need to install anything else or additional. HTH, Yves

Re: [PHP-DB] Inner joining 3 tables

2008-05-10 Thread Yves Sucaet
select * from table1 inner join table2 on (table1.common1 = table2.common2) inner join table3 on (table2.common2 = table3.common3) HTH, Yves - Original Message - From: Ron Piggott [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Sent: Saturday, May 10, 2008 4:33 PM Subject:

Re: [PHP-DB] input field validation

2008-05-11 Thread Yves Sucaet
Allow me to point out that this is not database-related... This website should get you everything you want: http://www.acmesoffware.com/acme/ExamplesJS/jsExm_ValidateInteger.asp HTH, Yves - Original Message - From: arafat uddin [EMAIL PROTECTED] To: php-db@lists.php.net Sent:

Re: RES: [PHP-DB] input field validation

2008-05-12 Thread YVES SUCAET
['field'])) { printnot integer; location(header: .php); #or printmeta http-equiv='refresh' content='0;url=.php'; } else { ... } 2008/5/11 Yves Sucaet [EMAIL PROTECTED]: Allow me to point out that this is not database-related... This website should get you everything you want: http

[PHP-DB] synchronizing/replicating MySQL servers

2008-05-13 Thread Yves Sucaet
Hello, We have several PHP applications that run on the same server. We'd like to split them up over two servers. Can somebody help me get started to set up a replicated MySQL installation? I'd like to host the same DB on both machines, and so when one updates the other should update etc...

Re: [PHP-DB] mssql_connect()

2008-06-02 Thread YVES SUCAET
My php.ini is actually in the c:\windows folder. Also: Check to see if you have multiple versions of php.ini on your system. Maybe you have a version in c:\php or c:\windows in addition to c:/windows/system32 and the wrong file gets interpreted. HTH, Yves -- Original Message --

Re: [PHP-DB] mssql_connect()

2008-06-03 Thread Yves Sucaet
in all php.ini file php_mssql.dll extension. i put this dll into system32 folder . but still i cant see mssql library in phpinfo() page. i dont understand why? is there anything besides above things i should do? YVES SUCAET [EMAIL PROTECTED], haber iletisinde sunlari yazdi:[EMAIL PROTECTED

Re: [PHP-DB] Help in concatenation - modular development

2008-06-07 Thread YVES SUCAET
If you want to go for a modular approach, you should consider switching to a solution such as Smarty: http://www.smarty.net for more info. HTH, Yves -- Original Message -- Received: Sat, 07 Jun 2008 11:55:38 AM CDT From: Nitsan Bin-Nun [EMAIL PROTECTED] To: Nasreen Laghari [EMAIL

Re: [PHP-DB] Serializing mySQLi result resource

2008-06-09 Thread Yves Sucaet
It is definitely possible, but I'm not sure if any standard solutions exist. You could encapsulate your mysql_query() function into a class that has a Serializable() method. You'd have to write your own method for that though. Too bad MySQL doesn't support the select for xml construction

[PHP-DB] MDB2 help needed

2008-06-12 Thread YVES SUCAET
Hello, What's the equivalent of mysql_error() and mysql_errno() in MDB2? When I'm sending an incorrect SQL-statement to the server and it fails, all I'm getting is MDB2 Error: syntax error. Thanks in advance, Yves Sucaet Iowa State University -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] MDB2 help needed

2008-06-12 Thread YVES SUCAET
() and mysql_errno() in MDB2? When I'm sending an incorrect SQL-statement to the server and it fails, all I'm getting is MDB2 Error: syntax error. Thanks in advance, Yves Sucaet Iowa State University -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] How to import data from Oracle 10g to MySQL 5.0

2008-07-30 Thread Yves Sucaet
Depending on how much data we're talking about, the PHPMyAdmin may not be the best solution. Microsoft SQL Server has a DTS (data transformation services) that will convert anything into anything (as long as *it* has a ODBC or OLEDB driver). Yves - Original Message - From: santoso

Re: [PHP-DB] I want to remove the last comma

2008-08-12 Thread YVES SUCAET
$out = substr($out, 0, strlen($out) - 1); Removes the overhead cost of creating the array and then joining it. HTH, Yves -- Original Message -- Received: Tue, 12 Aug 2008 02:31:28 PM CDT From: Micah Gersten [EMAIL PROTECTED] To: A. Joseph [EMAIL PROTECTED]Cc: php-db@lists.php.net

Re: [PHP-DB] I want to remove the last comma

2008-08-12 Thread YVES SUCAET
: A. Joseph [EMAIL PROTECTED] To: YVES SUCAET [EMAIL PROTECTED] Subject: Re: [PHP-DB] I want to remove the last comma I tried all this, all i want is something line this var tinyMCEImageList = new Array( ['1_h_1.gif', 'images/1_h_1.gif'], ['1_h_1.gif', 'images/1_h_1.gif'] ); But this what i got var

Re: [PHP-DB] mathematical discrepancies

2008-08-14 Thread Yves Sucaet
Well, yes, it is expected behavior. I think you're confusing the abs() with the round() function (see Evert's answer earlier). abs(-1.05) = 1.05 round(-1.05) = -1 abs(1.35) = 1.35 round(1.35) = 1 hth, Yves - Original Message - From: Andrew Martin [EMAIL PROTECTED] To:

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread YVES SUCAET
Ah, how to debug SQL code in PHP... Here's what I would do: run your query separately in something like SQLyog or the Netbeans database interface. Just to echo $sql and copy and paste. An echo $Record statement may also help to assure that you're passing on the PK to the record correctly. One

[PHP-DB] Getting started with MDB2

2008-09-08 Thread YVES SUCAET
Hi List, What are the equivalent MDB2 methods for: * mysql_last_insert_id() * mysql_real_escape_string() Much obliged, Yves -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting started with MDB2

2008-09-08 Thread YVES SUCAET
] To: YVES SUCAET [EMAIL PROTECTED]Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Getting started with MDB2 * mysql_last_insert_id() getAfterId() http://pear.php.net/reference/LiveUser_Admin-0.3.3/LiveUser_Admin/LiveUser_Admin_Storage_MDB2.html#methodgetAfterId * mysql_real_escape_string

Re: [PHP-DB] Getting started with MDB2 - got it!

2008-09-08 Thread YVES SUCAET
Message -- Received: Mon, 08 Sep 2008 02:02:44 PM CDT From: Evert Lammerts [EMAIL PROTECTED] To: YVES SUCAET [EMAIL PROTECTED]Cc: php-db@lists.php.net, [EMAIL PROTECTED] Subject: Re: [PHP-DB] Getting started with MDB2 Have a look at this: http://wiki.pooteeweet.org/index.php?area=MDB2page

[PHP-DB] databases and XML

2008-09-09 Thread Yves Sucaet
Hi List, I was wondering what strategies people are using to handle large volumes of XML data: How do you store the data? e.g.: Text-files, databases (which one)...? How big are your datasets? e.g.: MB, GB, TB...? What do you use to query the data? e.g.: PHP w/ text-files, SQLServer with for

Re: [PHP-DB] databases and XML

2008-09-09 Thread YVES SUCAET
, considerations, thoughts, suggestions...? -- Original Message -- Received: Tue, 09 Sep 2008 10:29:57 AM CDT From: Lester Caine [EMAIL PROTECTED] To: php-db@LISTS.PHP.NET Subject: Re: [PHP-DB] databases and XML Yves Sucaet wrote: Hi List, I was wondering what strategies people are using

Re: [PHP-DB] Matrix programming

2008-09-23 Thread YVES SUCAET
Do you mean multi level marketing? What kind of matrix calculations? What sort of data do the matrices include? And what does this have to do with databases? Do you need to store matrix data in your db? -- Original Message -- Received: Tue, 23 Sep 2008 12:29:40 PM CDT From: A. Joseph

Re: [PHP-DB] Matrix programming

2008-09-23 Thread YVES SUCAET
-- Received: Tue, 23 Sep 2008 04:09:30 PM CDT From: A. Joseph [EMAIL PROTECTED] To: YVES SUCAET [EMAIL PROTECTED] Subject: Re: [PHP-DB] Matrix programming LIKE.. remember every child is also parent parent on level 0 earn 5% of each fee paid by left leg downline earn 3

Re: [PHP-DB] Insert a xml file into a DB

2008-09-23 Thread YVES SUCAET
Why do you need to store the files in a database? Can't you just keep them on the hard disk and query them with DOM? -- Original Message -- Received: Tue, 23 Sep 2008 03:55:25 PM CDT From: ERNESTO PENALOZA [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Insert a xml file

[PHP-DB] query optimization

2008-09-25 Thread YVES SUCAET
How could I rewrite the following query so it runs faster: select distinct location from blockunit where blockid in ( select bu.blockid from blockunit bu inner join interactionparts ip on (bu.blockid = ip.part) where ip.blockid in

Re: [PHP-DB] query optimization

2008-09-26 Thread Yves Sucaet
-writing it with EXISTS... Thanks for the help so far, Yves - Original Message - From: Jack van Zanen To: Chris Cc: YVES SUCAET ; php-db@lists.php.net Sent: Thursday, September 25, 2008 7:49 PM Subject: Re: [PHP-DB] query optimization If you can answer the other questions

Re: [PHP-DB] query optimization - DB

2008-09-26 Thread Yves Sucaet
Oh, sorry I forgot to mention this. It's a MySQL database. - Original Message - From: Micah Gersten [EMAIL PROTECTED] To: YVES SUCAET [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Thursday, September 25, 2008 7:55 PM Subject: Re: [PHP-DB] query optimization Other question

Re: [PHP-DB] query optimization - DB

2008-09-26 Thread Yves Sucaet
table, so to speed the query, we need to know what indices you have for the 2 tables. Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Yves Sucaet wrote: Oh, sorry I forgot to mention this. It's a MySQL database. - Original Message - From: Micah Gersten

Re: [PHP-DB] using database without mysql installed

2008-10-25 Thread YVES SUCAET
Well, *technicaly*... you could open a socket to the MySQL server and talk to it, but that's probably a bit much, so... You never mentioned what kind of server this is. Is this on *nix or Windows? And do you have access to the php.ini file at least so you can enable the mysql extension? Other

Re: [PHP-DB] PHP Exercises

2008-10-31 Thread Yves Sucaet
Hi Twaha, Have a look at a short-course curriculum that we developed over summer: http://lab.bcb.iastate.edu/training/webdev/nmsu/ hth, Yves - Original Message - From: Twaha Uddessy [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Friday, October 31, 2008 2:19 AM Subject: [PHP-DB]

[PHP-DB] SQL Server Express 2008

2008-11-09 Thread Yves Sucaet
Hello, Anybody knows how to make PHP connect to Microsoft SQL Server Express 2008? I know about the php_mssql extension, but that's apparently only the beginning. What else do I need to do, assuming I have a standard SQLServer setup... Thanks in advance, Yves

Re: [PHP-DB] Can MySql handle Large data?

2008-11-17 Thread Yves Sucaet
Just my two cents, but I doubt if Yahoo uses the same implementation of MySQL as we do. They probably have a tweaked version of it that fits their needs better than the free public version. Bare in mind too that MySQL *is* a commercial company, even more so now they've been acquired by Sun.

Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

2008-11-19 Thread YVES SUCAET
How does the default php_mysql.dll compare to these? Is mysqli faster than mysql? tia, Yves -- Original Message -- Received: Wed, 19 Nov 2008 04:00:46 PM CST From: Chris [EMAIL PROTECTED] To: Micah Gersten [EMAIL PROTECTED]Cc: PHP DB php-db@lists.php.net Subject: Re: [PHP-DB] PHP MySQL

Re: [PHP-DB] Value of $_POST['submit']

2008-11-27 Thread Yves Sucaet
Hi Ron, What's your Javascript client-side code to invoke the PHP-script? You may need to switch to $_GET[] instead of $_POST... Yves - Original Message - From: Ron Piggott [EMAIL PROTECTED] To: PHP DB php-db@lists.php.net Sent: Thursday, November 27, 2008 7:02 PM Subject: [PHP-DB]

RE: [PHP-DB] Value of $_POST['submit']

2008-11-27 Thread YVES SUCAET
Message -- Received: Thu, 27 Nov 2008 08:48:08 PM CST From: Martin, Steve \(MAN-Corporate\) [EMAIL PROTECTED] To: Yves Sucaet [EMAIL PROTECTED], php-db@lists.php.net Subject: RE: [PHP-DB] Value of $_POST['submit'] When I'm developing a number of pages and don't keep track of every variable

Re: [PHP-DB] MySQLDump through PHP/HTML UI

2008-12-10 Thread Yves Sucaet
Hi Ken, How long does the mysqldump operation last? Maybe it's a script timeout problem? And maybe you have different settings on both machines? Other idea: what about pathnames? Linux uses / to separate paths, Windows uses \. That's all I have for now, Yves - Original Message -

Re: [PHP-DB] MySQLDump through PHP/HTML UI

2008-12-10 Thread Yves Sucaet
, the slashes thing used to trip me up, too, when I first started working around Linux boxes. However, the file *is* being created and it is in the right place, just nothing in it. Ken On Dec 10, 2008, at 9:43 AM, Yves Sucaet wrote: Hi Ken, How long does the mysqldump operation last? Maybe it's

Re: [PHP-DB] help me JOIN 3 tables.

2009-01-13 Thread Yves Sucaet
Hi Joseph, With the sum() aggregate function you'll need to use a GROUP BY clause and specify which fields you want from e1 and l1. Something like this: SELECT e1.field1, e1.field2, l1.field3, SUM(a1.adp_amount) as amount FROM a1 inner join e1 on (a1.loanID = a1.adp_loanID) inner join l1 on

Re: [PHP-DB] help me JOIN 3 tables. - fixed query

2009-01-13 Thread Yves Sucaet
hth, Yves - Original Message - From: Yves Sucaet yves.suc...@usa.net To: php-db@lists.php.net Sent: Tuesday, January 13, 2009 7:49 AM Subject: Re: [PHP-DB] help me JOIN 3 tables. Hi Joseph, With the sum() aggregate function you'll need to use a GROUP BY clause and specify which

[PHP-DB] Re: TAKE A LOOK AT THIS (SQL)

2009-01-13 Thread YVES SUCAET
To: Yves Sucaet yves.suc...@usa.net Subject: TAKE A LOOK AT THIS (SQL) SELECT e1.*, l1.*, SUM(a1.adp_amount) as amount FROM e1, l1, a1 WHERE (e1.entre_active = 'Y') AND (l1.entreID = e1.entre_id) AND (l1.loanId = a1.adp_loanID) GROUP BY e1.entre_fname, a1.adp_amount This is a very poor query to me

[PHP-DB] DAL in Java, now what?

2009-02-16 Thread YVES SUCAET
the PECL php_java.dll anywhere. Another project http://php-java-bridge.sourceforge.net/pjb/ seems to rely on Apache and LAMP installations all-together, and is therefore not an option for my Windows/IIS setup. Has anybody tried something similar and been succesful? Thanks in advance, Yves Sucaet

Re: [PHP-DB] re:looking for SQL documentation tool

2009-03-04 Thread Yves Sucaet
The professional version of SQLyog (http://www.sqlyog.com) has this capability. It's not free though. If you're looking for a free tool, I think the standard out there is DBDesigner: http://www.fabforce.net/dbdesigner4/ Alternatively, I once wrote a tool that automatically converted a SQL

[PHP-DB] MySQL + PHP on WinXP x64 = ??

2009-03-12 Thread YVES SUCAET
Hi List, I'm experiencing the problem as described at http://forums.mysql.com/read.php?37,39779,136287#msg-136287 I'm using the following script to test: ?php $p = 0; $n = 0; for ($i = 0; $i 120; $i++) { $conn = mysql_connect(www.myserver.org, user, secret); if ($conn) {

Re: [PHP-DB] MySQL + PHP on WinXP x64 = ?? - clarification

2009-03-12 Thread YVES SUCAET
php_mysql.dll driver. I've used MDB2 from PEAR as well: same result. I think both of these use the C API, and not the ODBC-driver. Yves -- Original Message -- Received: Thu, 12 Mar 2009 04:30:33 PM CDT From: Chris dmag...@gmail.com To: YVES SUCAET yves.suc...@usa.netCc: php-db@lists.php.net

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

2009-04-23 Thread Yves Sucaet
What if you use back-quotes `` around the table/view name? $stmt = OCIParse($conn, SELECT * FROM `v$sql`); - Original Message - From: n.a.mor...@bton.ac.uk To: Mark Casson confu...@icube.co.uk; php-db@lists.php.net Sent: Thursday, April 23, 2009 5:25 AM Subject: RE: [PHP-DB] PHP and

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

2009-04-23 Thread Yves Sucaet
the double quotes, you should be able to prevent this by using the backslash \ character. So, we get: $name = Yves; $name2 = $name Sucaet;// Yves Sucaet $name3 = '$name Sucaet';// $name Sucaet $name4 = \$name Sucaet;// $name Sucaet hth, Yves - Original Message - From

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

2009-04-23 Thread Yves Sucaet
Switch back to double quotes? :-) $stmt = OCIParse($conn, SELECT * FROM v\$sql WHERE INSTR(SQL_TEXT,'something')0); - Original Message - From: Mark Casson confu...@icube.co.uk To: php-db@lists.php.net Sent: Thursday, April 23, 2009 6:10 AM Subject: [PHP-DB] Re: PHP and table/view

Re: [PHP-DB] How to access MySQL through PHP in windows 2K.

2009-04-28 Thread YVES SUCAET
Should be simple enough... Do you have the mysqli driver enabled in your php.ini file? ;extension=php_mysqli.dll should become extension=php_mysqli.dll hth, Yves -- Original Message -- Received: Tue, 28 Apr 2009 06:55:37 PM CDT From: Katiyar \(GMail\) katiya...@gmail.com To:

Re: [PHP-DB] resize 10 upload image

2009-07-11 Thread Yves Sucaet
I agree with using ImageMagick. It works much faster than GD and you'll be able to manipulate much larger images. - Original Message - From: Phpster phps...@gmail.com To: Emiliano Boragina emiliano.borag...@gmail.com Cc: php-db@lists.php.net Sent: Saturday, July 11, 2009 9:13 AM

Re: [PHP-DB] finder (I AM REALLY SORRY)

2009-07-17 Thread Yves Sucaet
Hi List, Am I the only one who's getting the feeling that we're doing Emiliano's JOB here? Maybe he should try posting a job opening at his company to this list, instead of letting us solve all his problems and write his entire application for him. I'm all for helping each other out, but

Re: [PHP-DB] WHILE

2009-07-19 Thread Yves Sucaet
Why don't you use mysql_fetch_assoc() instead? You can address your fields directly, as in: while($row_FOTOS=mysql_fetch_assoc($result)) { echo img src='products/.$row [picture1].' border='0' height='384' /; echo img src='products/.$row [picture2].' border='0' height='384' /;

Re: [PHP-DB] PHP Update query

2009-11-02 Thread Yves Sucaet
Hi Ron, Have a look at http://www.php.net/manual/en/function.mysql-info.php - Original Message - From: Ron Piggott ron@actsministries.org To: PHP DB php-db@lists.php.net Sent: Monday, November 02, 2009 11:59 PM Subject: [PHP-DB] PHP Update query How do I test if an UPDATE query