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

2010-03-18 Thread Richard Dunne
Well if it could be subtitled in any way, that would solve the problem, and again I say IF. Richard. - Original Message - From: David McGlone da...@dmcentral.net To: php-db@lists.php.net Sent: Thursday, March 18, 2010 12:07 PM Subject: Re: [PHP-DB] Online PHP-Mysql Meeting I think

Re: [PHP-DB] Building indexes

2010-03-18 Thread listread
Chris, I just assumed that everyone on this list was using MySQL... That's what we're using (v. 5.1.45 GA) with InnoDB as the engine. (I just read your tutorial at http://www.designmagick.com/article/16/ It was very helpful - I look forward to checking out more of your articles.) If it

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

2010-03-18 Thread Gunawan Wibisono
in any way, that would solve the problem, and again I say IF. Richard. - Original Message - From: David McGlone da...@dmcentral.net To: php-db@lists.php.net Sent: Thursday, March 18, 2010 12:07 PM Subject: Re: [PHP-DB] Online PHP-Mysql Meeting I think we should either consider

Re: [PHP-DB] Re: help needed.

2010-03-18 Thread Gunawan Wibisono
flash? why not using xml.. is the data will be update? this good aplication i think On Thu, Mar 18, 2010 at 4:10 PM, Nadim Attari na...@alienworkers.comwrote: Hello, Maybe these can help. Web Server on CD: http://ampstart.ly-le.info/ http://www.stunnix.com/ http://www.server2go-web.de/

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

2010-03-18 Thread Gunawan Wibisono
the problem, and again I say IF. Richard. - Original Message - From: David McGlone da...@dmcentral.net To: php-db@lists.php.net Sent: Thursday, March 18, 2010 12:07 PM Subject: Re: [PHP-DB] Online PHP-Mysql Meeting I think we should either consider audio or video Audio would

Re: [PHP-DB] Re: help needed.

2010-03-18 Thread Vinay Kannan
Yes, the data would be updated, I am not really good at XML, havnt had a chance to work with XML, so was trying to avoid it as much as I can, but I guess if it thats what it takes, then would have to sit down and start working on it now :) On Thu, Mar 18, 2010 at 8:11 AM, Gunawan Wibisono

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

2010-03-18 Thread nagendra prasad
This is vary nice Gunawan :) I will post my example movie tonight and see if this works. I am going to make a live working movie which will show the user as if he is sitting just next to me. I will also try to put some subtitles in it. Just thinking if anyone know a tool which can convert MP3 to

Re: [PHP-DB] Building indexes

2010-03-18 Thread Chris
listread wrote: Chris, I just assumed that everyone on this list was using MySQL... That's what we're using (v. 5.1.45 GA) with InnoDB as the engine. Most people are but there are lots of types of databases out there :) (I just read your tutorial at http://www.designmagick.com/article/16/

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

2010-03-18 Thread Gunawan Wibisono
for studi purpose.. i suggest to use subtitle.. but in my youtube.. use Caption (soft-sub) i think we should create simple.. http://www.youtube.com/watch?v=y2c_S_90Syc using close caption http://www.youtube.com/watch?v=ZrRU1k4f_zM using annotation beside.. in this youtube.. we can pause it to

Re: [PHP-DB] Calculator

2010-03-17 Thread Karl DeSaulniers
Oh! I had gotten the zip file you sent though. Ha, you must have replied to all Well, thanks again. very nice I might add. Karl On Mar 17, 2010, at 3:12 AM, nagendra prasad wrote: Sorry I was not aware that I can not send an attachment. Here is the PHP calculator script: ?php function

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

2010-03-17 Thread ZeYuan Zhang
Thanks everybody. To: Christopher Jones thanks for your code. I have run your code. For the sample you supplied, the oci_commit really returns false. But if I add a primary key constraint to t_tab.x, and then run the script, the oci_commit returns true!strange... So do I need check all the

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

2010-03-17 Thread Gunawan Wibisono
perhaps u can editing.. u perhaps not have something to share.. but you can give something like.. comment or anything that helpfull On Tue, Mar 16, 2010 at 11:49 AM, David McGlone da...@dmcentral.net wrote: Hi David, I am glad that you are in. However don't worry about the presentation

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

2010-03-17 Thread nagendra prasad
Hi All, Here are few topics which covers basic PHP-MYSQL which I think is useful for the meeting: 1. Introduction to PHP-MYSQL 2. PHP page basic structure 3. MYSQL connectivity using PHP 4. User login tips and tricks 5. User registration and its structure 6. Search engine using PHP-MYSQL 7.

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

2010-03-17 Thread Gunawan Wibisono
i think i take number 3 3. MYSQL connectivity using PHP better not greedy right On Wed, Mar 17, 2010 at 10:19 PM, nagendra prasad nagendra802...@gmail.comwrote: Hi All, Here are few topics which covers basic PHP-MYSQL which I think is useful for the meeting: 1. Introduction to PHP-MYSQL

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

2010-03-17 Thread Vinay Kannan
Hey, We could also use a web sharing application, theres this one web sharing application i know for presentations, but the trial version is restricted to 25 at a time. Thanks, Vinay Kannan. On Mon, Mar 15, 2010 at 1:35 AM, nagendra prasad nagendra802...@gmail.comwrote: Hi David, I am glad

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

2010-03-17 Thread nagendra prasad
I think we should either consider audio or video because not everyone has a high speed broadband connection. What my plan is that each one who is teaching some topic can create a video on the topic. He can use any screen capturing tool with audio and share that vedio with all of us. Then I will

Re: [PHP-DB] Building indexes

2010-03-17 Thread Chris
listread wrote: Greetings! We are working on a 4 million record db with about 55 fields. We need to build indexes to speed queries, but it seems to take way too long. I'm assuming your using mysql but that's just a guess. What database? (mysql, oracle, postgres, firebird, sqlite, other) If

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

2010-03-16 Thread Chris
ZeYuan Zhang wrote: Hi there. Why oci_commit function always returns true even when the transaction fails. I just copied the code in the php manual [Example 1636. oci_commit() example], and runned it, the situation is as follows: * The statements do commit at the moment when oci_commit

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

2010-03-16 Thread Christopher Jones
ZeYuan Zhang wrote: Hi there. Why oci_commit function always returns true even when the transaction fails. I just copied the code in the php manual [Example 1636. oci_commit() example], and runned it, the situation is as follows: * The statements do commit at the moment when oci_commit

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

2010-03-16 Thread Christopher Jones
Chris wrote: ZeYuan Zhang wrote: Hi there. Why oci_commit function always returns true even when the transaction fails. I just copied the code in the php manual [Example 1636. oci_commit() example], and runned it, the situation is as follows: * The statements do commit at the moment

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

2010-03-16 Thread Chris
Christopher Jones wrote: Chris wrote: ZeYuan Zhang wrote: Hi there. Why oci_commit function always returns true even when the transaction fails. I just copied the code in the php manual [Example 1636. oci_commit() example], and runned it, the situation is as follows: * The

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

2010-03-16 Thread Christopher Jones
Chris wrote: Christopher Jones wrote: Chris wrote: ZeYuan Zhang wrote: Hi there. Why oci_commit function always returns true even when the transaction fails. I just copied the code in the php manual [Example 1636. oci_commit() example], and runned it, the situation is as

Re: [PHP-DB] oci_commit always returns true even when the transaction fails.

2010-03-16 Thread Christopher Jones
echo Second Insert\n; $s = oci_parse($c, insert into t_tab values ( 1,-1)); $r = oci_execute($s, OCI_DEFAULT); // Explore the difference with and without OCI_DEFAULT if (!$r) { $m = oci_error($s); trigger_error('Could not execute: '. $m['message'], E_USER_ERROR); } $r =

Re: [PHP-DB] Calculator

2010-03-16 Thread kesavan trichy rengarajan
http://www.javascriptkit.com/script/cut18.shtml JS based solution would be the easiest. On Wed, Mar 17, 2010 at 3:07 PM, Karl DeSaulniers k...@designdrumm.comwrote: Hello, I have been asked to see if I can set up an online calculator. I was wondering if anyone had some pointers on where I

Re: [PHP-DB] Calculator

2010-03-16 Thread Chris
Karl DeSaulniers wrote: Hello, I have been asked to see if I can set up an online calculator. I was wondering if anyone had some pointers on where I can lear/find a script that calculates percentages. The regular math part I think I can figure out. Its not a complicated calc, just basic math and

Re: [PHP-DB] Calculator

2010-03-16 Thread Karl DeSaulniers
This is close. All that functionality with ability to factor in say a 20% discount. Thanks Kesavan Karl On Mar 16, 2010, at 11:22 PM, kesavan trichy rengarajan wrote: http://www.javascriptkit.com/script/cut18.shtml JS based solution would be the easiest. On Wed, Mar 17, 2010 at 3:07 PM,

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

2010-03-15 Thread Gunawan Wibisono
I create tutorial.. perhaps you can comment my first tutorial *hope better for next tutorial On 3/15/10, Karl DeSaulniers k...@designdrumm.com wrote: We can do it at my house.. :) Sounds like a great idea. +1 Karl On Mar 14, 2010, at 8:11 PM, Gunawan Wibisono wrote: Great Idea.. I

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

2010-03-15 Thread nagendra prasad
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 is the

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

2010-03-15 Thread Karl DeSaulniers
Something like this? learnwebdevelopment.com I am on a mailing list with them were they send me links to a whole slue of video tutorials. Ranging from PHP to Javascript to Flash AS. Tips and tricks etc. Maybe a colaborative website that we all can be members of? Karl On Mar 15, 2010, at

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

2010-03-15 Thread Gunawan Wibisono
dear sir.. I can't assure.. I will not busy at that time perhaps we should think off-line meting like in forum or this milis i think.. the first we can do is to build tutorial.. Like I posted earlier.. I create tutor in Youtube.. I use Movie Maker and camstudio *the sound is not include plus in

[PHP-DB] Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

2010-03-15 Thread Gunawan Wibisono
Wibisono [mailto:landavi...@gmail.com] Sent: Sunday, March 07, 2010 7:37 AM To: php-wind...@lists.php.net; php-db@lists.php.net Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL sry.. this kinda other person problem thx for your support and I kinda found this problem on other place

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

2010-03-15 Thread Gunawan Wibisono
thx... I looking forward to have another tutorial On Tue, Mar 16, 2010 at 10:28 AM, win.a win@gmail.com wrote: Good idea! i'll join All you best What we are struggling for ? The life or the life ? On Tue, Mar 16, 2010 at 10:47 AM, Gunawan Wibisono

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 Johnny Mac
I would be interested. Sounds good Johnny Mac -Original Message- From: nagendra prasad [mailto:nagendra802...@gmail.com] Sent: Sunday, March 14, 2010 10:35 AM To: PHP DB; phpexpe...@yahoogroups.com Subject: [PHP-DB] Online PHP-Mysql Meeting Hi All, Few days back I have attended Ubuntu

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

2010-03-14 Thread Partha Sarathy
Hi Interested ... On Sun, Mar 14, 2010 at 9:56 PM, Johnny Mac m...@seabrain.com wrote: I would be interested. Sounds good Johnny Mac -Original Message- From: nagendra prasad [mailto:nagendra802...@gmail.com] Sent: Sunday, March 14, 2010 10:35 AM To: PHP DB;

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

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

2010-03-14 Thread Gunawan Wibisono
Great Idea.. I think I will share my little knowledge.. how become lazy programer *no offence.. a way to decrease your type code.. On Mon, Mar 15, 2010 at 7:56 AM, David McGlone da...@dmcentral.net wrote: On Sunday 14 March 2010 20:02:01 you wrote: well sounds interesting. It will be on a

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

2010-03-14 Thread Karl DeSaulniers
We can do it at my house.. :) Sounds like a great idea. +1 Karl On Mar 14, 2010, at 8:11 PM, Gunawan Wibisono wrote: Great Idea.. I think I will share my little knowledge.. how become lazy programer *no offence.. a way to decrease your type code.. On Mon, Mar 15, 2010 at 7:56 AM, David

Re: [PHP-DB] RegExp

2010-03-12 Thread Karl DeSaulniers
Correction, this actually starts the pages. http://lawrence.ecorp.net/inet/samples/regexp-intro.php Enjoy!, Thanks Lawrence ;) Karl On Mar 12, 2010, at 1:47 AM, Partha Sarathy wrote: hi Thanks. Useful site. On Fri, Mar 12, 2010 at 1:07 PM, Karl DeSaulniers k...@designdrumm.comwrote:

Re: [PHP-DB] RegExp

2010-03-11 Thread Partha Sarathy
hi Thanks. Useful site. On Fri, Mar 12, 2010 at 1:07 PM, Karl DeSaulniers k...@designdrumm.comwrote: Hello List, I found this website. Now it is not php based, it is javascript, but interesting none the less. May give people hints on how to construct their own regular expressions in PHP

[PHP-DB] Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

2010-03-07 Thread Gunawan Wibisono
:01 AM To: php-windows Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL Gunawan Wibisono wrote: Hello, First of all, I apologise if I do something wrong, because I'm new to this weird system. For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and MySQL

[PHP-DB] Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

2010-03-07 Thread Pierre Joye
On Sun, Mar 7, 2010 at 4:36 PM, Gunawan Wibisono landavi...@gmail.com wrote: sry.. this kinda other person problem thx for your support and I kinda found this problem on other place.. Is posible.. the problem in the windows 7? No, php works fin on windows 7. Cheers, -- Pierre @pierrejoye |

[PHP-DB] RE: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

2010-03-07 Thread Venkat Raman Don
@lists.php.net Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL sry.. this kinda other person problem thx for your support and I kinda found this problem on other place.. Is posible.. the problem in the windows 7? On Sun, Mar 7, 2010 at 12:12 AM, Venkat Raman Don don.ra

Re: [PHP-DB] Cannot connect to MySQL

2010-03-06 Thread Gunawan Wibisono
you install php, apache and mysql one-by-one? how about try access other db (example: odbc) On Fri, Mar 5, 2010 at 9:33 PM, The Phantom livephan...@live.com wrote: Hello, First of all, I apologise if I do something wrong, because I'm new to this weird system. For test purposes, I have

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] Upgrading PHP Version 5.1.6

2010-03-05 Thread kesavan trichy rengarajan
Well, you can always backup your databases through phpMyAdmin (export) or from commandline using mysqldump just to be on the safer side. On Sat, Mar 6, 2010 at 12:51 PM, David McGlone da...@dmcentral.net wrote: On Friday 05 March 2010 12:35:43 Vinay Kannan wrote: Hello, I am currently

Re: [PHP-DB] Upgrading PHP Version 5.1.6

2010-03-05 Thread Lester Caine
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 a good number of databases, and it

Re: [PHP-DB] 64-bit Linux -- Fatal ... undefined function mysql_connect()

2010-03-02 Thread andrew jarcho
On Tue, Mar 2, 2010 at 12:25 AM, Chris dmag...@gmail.com wrote: andrew jarcho wrote: Hello all, I'm running Fedora 12 (64-bit), Apache 2.2.14, PHP 5.3.1, MySQL 5.1.42, on a Dell laptop. snip I get the message: Fatal error: Call to undefined function mysql_connect() snip The output

Re: [PHP-DB] ocilogon core dump on Solaris 10 X86 with php-5.2.9 and Oracle 10g

2010-03-02 Thread Christopher Jones
At a guess, there is a clash with the SSL libraries or it is a libpthread problem - google around for background. Chris Andre LAGADEC wrote: Hello, I am on Solaris 10 X86 with DELL IP , and I compile Php-5.2.9 with Apache2, Mysql6 and Oracle10g with success. But when I want to connect to

Re: [PHP-DB] ocilogon core dump on Solaris 10 X86 with php-5.2.9 and Oracle 10g

2010-03-02 Thread andre . lagadec
idea ? I continue to search on Google... -Christopher Jones christopher.jo...@oracle.com a écrit : - A : Andre LAGADEC andre.laga...@education.gouv.fr De : Christopher Jones christopher.jo...@oracle.com Date : 02/03/2010 17:58 cc: php-db@lists.php.net Objet : Re: [PHP-DB] ocilogon core

Re: [PHP-DB] 64-bit Linux -- Fatal ... undefined function mysql_connect()

2010-03-01 Thread Chaitanya Yanamadala
hai andrew Can u try like changing the ini file like this.. under mysql change the to mysql.default_port 3306 3306 and also if this time too it is not getting connected to the socket try using the mysqli construct to connect to database.. this is for your

Re: [PHP-DB] 64-bit Linux -- Fatal ... undefined function mysql_connect()

2010-03-01 Thread Chris
andrew jarcho wrote: Hello all, I'm running Fedora 12 (64-bit), Apache 2.2.14, PHP 5.3.1, MySQL 5.1.42, on a Dell laptop. snip I get the message: Fatal error: Call to undefined function mysql_connect() snip The output of my phpinfo() includes: Is that from command line or webpage?

Re: [PHP-DB] Are join queries in phpMyAdmin a security hazard?

2010-02-28 Thread Chris
Ben Hubbell wrote: Hello, My web host does not have join queries in phpMyAdmin enabled. My web host is inexpensive, but their commitment to costumer service is inconsistent. They often dismiss bug reports as feature requests. When pressed to enable join queries in phpMyAdmin several years

Re: [PHP-DB] Are join queries in phpMyAdmin a security hazard?

2010-02-28 Thread TG
anyway.. but maybe it's harder to detect that and block it. - Original Message - From: Chris dmag...@gmail.com To: Ben Hubbell s...@benhubbell.com Cc: php-db@lists.php.net Date: Mon, 01 Mar 2010 09:01:43 +1100 Subject: Re: [PHP-DB] Are join queries in phpMyAdmin a security hazard? Ben

Re: [PHP-DB] Are join queries in phpMyAdmin a security hazard?

2010-02-27 Thread Phpster
No more so than in any other SQL query Bastien Sent from my iPod On Feb 27, 2010, at 9:52 PM, Ben Hubbell s...@benhubbell.com wrote: Hello, My web host does not have join queries in phpMyAdmin enabled. My web host is inexpensive, but their commitment to costumer service is inconsistent.

Re: [PHP-DB] Need a tool for mysql file

2010-02-25 Thread Bastien Koert
On Thu, Feb 25, 2010 at 9:52 AM, nagendra prasad nagendra802...@gmail.com wrote: Hi All, I have a mysql database file of around 1 GB in size. Is their any tool which which I can see all the database without uploading it on phpmyadmin on localhost. I have tried to upload it on localhost but it

Re: [PHP-DB] Injection Attack?

2010-02-25 Thread Chris
Gary wrote: I have a DB on a site that is not really up anymore (a redirect because of a merger), and it seems to have been attacked. I always use REMOTE_IP so that I have a record and able to ban IP's of the endless form spammers, however on this attack, the IP listed is my local IP

Re: [PHP-DB] Re: Need a tool for mysql file

2010-02-25 Thread Chris
Ferdi wrote: -- Forwarded message -- From: nagendra prasad nagendra802...@gmail.com To: PHP DB php-db@lists.php.net, phpexpe...@yahoogroups.com, php mysql php_mysql_usergr...@yahoogroups.com Date: Thu, 25 Feb 2010 16:52:40 +0200 Subject: Need a tool for mysql file Hi All, I

Re: [PHP-DB] SELECT LIKE with % and without %

2010-02-24 Thread Ahmet Caner
Eleonora De Marinis eleonora.demari...@garr.it, haber iletisinde sunlari yazdi:49fe92d0.2060...@garr.it... $sql = SELECT * FROM table WHERE ID ='$_GET[id]' AND title LIKE '%$_GET[word]%'; Original Message Subject: [PHP-DB] SELECT LIKE with %' and without %' From:

Re: [PHP-DB] mysql_close()

2010-02-20 Thread Patrick Price
According to php.net, if you don't specify a link iedentifier it closes the last nonpersistent connection.   http://us3.php.net/mysql_close Patrick -- Sent from my Palm Pre Ron Piggott wrote: Does mysql_close() close all open database connections? How would I specify which connection to

Re: [PHP-DB] mysql_close()

2010-02-20 Thread Ron Piggott
Message- From: pretz...@mail.uni-paderborn.de Reply-to: pretz...@mail.uni-paderborn.de To: ron@actsministries.org Subject: Re: [PHP-DB] mysql_close() Date: Sat, 20 Feb 2010 22:48:22 +0100 http://php.net/manual/en/function.mysql-close.php On 20.02.2010 22:27, Ron Piggott wrote: Does

Re: [PHP-DB] Using mssql serial command in PHP 5.3

2010-02-18 Thread Richard Quadling
On 18 February 2010 06:15, Beo Tse beo...@hotmail.com wrote: I am using the EasyPHP5.3.0 and MS SQL Server Management Studio Express 9.00.2047.00 Config of EasyPHP5.3.0 == PHP 5.3.0 Apache 2.2.13 MySQL 5.1.37 PhpMyAdmin 3.2.1 I want to use mssql command (e.g.

Re: [PHP-DB] Login query

2010-02-18 Thread Bastien Koert
On Thu, Feb 18, 2010 at 4:40 PM, Ron Piggott ron@actsministries.org wrote: I am wondering what others do for a login query.  I think there could be two results: correct e-mail password; correct e-mail wrong password So far my login query is: SELECT * FROM `member` WHERE `email` =

Re: [PHP-DB] Login query

2010-02-18 Thread Chris
Bastien Koert wrote: On Thu, Feb 18, 2010 at 4:40 PM, Ron Piggott ron@actsministries.org wrote: I am wondering what others do for a login query. I think there could be two results: correct e-mail password; correct e-mail wrong password So far my login query is: SELECT * FROM `member`

Re: [PHP-DB] Using mssql serial command in PHP 5.3

2010-02-18 Thread Beo Tse
On 18 February 2010 06:15, Beo Tse beo...@hotmail.com wrote: I am using the EasyPHP5.3.0 and MS SQL Server Management Studio Express 9.00.2047.00 Config of EasyPHP5.3.0 == PHP 5.3.0 Apache 2.2.13 MySQL 5.1.37 PhpMyAdmin 3.2.1 I want to use mssql command (e.g.

Re: [PHP-DB] php_warn

2010-02-16 Thread madunix
solved by setting error reporting to 0 in “configuration.php” file $mosConfig_error_reporting = '0; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php_warn

2010-02-16 Thread Chris
madunix wrote: solved by setting error reporting to 0 in “configuration.php” file $mosConfig_error_reporting = '0; That hides the problem, it doesn't solve it. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] IFNULL

2010-02-14 Thread Chris
Ron Piggott wrote: How do I add IFNULL to the LEFT JOIN query? I either want the result from the database or a 0 instead of the word NULL Ron SELECT `store_product_profile`.`reference` , inventory.inventory, sold_1.quantity, sold_2.quantity, sold_3.quantity FROM `store_product_profile`

Re: [PHP-DB] Getting total quantities

2010-02-14 Thread Karl DeSaulniers
Would it be? $q = SUM(ProductStock) FROM products; or $q = SELECT SUM(ProductStock) AS ProductStock FROM products; if I want to return $ProductStock as the value? Karl On Feb 14, 2010, at 10:55 PM, Karl DeSaulniers wrote: Hello List, I have a situation where I want to figure out the

Re: [PHP-DB] Getting total quantities

2010-02-14 Thread Chaitanya Yanamadala
Have you tried using it like this *select count(*) from products;* Chaitanya A man can get discouraged many times but he is not a failure until he stops trying... On Mon, Feb 15, 2010 at 10:39 AM, Karl DeSaulniers k...@designdrumm.comwrote: Would it be? $q = SUM(ProductStock) FROM

Re: [PHP-DB] Getting total quantities

2010-02-14 Thread Chris
Karl DeSaulniers wrote: Would it be? $q = SUM(ProductStock) FROM products; or $q = SELECT SUM(ProductStock) AS ProductStock FROM products; if I want to return $ProductStock as the value? This one. The AS gives it an alias (or shortcut) to make it easier to find in mysql_fetch_array etc.

Re: [PHP-DB] Getting total quantities

2010-02-14 Thread Chris
Chaitanya Yanamadala wrote: Have you tried using it like this *select count(*) from products;* This will give you the number of rows in the table, not what Karl wants. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Getting total quantities

2010-02-14 Thread Chaitanya Yanamadala
*Hai Chris I already send him the right one. But my mail has been blocked by the php lists. so i send a personal mail for him... FYI SELECT SUM(ProductStock) FROM products; * if u want to give an other name for the row then use it as * ** SELECT SUM(ProductStock) as stock FROM products;*

Re: [PHP-DB] Getting total quantities

2010-02-14 Thread Karl DeSaulniers
Ok, sweet, then I am on the right track. Now I did notice that I forgot the SELECT in the first query, does that matter? Can I just start out with SUM? Thanks for your response. Karl On Feb 14, 2010, at 11:32 PM, Chris wrote: Karl DeSaulniers wrote: Would it be? $q = SUM(ProductStock)

Re: [PHP-DB] Getting total quantities

2010-02-14 Thread Chris
Karl DeSaulniers wrote: Ok, sweet, then I am on the right track. Now I did notice that I forgot the SELECT in the first query, does that matter? Can I just start out with SUM? No - that's invalid sql. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-13 Thread Moritz Fuchs
Hi, Why don't you just try the following: $query = SELECT * FROM foo WHERE UserID = .$uID . ORDER BY bar; $result = mysql_query($query); //get the first row $row = mysql_fetch_object($result); //get the next row while ($next = mysql_fetch_object($result)) { //do something with row/next

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-13 Thread Richard Quadling
On 12 February 2010 23:46, Paul Hollingworth devine...@msn.com wrote: Thanks for the code Eric, it seems to loosely provide the functionality that I'm after. Just out of interest though, is there no other way to find the next result row in an object apart from dumping it into an array?

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Eric Lee
On Sat, Feb 13, 2010 at 3:26 AM, Paul devine...@msn.com wrote: Hi all, I'm currently having a problem correctly formatting a table within a while loop. I'm using an object to store the results of a query, and using the while to iterate through it each row to produce the output: $query =

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Paul Hollingworth
Thanks for the code Eric, it seems to loosely provide the functionality that I'm after. Just out of interest though, is there no other way to find the next result row in an object apart from dumping it into an array? Thanks, Paul Eric Lee wrote: On Sat, Feb 13, 2010 at 3:26 AM, Paul

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Karl DeSaulniers
Hi Paul, Can't you just? $query = SELECT DISTINCT bar FROM foo WHERE UserID = .$uID; $result = mysql_query($query); while($obj = mysql_fetch_assoc($result) { $bar = $obj['bar']; if ($bar == something) { //do this } } I'm some what a beginner, so sorry if this

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Eric Lee
On Sat, Feb 13, 2010 at 7:46 AM, Paul Hollingworth devine...@msn.comwrote: Thanks for the code Eric, it seems to loosely provide the functionality that I'm after. Just out of interest though, is there no other way to find the next result row in an object apart from dumping it into an array?

Re: [PHP-DB] Is this Code Correct??

2010-02-11 Thread Andrés G . Montañez
echo 'Name: a href=' . $url . '' . $runrows['name'] . '/a'; On 11 February 2010 08:54, nagendra prasad nagendra802...@gmail.com wrote: Hi All, I want to link the actual file when the result is displayed. url = actual MP3 location Name = Name of the MP3 Here is the code that I want to

Re: [PHP-DB] Is this Code Correct??

2010-02-11 Thread nagendra prasad
Thanks Buddy, its working but the linking is not working properly. Its taking me the same page address on which right now I am. http://localhost/searchengine/download.php?url=mj_bad_track01.mp3 I want to connect the url directly to the MP3 file so that user can download the MP3. Best,

Re: [PHP-DB] Is this Code Correct??

2010-02-11 Thread Andrés G . Montañez
Make sure your $url variable has the right value. On 11 February 2010 09:06, nagendra prasad nagendra802...@gmail.com wrote: Thanks Buddy, its working but the linking is not working properly. Its taking me the same page address on which right now I am.

Re: [PHP-DB] Is this Code Correct??

2010-02-11 Thread nagendra prasad
Yep now its working :) Thanks, Guru.

Re: [PHP-DB] php_warn

2010-02-11 Thread Kamil Walas
include_once()? Link: http://www.php.net/manual/en/function.include-once.php W dniu 2010-02-11 14:49, madunix pisze: some of my web pages having the following issue when i call them Warning:main(main_page.html.php): failed to open stream: No such file or directory in

Re: [PHP-DB] php_warn

2010-02-11 Thread Daniel Brown
On Thu, Feb 11, 2010 at 08:49, madunix madu...@gmail.com wrote: some of my web pages having the following issue when i call them Warning:main(main_page.html.php): failed to open stream: No such file or directory in /www/htdocs/web/public/public.php on line 50 Warning:main(): Failed opening

Re: [PHP-DB] Upload_File

2010-02-10 Thread Gunawan Wibisono
u should type the error here and attach the file not type in msgbox below what permision for upload folder? On Wed, Feb 10, 2010 at 6:16 PM, Bilal Ahmad engg.bilalma...@googlemail.com wrote: Hi I am trying to make a form to provide option to user to upload a file on a server.Here is the code

Re: [PHP-DB] Upload_File

2010-02-10 Thread Eric Lee
On Wed, Feb 10, 2010 at 7:35 PM, Gunawan Wibisono landavi...@gmail.comwrote: u should type the error here and attach the file not type in msgbox below what permision for upload folder? On Wed, Feb 10, 2010 at 6:16 PM, Bilal Ahmad engg.bilalma...@googlemail.com wrote: Hi I am trying

Re: [PHP-DB] Upload_File

2010-02-10 Thread Chaitanya Yanamadala
hai farooq I think the issue is with the max_execution_time in the php.ini of the server. try modifying this to the maximum level. also for your code i have modified this a little bit.. *form enctype=multipart/form-data action=upload.php method=POST input type=hidden name=MAX_FILE_SIZE

Re: [PHP-DB] upload multiple files and rename wih time()

2010-02-07 Thread Chris
Emiliano Boragina wrote: Hello php fellows, I have two codes to upload multiple files, works very well, but I cant rename the files... really i dont know... The code looks ok. Do you get an error message? If not, turn up error_reporting and enable display_errors:

Re: [PHP-DB] Cross reference query help

2010-02-07 Thread Chris
Ron Piggott wrote: The following is a query I am working on today. I need help tweaking on it. What I am trying to get for results from the query are where there are rows in either table, not all 3 tables linked together. In other words I am trying to INNER JOIN these two pairs of tables for

Re: [PHP-DB] Storing Images #2

2010-02-05 Thread elk dolk
-- I have my photos in /public_html/img/gid directory and with this path: img src='http://www.mydomain.com/img/{$gid}/{$photoFileName}' in getImage.php the server displays the photos. Now if I put my photos outside of the

Re: [PHP-DB] Storing Images #2

2010-02-05 Thread Richard Quadling
On 5 February 2010 09:08, elk dolk elkd...@yahoo.com wrote: -- I have my photos in /public_html/img/gid directory and with this path: img src='http://www.mydomain.com/img/{$gid}/{$photoFileName}' in getImage.php the server displays the

Re: [PHP-DB] Storing Images #2

2010-02-04 Thread Jason Gerfen
If its outside the html root you would need to create a symlink pointing to the appropriate folder % ln -s /path/to/hidden /path/to/public *however this is very insecure Then if your wise you could create a simple image serving script to prevent direct navigation by checking the referring

Re: [PHP-DB] Storing Images #2

2010-02-04 Thread Chris
elk dolk wrote: On 3 February 2010 16:07, wrote: I currently have all my images referenced by url in my database and stored in a folder/s and I think I will keep it that way... .. If you put the images OUTSIDE of the

Re: [PHP-DB] Storing images

2010-02-03 Thread Phpster
Sure is. Save the data in a blob field. Lots of examples on the net on how to get it there and back out again. Note that you will also find arguments about whether or not to do it in the first place. I prefer not to, as it causes significant performance issues when the image table gets to

Re: [PHP-DB] Storing images

2010-02-03 Thread Patrick Price
I would say that only if this is going to be a very small project should you think about storing the images in the db. I had a contract job for a real estate company that had stored all their images in the database. They had ~25K rows of data where each image was ~5K and their website was going

<    10   11   12   13   14   15   16   17   18   19   >