Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Ethan Rosenberg
At 04:21 PM 6/17/2012, Jim Giner wrote: Ethan Rosenberg eth...@earthlink.net wrote in message news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... At 03:30 PM 6/17/2012, Jim Giner wrote: Ethan Rosenberg eth...@earthlink.net wrote in message news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... Dear

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Matijn Woudt
On Sun, Jun 17, 2012 at 10:21 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Ethan Rosenberg eth...@earthlink.net wrote in message news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... At 03:30 PM 6/17/2012, Jim Giner wrote: Ethan Rosenberg eth...@earthlink.net wrote in message

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Jim Giner
Matijn Woudt tijn...@gmail.com wrote in message news:cac_gtup8fjuv7jyut89w2491nm-7zno8mrj3w0mep6totm2...@mail.gmail.com... On Sun, Jun 17, 2012 at 10:21 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Ethan Rosenberg eth...@earthlink.net wrote in message

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread tamouse mailing lists
On Sun, Jun 17, 2012 at 5:55 PM, Ethan Rosenberg eth...@earthlink.net wrote: At 04:21 PM 6/17/2012, Jim Giner wrote: Ethan Rosenberg eth...@earthlink.net wrote in message news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... At 03:30 PM 6/17/2012, Jim Giner wrote: Ethan Rosenberg

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread tamouse mailing lists
On Sun, Jun 17, 2012 at 8:22 PM, tamouse mailing lists tamouse.li...@gmail.com wrote: On Sun, Jun 17, 2012 at 5:55 PM, Ethan Rosenberg eth...@earthlink.net wrote: At 04:21 PM 6/17/2012, Jim Giner wrote: Ethan Rosenberg eth...@earthlink.net wrote in message

[PHP-DB] RE :[PHP-DB] MySQLi Help

2012-06-16 Thread Olivier Desmares
Hi James, The manual page for mysqli_stmt::execute has the following note : When using mysqli_stmt_execute(), the mysqli_stmt_fetch() function must be used to fetch the data prior to performing any additional queries. So you cannot execute the inner (sub) query without first

Re: [PHP-DB] Quotation marks in HTML form values

2012-06-14 Thread Bastien
Bastien Koert On 2012-06-15, at 12:35 AM, Ron Piggott ron.pigg...@actsministries.org wrote: I have setup the following echo after a database query: ?php echo input type=\text\ name=\description\ value=\ . $email_template['description'] . \

Re: [PHP-DB] ERROR W/ SQLSRV, PHP 5.4 SYMFONY!!!

2012-06-07 Thread Matijn Woudt
On Thu, Jun 7, 2012 at 7:42 AM, OJFR misabe...@infomed.sld.cu wrote: HI, Snip rude text OSAIN. Hi, You might want to read the PHP mailing list rules[1] and RFC 1855[2] before posting to this mailing list again. - Matijn [1] http://www.php.net/reST/php-src/trunk_README.MAILINGLIST_RULES

RE: [PHP-DB] Mysterious 5 second delay on sybase_connect()

2012-05-25 Thread Tom Lloyd
Message- From: charlesmor...@gmail.com [mailto:charlesmor...@gmail.com] On Behalf Of Charles Morris Sent: 24 May 2012 17:40 To: Tom Lloyd Cc: Matijn Woudt; php-db@lists.php.net Subject: Re: [PHP-DB] Mysterious 5 second delay on sybase_connect() Is it's own host name in the hosts file

Re: [PHP-DB] Mysterious 5 second delay on sybase_connect()

2012-05-25 Thread Charles Morris
@lists.php.net Subject: Re: [PHP-DB] Mysterious 5 second delay on sybase_connect() Is it's own host name in the hosts file and nsswitch.conf set up correctly? Alternatively disable all the ipv6 adapters if you aren't using them. On Thu, May 24, 2012 at 12:23 PM, Tom Lloyd tomll...@wallcolmonoy.co.uk

Re: [PHP-DB] Mysterious 5 second delay on sybase_connect()

2012-05-24 Thread Matijn Woudt
On Thu, May 24, 2012 at 10:51 AM, Tom Lloyd tomll...@wallcolmonoy.co.uk wrote: Hi there.  I'm working on a PHP-driven project on Debian Squeeze that connects to an instance of Microsoft SQL Server on Windows Server 2008. I'm using the sybase extensions to PHP. Since I rebooted the webserver

RE: [PHP-DB] Mysterious 5 second delay on sybase_connect()

2012-05-24 Thread Tom Lloyd
To: Tom Lloyd Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Mysterious 5 second delay on sybase_connect() On Thu, May 24, 2012 at 10:51 AM, Tom Lloyd tomll...@wallcolmonoy.co.uk wrote: Hi there.  I'm working on a PHP-driven project on Debian Squeeze that connects to an instance of Microsoft SQL

RE: [PHP-DB] Mysterious 5 second delay on sybase_connect()

2012-05-24 Thread Tom Lloyd
on doing what it was doing. Why would it be doing a DNS lookup for the IPv6 address of its own hostname? And more urgently, how can I stop it? -Original Message- From: Tom Lloyd Sent: 24 May 2012 16:26 To: 'Matijn Woudt' Cc: php-db@lists.php.net Subject: RE: [PHP-DB] Mysterious 5 second

Re: [PHP-DB] Mysterious 5 second delay on sybase_connect()

2012-05-24 Thread Charles Morris
for the IPv6 address of its own hostname?   And more urgently, how can I stop it? -Original Message- From: Tom Lloyd Sent: 24 May 2012 16:26 To: 'Matijn Woudt' Cc: php-db@lists.php.net Subject: RE: [PHP-DB] Mysterious 5 second delay on sybase_connect() I'm getting increasingly suspicious

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

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

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

2012-05-20 Thread Bastien
Bastien Koert On 2012-05-19, at 2:36 PM, Ron Piggott ron.pigg...@actsministries.org wrote: How do I connect to multiple mySQL databases using Prepared Statements ? I have the syntax === $dsh = 'mysql:host=localhost;dbname='.$database3; $dbh = new PDO($dsh, $username, $password);

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

2012-05-19 Thread Peter Lind
On 19 May 2012 20:36, Ron Piggott ron.pigg...@actsministries.org wrote: How do I connect to multiple mySQL databases using Prepared Statements ? I have the syntax === $dsh = 'mysql:host=localhost;dbname='.$database3; $dbh = new PDO($dsh, $username, $password); === I want to connect to

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

2012-05-19 Thread Matijn Woudt
On Sat, May 19, 2012 at 8:36 PM, Ron Piggott ron.pigg...@actsministries.org wrote: How do I connect to multiple mySQL databases using Prepared Statements ? I have the syntax === $dsh = 'mysql:host=localhost;dbname='.$database3; $dbh = new PDO($dsh, $username, $password); === I want to

Re: [PHP-DB] Installing IBM DB2 drivers onto an Apache Server under Fedora 16 x64 to access IBM POWER7 DB2 via PHP....

2012-05-16 Thread Charles W Buege
...@moreycorp.com | www.moreycorp.com Follow us on Twitter! http://twitter.com/Moreycorp From: Daniel Krook kr...@us.ibm.com To: php-db@lists.php.net, Cc: Charles W Buege cbu...@moreycorp.com Date: 05/11/2012 09:35 AM Subject:Re: [PHP-DB] Installing IBM DB2 drivers onto

Re: [PHP-DB] Installing IBM DB2 drivers onto an Apache Server under Fedora 16 x64 to access IBM POWER7 DB2 via PHP....

2012-05-11 Thread Daniel Krook
Hi Charles, So you just need to get the Apache on Fedora configured to connect to the DB2 servers on AIX? This is a good a list to ask as any :) Here are the steps I would take (some of which you might have already done... so it's up to you whether you want to start fresh or tweak my

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

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

RE: [PHP-DB] PHP Database Problems

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

Re: [PHP-DB] School timetable in php

2012-04-22 Thread tamouse mailing lists
On Fri, Apr 20, 2012 at 7:00 AM, Vinay Kannan viny...@gmail.com wrote: I am trying to develop a school time table system in php mysql, anybody has any headsup on the same, i was thinking about some existing scripts to take a look at. Not entirely clear what is meant by time table -- do you

Re: [PHP-DB] School timetable in php

2012-04-20 Thread Karl DeSaulniers
No example to give, but I would search the term below in your search engine of choice. I think you'll find something useful at least to start with. If not a working example. php mysql time table example or php mysql timesheet example (I'm thinking you can go from here and customize if no

Re: [PHP-DB] Invitation from Multiply

2012-04-18 Thread tamouse mailing lists
2012/4/18 MA PROPOSISION ELMAZI (via Multiply) multi...@multiply.com: Check out my Multiply site oh i can hardly wait to see this... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Engine?

2012-04-16 Thread Karl DeSaulniers
On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote: Hello, I've always been left wondering what Engine to use while creating tables, I've read quite a few times about the same on wiki, articles etcbut haven't actually been able to decide. I wanted to know whats the storage engine used on

Re: [PHP-DB] Engine?

2012-04-16 Thread Bastien
Bastien Koert On 2012-04-16, at 2:21 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote: Hello, I've always been left wondering what Engine to use while creating tables, I've read quite a few times about the same on wiki, articles

Re: [PHP-DB] Engine?

2012-04-16 Thread Matijn Woudt
On Mon, Apr 16, 2012 at 1:09 PM, Bastien phps...@gmail.com wrote: Bastien Koert On 2012-04-16, at 2:21 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote: Hello, I've always been left wondering what Engine to use while creating tables, I've

Re: [PHP-DB] Engine?

2012-04-16 Thread Vinay Kannan
Awesome Thank You Guys! A better scalable DB was on my mind, looks like I might have to go for much before I thought I might have to go ahead with :) Going through the resources provided, Thank You for the headsup!! Vinay Kannan. On Mon, Apr 16, 2012 at 4:44 PM, Matijn Woudt tijn...@gmail.com

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Rikin Parekh
This is the sample data provided to me. I need to query this data only. And column name can be without spaces. I need to know the query that will give me the result irrespective of the syntax errors in question table. Can someone please guide or help? Thanks, Rikin On Apr 13, 2012, at 9:12,

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
Rikin Parekh riki...@gmail.com wrote in message news:fad9d02d-2add-4a31-b118-81d56183e...@gmail.com... This is the sample data provided to me. I need to query this data only. And column name can be without spaces. I need to know the query that will give me the result irrespective of the syntax

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Rikin Parekh
I got the answer. My query works perfectly fine. Earlier I had problems in configuring mySQL Workbench so I could not try. Thank you guys. Rikin On Fri, Apr 13, 2012 at 10:28 AM, Jim Giner jim.gi...@albanyhandball.comwrote: Rikin Parekh riki...@gmail.com wrote in message

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
Rikin Parekh rpare...@umd.edu wrote in message news:CALbBjtctPawe=qyuvqWZvG3nq_Tw7PwKoe-hhi5fkYGec=6...@mail.gmail.com... I got the answer. My query works perfectly fine. Earlier I had problems in configuring mySQL Workbench so I could not try. Thank you guys. Rikin No thanks necessary.

Re: [PHP-DB] Multiple result sets with a prepared statement in mysqli

2012-04-06 Thread tamouse mailing lists
On Fri, Apr 6, 2012 at 12:33 PM, Ken Keefe kjke...@illinois.edu wrote: I am trying to use mysqli's prepared statements to execute a stored procedure that returns multiple result sets. I've been struggling with this for some time now. I have created a short example test script that demonstrates

Re: [PHP-DB] Multiple result sets with a prepared statement in mysqli

2012-04-06 Thread tamouse mailing lists
On Fri, Apr 6, 2012 at 2:02 PM, tamouse mailing lists tamouse.li...@gmail.com wrote: On Fri, Apr 6, 2012 at 12:33 PM, Ken Keefe kjke...@illinois.edu wrote: I am trying to use mysqli's prepared statements to execute a stored procedure that returns multiple result sets. I've been struggling with

Re: [PHP-DB] Re: foreach

2012-04-05 Thread Karl DeSaulniers
And POST[] is not the same as $_POST[] Karl Sent from losPhone On Apr 5, 2012, at 3:24 PM, Jim Giner jim.gi...@albanyhandball.com wrote: I don't know about others, but I can't make sense of this - way too much presented with no idea of what I am looking at - code or output. One thing:

Re: [PHP-DB] Re: foreach

2012-04-05 Thread Kris Carlson
Send the code around line 198, say 170 to 210. On Apr 5, 2012, at 8:42 PM, Al wrote: On 4/5/2012 4:15 PM, Ethan Rosenberg wrote: Dear Lists - I know I am missing something fundamental - but I have no idea where to start to look. Here are code snippets: I have truncated the

Re: [PHP-DB] search of data base - again

2012-03-31 Thread Gonzalo
Why don´t you echo the $sql2 to see the query. That´s would be very helpful. Also, are you closing the ')' in the 'values'? Greetings On Fri, Mar 30, 2012 at 3:55 PM, Gavin gavin.chalk...@gmail.com wrote: |DATE|

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
I agree with Martin's assessment. Took me awhile to always remember to have the date in the correct format. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Ethan Rosenberg
At 07:15 PM 3/29/2012, Matijn Woudt wrote: On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg eth...@earthlink.net wrote: Sending again, since no response on 1st try. Ethan == Dear List I am trying to insert data into a table, with no success. I have two tables: mysql

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
I think MySQL wants the date in -M-D format, did you try changing $Date = date('M d Y'); to $Date = date('Y-m-d'); - Matijn Tru dat. But mySql doesn't want the dashes embedded. The format string should be Ymd instead. -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Ethan Rosenberg
See below- - Original Message - From: Ethan Rosenberg eth...@earthlink.net Newsgroups: php.db To: Matijn Woudt tijn...@gmail.com Cc: php-db-lists.php.net php-db@lists.php.net; jim.gi...@albanyhandball.com Sent: Friday, March 30, 2012 1:00 PM Subject: Re: [PHP-DB] search of data base

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
=== Martijn Jim - Is it just the date that is the problem? Yes. Tru dat. But mySql doesn't want the dashes embedded. The format string should be Ymd instead. That's what I am doing. No luck. Ethan * You're using a format with just Ymd in it (no dashes)? Can you post

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
Jim Giner jim.gi...@albanyhandball.com wrote in message news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2... === Martijn Jim - Is it just the date that is the problem? Yes. Tru dat. But mySql doesn't want the dashes embedded. The format string should be Ymd instead. That's

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Matijn Woudt
On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Jim Giner jim.gi...@albanyhandball.com wrote in message news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2... === Martijn Jim - Is it just the date that is the problem? Yes. Tru dat.  But mySql

Re: [PHP-DB] Session and Access Privilages.

2012-03-29 Thread Trinath Somanchi
Hi- Since you are checking the authtype variable in the environmental variable for each page which is requested, There cannot be any chance for a intruder to get access to the page. But then, for an enhanced security, do maintain a table in db with relation between authtype and access to page and

Re: [PHP-DB] Session and Access Privilages.

2012-03-29 Thread Govinda
Hey, I am working on the application, thought its not OOP currently, I plan to take it further in a year or so. Right now, I have 4 access levels which define what the users can do on the application. Based on the access levels defined, a session varialble is set called

Re: [PHP-DB] Session and Access Privilages.

2012-03-29 Thread Vinay Kannan
Yup, With some help from Jey earlier today, I was able to figure it out.. I only realized it later, how easy it was since all the auth types were being set already, the same piece of code at the beginning of every page should have been good ! Thanks, Vinay On Thu, Mar 29, 2012 at 7:28 PM,

Re: [PHP-DB] search of data base - again

2012-03-29 Thread Matijn Woudt
On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg eth...@earthlink.net wrote: Sending again, since no response on 1st try. Ethan == Dear List I am trying to insert data into a table, with no success. I have two tables: mysql describe Visit3;

Re: [PHP-DB] Excel to HTML table using PHP

2012-03-21 Thread Amit Tandon
Try this linkhttp://devzone.zend.com/27/reading-and-writing-spreadsheets-with-php/. What i understand is that u do not want the end user to open the excel sheet. However, u have to read the data part and display in HTML using PHP/Javascript regds amit The difference between fiction

Re: [PHP-DB] Help with If else if

2012-03-18 Thread Tamara Temple
On Tue, 13 Mar 2012 17:33:43 +0530, Gu®u nagendra802...@gmail.com sent: Hi, Please help me with this code. I have 2 different fields in mysql table. What I want is if the field is empty don't show the image. Please look at the code below. ?php if($search-plugin-ListViewValue()==)

Re: [PHP-DB] Help with If else if

2012-03-18 Thread Tamara Temple
On Tue, 13 Mar 2012 21:23:57 +0530, Gu®u nagendra802...@gmail.com sent: No Michael, your code is also not working. What you have understood is correct. let me explain it to others too. If variable twitter and facebook are empty don't echo anything, if variable twitter has a value and facebook

Re: [PHP-DB] Re: confirm subscribe to php-db@lists.php.net

2012-03-17 Thread Gu®u
On Sat, Mar 17, 2012 at 1:37 AM, nathhuan nathh...@cisco.com wrote: On 03/17/2012 04:30 PM, php-db-h...@lists.php.net wrote: Hi! This is the ezmlm program. I'm managing the php-db@lists.php.net mailing list. I'm working for my owner, who can be reached at php-db-ow...@lists.php.net. To

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 1:03 PM, Gu®u nagendra802...@gmail.com wrote: Hi, Please help me with this code. I have 2 different fields in mysql table. What I want is if the field is empty don't show the image. Please look at the code below. I have looked at it. Maybe you should tell what is

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
The issue is both the images are echoing and no if else statement is working. On Tue, Mar 13, 2012 at 7:22 PM, Matijn Woudt tijn...@gmail.com wrote: On Tue, Mar 13, 2012 at 1:03 PM, Gu®u nagendra802...@gmail.com wrote: Hi, Please help me with this code. I have 2 different fields in mysql

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 3:06 PM, Gu®u nagendra802...@gmail.com wrote: The issue is both the images are echoing and no if else statement is working. First of all, please bottom post on this (and probably any) mailing list. You should perhaps provide what the contents of

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Michael Stowe
From looking at your code, the issue is that your if statements are checking for the same criteria as your else statements, meaning that if the string is empty () the if statements will be triggered, and since the if statements are true, the elseif statement will not be. Or if the string isn't

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
No Michael, your code is also not working. What you have understood is correct. let me explain it to others too. If variable twitter and facebook are empty don't echo anything, if variable twitter has a value and facebook is empty echo out only twitter, if variable twitter has no value and

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Michael Stowe
Hmm, what happens with the code I sent you? Just tested it on my end and worked exactly as expected. Try doing a var_dump($search-plugin-ListViewValue(), $search-facebook-ListViewValue()); to make sure the data being returned is what's expected... you should be getting string(0) returned for

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 4:53 PM, Gu®u nagendra802...@gmail.com wrote: No Michael, your code is also not working. What you have understood is correct. let me explain it to others too. If variable twitter and facebook are empty don't echo anything, if variable twitter has a value and facebook

Re: [PHP-DB] Help with If else if

2012-03-13 Thread Gu®u
I tried the below code too considering may be the localhost is really dumb and we need to tell each and every condition. But still its not working :( $tweet = $search-plugin-ListViewValue(); $fb = $search-facebook-ListViewValue(); if($tweet== $fb==) {

Re: [PHP-DB] Select from multiple tables

2012-03-01 Thread Kranthi Krishna
Kranthi. http://goo.gl/e6t3 On 1 March 2012 21:47, Carl Michael Skog cms...@gmail.com wrote: -- Vidarebefordrat meddelande -- Från: Carl Michael Skog cms...@gmail.com Datum: 1 mars 2012 17:12 Ämne: Re: [PHP-DB] Select from multiple tables Till: Kranthi Krishna kranthi

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Matijn Woudt
On Wed, Feb 29, 2012 at 3:01 PM, Kranthi Krishna kranthi...@gmail.com wrote: Hi all, Say I have an object like array    schoolName = string    board = array         string         string I generally create  two MySql tables schools: id PRIMARY KEY, SchoolName boards: id FOREGIN KEY

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Kranthi Krishna
Hi, Thanks for the input. I have seen some tutorials on joins, they all suggest that MySql returns multiple rows For example -- School | Board 1 -- School | Board 1 - Now if I have another one-to-many relation

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Kranthi Krishna
Hi, The examples I saw were regarding cartesian join not inner join. I will read about inner joins. Also, the example i mentioned seems to be a mistake. Both school and type will not be similar at the same time Kranthi. http://goo.gl/e6t3 On 1 March 2012 09:26, Kranthi Krishna

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Amit Tandon
Dear Kranthi You have to be clear what you decide especially when you are getting multiple rows. To get just a single row you can use LIMIT clause. But it would return only one row. Now you have to decide which row. So i think you decide on what you require and see how can you uniquely

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Karl DeSaulniers
Try DISTINCT On Feb 29, 2012, at 10:28 PM, Amit Tandon wrote: Dear Kranthi You have to be clear what you decide especially when you are getting multiple rows. To get just a single row you can use LIMIT clause. But it would return only one row. Now you have to decide which row. So i think

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Kranthi Krishna
Hi all, SELECT DISTINCT s.Title, b.Board_id, t.type FROM school s, board_entries b, schooltypeentries t WHERE s.School_id = 1698 AND b.School_id = 1698 AND t.schoolid = 1698 this SQL query gives me Kendriya Vidyalaya 15 Kick Boxing Kendriya Vidyalaya 15 Karate Kendriya

Re: [PHP-DB] Select from multiple tables

2012-02-29 Thread Karl DeSaulniers
This is just a stab in the dark and may be in the wrong order. If it does not work I apologize. SELECT s.Title, (SELECT DISTINCT b.Board_id), (SELECT DISTINCT t.type), (SELECT s.School_id AND b.School_id AND t.schoolid AS id ) FROM school s, board_entries b, schooltypeentries t WHERE id =

Re: [PHP-DB] PDO Vs MySQLi Vs SQL Queries.

2012-02-28 Thread Donahue Trevor
Hi Vinay, No, using native mysql_* statement isn't always faster. Advantages are obvious, as mentioned in the article you shared (object mapping, security, performance), there's always things like caching and other stuff you don't want to reinvent the wheel for and on big projects tend to be

Re: [PHP-DB] PDO Vs MySQLi Vs SQL Queries.

2012-02-28 Thread Vinay Kannan
Hi Trevor, Thank You for your suggestion, yeah i think caching is something i definitely want to look at and something thats important, and there is a big project coming up, its pretty much the biggest i've taken up so far, theres also a mobile app for android which needs to be done, so caching

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Amit Tandon
Dear Ethan It seems you are trying to build a query.But you are not getting field names. If you required field names then change the following line to foreach ( $allowed_fields AS $field = $_POST['field']) to foreach ( $allowed_fields AS $field) This would convert the variable field to value.

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Ethan Rosenberg
At 12:13 AM 2/10/2012, Amit Tandon wrote: Dear Ethan It seems you are trying to build a query.But you are not getting field names. If you required field names then change the following line to foreach ( $allowed_fields AS $field = $_POST['field']) to foreach ( $allowed_fields AS $field) This

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Amit Tandon
Dear Ethan The line you are getting is because the $_POST[fieldname] is blank. So for the following line if ( ! empty( $_POST['field'] ) ) change it to if ( ! empty( $_POST[$field] ) ) Your line : Program is searxchinbg for variable name field New line : The Program is seacging for varable

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Ethan Rosenberg
At 12:48 AM 2/10/2012, Amit Tandon wrote: Dear Ethan The line you are getting is because the $_POST[fieldname] is blank. So for the following line  if ( ! empty( $_POST['field'] ) ) change it to  if ( ! empty( $_POST[$field] ) ) Your line : Program is searxchinbg for variable name field

Re: [PHP-DB] Problem w/query - again - CORRECTION

2012-02-09 Thread Ethan Rosenberg
At 12:48 AM 2/10/2012, Amit Tandon wrote: Dear Ethan The line you are getting is because the $_POST[fieldname] is blank. So for the following line  if ( ! empty( $_POST['field'] ) ) change it to  if ( ! empty( $_POST[$field] ) ) Your line : Program is searxchinbg for variable name field

Re: [PHP-DB] Multiple Access to Database - The Answer

2012-02-05 Thread Govinda
[snip] PS: I respectfully request that if a user asks a question, that an explicit answer be given, not just a reference to the manual. It could be then followed by a manual reference. The user then has his answer and can look up more detail in the manual. Thanks. Ethan

Re: [PHP-DB] File Upload in PHP

2012-02-02 Thread Trinath Somanchi
Hi- Thanks for the reply. I'm near to the solution but was struct at teh end. I have configured post_max_size, memory_limit, max_upload_filesize to '-1' and max_execution_time to ' 0'. and restarted the server. But then, Apache and Browser problems were in place. In IE6 and IE7, The

Re: [PHP-DB] File Upload in PHP

2012-02-01 Thread Karl DeSaulniers
I would set post_max_size in your htaccess for the directory where your upload.php file is. Or base64 your file and upload 8Mb chunks, then reassemble and store. but I am sure someone has a better solution than I. also, I may be wrong on this too, but this is a PHP General question, not

Re: [PHP-DB] File Upload in PHP

2012-02-01 Thread Karl DeSaulniers
Sry, not better help... better luck. :) Best, Karl On Feb 1, 2012, at 7:01 AM, Karl DeSaulniers wrote: I would set post_max_size in your htaccess for the directory where your upload.php file is. Or base64 your file and upload 8Mb chunks, then reassemble and store. but I am sure someone

Re: [PHP-DB] File Upload in PHP

2012-02-01 Thread Ege Sertçetin
Hi Trinath, You can use ini_set() function to change ini settings only for your upload script. http://php.net/manual/en/function.ini-set.php However, you cannot change any parameter you want. There is a list about php.ini parameters. As I remember, you just can set PHP_INI_ALL and

Re: [PHP-DB] Subscription Suspensions

2012-01-31 Thread Matijn Woudt
On Tue, Jan 31, 2012 at 6:35 PM, Ron Piggott ron.pigg...@actsministries.org wrote: Hi Everyone. I manage an e-mail list.  I am trying to add a new function into it: suspensions.  The idea is that someone wouldn’t have to unsubscribe.  Instead there would be a record of their suspension in

Re: [PHP-DB] Subscription Suspensions

2012-01-31 Thread Ron Piggott
On Tue, Jan 31, 2012 at 6:35 PM, Ron Piggott ron.pigg...@actsministries.org wrote: Hi Everyone. I manage an e-mail list. I am trying to add a new function into it: suspensions. The idea is that someone wouldn’t have to unsubscribe. Instead there would be a record of their suspension in

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-27 Thread Lester Caine
David McGlone wrote: I started with PHP just before PHP5 was finally released, so never used PHP4, and found ADOdb very early on so have never used anything else. One gets stuck in one's way when something simply works ... Probably why I'm finding PDO such a backwards step having been

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-26 Thread Lester Caine
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 http://adodb.sourceforge.net/#docs ... has ANYBODY seen it

Re: [PHP-DB] php adodb book suggestins

2012-01-26 Thread Matijn Woudt
On Thu, Jan 26, 2012 at 12:06 PM, David McGlone da...@dmcentral.net 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] Storing multiple items in one MySQL field?

2012-01-18 Thread Niel Archer
Ok, so getting closer to the goal.. slight hiccup. I am experimenting with some UNION and INNER JOIN and don't know if I am doing this correctly or if this is the correct way to do this. PREFACE: I have now moved colors and sizes to their own tables and added a product options table

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-18 Thread Karl DeSaulniers
Hi Niel, Thanks for taking the time to respond. Comments below. On Jan 18, 2012, at 11:14 AM, Niel Archer wrote: Ok, so getting closer to the goal.. slight hiccup. I am experimenting with some UNION and INNER JOIN and don't know if I am doing this correctly or if this is the correct way to do

Re: [PHP-DB] Multiple Access to Database

2012-01-17 Thread Matijn Woudt
Ethan, you've send the same question a few days ago. There's no point in asking the same question twice. Matijn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-16 Thread Karl DeSaulniers
Ok, so getting closer to the goal.. slight hiccup. I am experimenting with some UNION and INNER JOIN and don't know if I am doing this correctly or if this is the correct way to do this. PREFACE: I have now moved colors and sizes to their own tables and added a product options table that

RE: [PHP-DB] Re: Multiple Access to Database

2012-01-15 Thread Toby Hart Dyke
..and when you've read all that, go here: http://www.mysql.com/downloads/workbench/ Much easier than doing it all on the command line! Toby -Original Message- From: David Robley [mailto:robl...@aapt.net.au] Sent: Sunday, January 15, 2012 10:46 AM To: php-db@lists.php.net Subject:

Re: [PHP-DB] Multiple Access to Database

2012-01-14 Thread Karl DeSaulniers
I believe you would set that up through PHP. Best, Karl On Jan 14, 2012, at 9:55 PM, Ethan Rosenberg wrote: Dear List - I have a database: mysql show tables; +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 |

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-13 Thread B. Aerts
On 13/01/12 03:47, tamouse mailing lists wrote: On Thu, Jan 12, 2012 at 1:12 AM, B. Aertsba_ae...@yahoo.com wrote: Karl, I'm somewhat limited to reading posts, so I might have missed something, but can you explain why you wanted to avoid the 3rd table solution ? Because depending on that

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-12 Thread Karl DeSaulniers
On Jan 12, 2012, at 1:12 AM, B. Aerts wrote: Karl, I'm somewhat limited to reading posts, so I might have missed something, but can you explain why you wanted to avoid the 3rd table solution ? Because depending on that question, I can offer two other solutions, but they have their own

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-12 Thread tamouse mailing lists
On Thu, Jan 12, 2012 at 1:12 AM, B. Aerts ba_ae...@yahoo.com wrote: Karl, I'm somewhat limited to reading posts, so I might have missed something, but can you explain why you wanted to avoid the 3rd table solution ? Because depending on that question, I can offer two other solutions, but

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-11 Thread Karl DeSaulniers
On Jan 11, 2012, at 12:45 AM, Peter Lind wrote: On Jan 11, 2012 7:13 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Jan 10, 2012, at 10:49 PM, Karl DeSaulniers wrote: On Jan 10, 2012, at 9:30 AM, B. Aerts wrote: On 08/01/12 23:35, Karl DeSaulniers wrote: On Jan 8, 2012, at

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-11 Thread Karl DeSaulniers
On Jan 11, 2012, at 3:29 AM, Karl DeSaulniers wrote: On Jan 11, 2012, at 12:45 AM, Peter Lind wrote: On Jan 11, 2012 7:13 AM, Karl DeSaulniers k...@designdrumm.com wrote: On Jan 10, 2012, at 10:49 PM, Karl DeSaulniers wrote: On Jan 10, 2012, at 9:30 AM, B. Aerts wrote: On 08/01/12

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-11 Thread Peter Lind
*snip* How does set() know the difference between say the first row (1) + the fifth row (5) and the second row (2) + fouth row (4) in the bit set? The sum of both are the same. I am sure I am congfusing something. Ummm ... if you're asking how set figures out how bitmasks differ, then yes,

<    2   3   4   5   6   7   8   9   10   11   >