RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Brad
Here is where everything stands.. L http://pastie.org/4317155 From: Roberto Carlos Garcia Luis [mailto:legnakar...@gmail.com] Sent: Tuesday, July 24, 2012 5:23 AM To: Brad Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Stuck trying to upload and grab file name Use $_FILES

RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Brad
} } $sqlYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' LINES TERMINATED BY "\r\n" IGNORE 1 LINES' at line 3 Brad From: Roberto Carlos Garcia Luis [mailto:legnakar...@gma

Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Roberto Carlos Garcia Luis
gt; ?> > > ** ** > > ** ** > > array(1) { ["file"]=> array(5) { ["name"]=> string(14) "emailsTest.txt" > ["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14) > "/tmp/phpq8pi44" [&q

RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Brad
line 24 $sqlYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''\' LINES TERMINATED BY "\r\n" IGNORE 1 LINES' at line 3 From: Roberto Carlos Garcia Luis [mailto:legnakar...@gmail.com

Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Roberto Carlos Garcia Luis
AM > *To:* Brad > *Cc:* php-db@lists.php.net 'php-db@lists.php.net');> > *Subject:* Re: [PHP-DB] Stuck trying to upload and grab file name > > ** ** > > You need to use te tmp_name ... The plain text file is in path indicated > by The string... > >

RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Brad
} array(5) { ["name"]=> string(14) "emailsTest.txt" ["type"]=> string(10) "text/plain" ["tmp_name"]=> string(14) "/tmp/php98AolN" ["error"]=> int(0) ["size"]=> int(61) } From: Roberto Carlos G

RE: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Brad
The tmp_file is just gibberish. I ‘truly’ do not want that as the table name. From: Roberto Carlos Garcia Luis [mailto:legnakar...@gmail.com] Sent: Tuesday, July 24, 2012 4:26 AM To: Brad Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Stuck trying to upload and grab file name

Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Roberto Carlos Garcia Luis
Pelase, print The SQL var and show here The result. El martes, 24 de julio de 2012, Roberto Carlos Garcia Luis escribió: > You need to use te tmp_name ... The plain text file is in path indicated > by The string... > > Regards, > > El martes, 24 de julio de 2012, Brad escribió: > > I am making a

Re: [PHP-DB] Stuck trying to upload and grab file name

2012-07-24 Thread Roberto Carlos Garcia Luis
You need to use te tmp_name ... The plain text file is in path indicated by The string... Regards, El martes, 24 de julio de 2012, Brad escribió: > I am making a function that uploads a txt file in csv format and the grabs > uploaded file name and the memberID from the sessions login and names t

Re: [PHP-DB] Re: Database Problems

2012-06-25 Thread tamouse mailing lists
On Mon, Jun 25, 2012 at 9:46 PM, tamouse mailing lists wrote: > On Mon, Jun 25, 2012 at 7:57 AM, Peter Beckman wrote: >>  I'll save you some time, it's not the "where 1" part of the query: >> >>    mysql> select count(*) from numbers where 3 and num like '1212%'; > > The only time the where claus

Re: [PHP-DB] Re: Database Problems

2012-06-25 Thread tamouse mailing lists
On Mon, Jun 25, 2012 at 7:57 AM, Peter Beckman wrote: >  I'll save you some time, it's not the "where 1" part of the query: > >    mysql> select count(*) from numbers where 3 and num like '1212%'; The only time the where clause fails (rightly so) with a single number like what is when you do "whe

Re: [PHP-DB] Re: Database Problems

2012-06-25 Thread Peter Beckman
On Mon, 25 Jun 2012, B. Aerts wrote: On 17/06/12 21:06, Ethan Rosenberg wrote: Dear List - I have a database: +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ Hey Ethan -- Remember that your posts are archived likely f

Re: [PHP-DB] SQL omit record if ever had value set

2012-06-19 Thread Dee Ayy
On Mon, Jun 18, 2012 at 6:26 PM, Matijn Woudt wrote: > On Mon, Jun 18, 2012 at 11:56 PM, Dee Ayy wrote: >> I would like a query that lists records where a column has not taken >> on a specific value when grouped by another column. >> >> N  V >> n1 v1 >> n1 v2 >> n2 v1 >> n2 v2 >> n2 v3 >> n3 v1 >

Re: [PHP-DB] SQL omit record if ever had value set

2012-06-18 Thread Matijn Woudt
On Mon, Jun 18, 2012 at 11:56 PM, Dee Ayy wrote: > I would like a query that lists records where a column has not taken > on a specific value when grouped by another column. > > N  V > n1 v1 > n1 v2 > n2 v1 > n2 v2 > n2 v3 > n3 v1 > > If v3 has ever been set for N, do not list N.  So the result wo

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

2012-06-17 Thread jstarritt
Oliver, Gah -- thank you. James -Original Message- From: "Olivier Desmares" Sent: Saturday, June 16, 2012 10:58am To: "jstarr...@selagodesign.com" , "php-db@lists.php.net" Subject: RE :[PHP-DB] MySQLi Help Hi James, The manual page for mysqli_s

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 wrote: > On Sun, Jun 17, 2012 at 5:55 PM, Ethan Rosenberg wrote: >> At 04:21 PM 6/17/2012, Jim Giner wrote: >> >>> "Ethan Rosenberg" wrote in message >>> news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... >>> > At 03:30 PM 6/17/2012, Jim Giner

Re: [PHP-DB] Re: Database Problems

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

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Jim Giner
"Matijn Woudt" wrote in message news:cac_gtup8fjuv7jyut89w2491nm-7zno8mrj3w0mep6totm2...@mail.gmail.com... On Sun, Jun 17, 2012 at 10:21 PM, Jim Giner wrote: > > "Ethan Rosenberg" wrote in message > news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... >> At 03:30 PM 6/17/2012, Jim Giner wrote: >>>"

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Matijn Woudt
On Sun, Jun 17, 2012 at 10:21 PM, Jim Giner wrote: > > "Ethan Rosenberg" wrote in message > news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... >> At 03:30 PM 6/17/2012, Jim Giner wrote: >>>"Ethan Rosenberg" wrote in message >>>news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... >>> > Dear List - >>> >

Re: [PHP-DB] Re: Database Problems

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

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread DZvonko Nikolov
first rule of computer science: if everything else fails, read the manual!!!or short: RTFM!   --- Regards DZvonko Nikolov dzvo...@gmail.com dzvo...@yahoo.com ---

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Jim Giner
"Ethan Rosenberg" wrote in message news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... > At 03:30 PM 6/17/2012, Jim Giner wrote: >>"Ethan Rosenberg" wrote in message >>news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... >> > Dear List - >> > >> >> > >> > The same query in a PHP program will only give m

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Ethan Rosenberg
At 03:30 PM 6/17/2012, Jim Giner wrote: "Ethan Rosenberg" wrote in message news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... > Dear List - > > > The same query in a PHP program will only give me results for MedRec 10003 > why the "where 1" clause? Do you know what that is for?

[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 retriev

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

2012-06-14 Thread Karl DeSaulniers
On Jun 14, 2012, at 11:46 PM, Bastien wrote: Bastien Koert On 2012-06-15, at 12:35 AM, "Ron Piggott" > wrote: I have setup the following echo after a database query: echo "$email_template['description'] . "\" class= \"contact_center_email_template_maintenance_user_input_data\" />\r \n

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

2012-06-14 Thread Karl DeSaulniers
On Jun 14, 2012, at 11:35 PM, Ron Piggott wrote: I have setup the following echo after a database query: echo "$email_template['description'] . "\" class= \"contact_center_email_template_maintenance_user_input_data\" />\r\n"; ?> What I don’t understand is what to do in the event the variab

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" wrote: > > I have setup the following echo after a database query: > > echo " $email_template['description'] . "\" > class=\"contact_center_email_template_maintenance_user_input_data\" />\r\n"; > ?> > > What I don’t understand is wh

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 wrote: > HI, > > 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 [2] http://www.faqs.org/rfcs/rfc1855

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

2012-05-25 Thread Charles Morris
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 and nsswitch.conf set up correctly? > > Alternatively disable all the ipv6 adapters if you aren't using the

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

2012-05-25 Thread Tom Lloyd
-Original 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 i

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

2012-05-24 Thread Charles Morris
oing 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 Tom Lloyd
carries 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]

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

2012-05-24 Thread Tom Lloyd
May 2012 13:00 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 wrote: > Hi there.  I'm working on a PHP-driven project on Debian Squeeze that > connects to an instance of Microsoft SQ

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 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 on the weekend, both the

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" 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 c

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-19 Thread Matijn Woudt
On Sat, May 19, 2012 at 8:36 PM, Ron Piggott 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 $database1

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

2012-05-19 Thread Peter Lind
On 19 May 2012 20:36, Ron Piggott 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 $database1 without lo

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
Drive | Woodridge, IL 60517 Phone: 630-754-2181 | Fax: 630-754-2581 | Cell: 630-605-2077 cbu...@moreycorp.com | www.moreycorp.com Follow us on Twitter! http://twitter.com/Moreycorp From: Daniel Krook To: php-db@lists.php.net, Cc: Charles W Buege Date: 05/11/2012 09:35 AM Subjec

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 instruct

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 201

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: [PHP

Re: [PHP-DB] School timetable in php

2012-04-21 Thread tamouse mailing lists
On Fri, Apr 20, 2012 at 7:00 AM, Vinay Kannan 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 mean schedule of

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

Re: [PHP-DB] Invitation from Multiply

2012-04-18 Thread tamouse mailing lists
2012/4/18 MA PROPOSISION ELMAZI (via Multiply) : > 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 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 wrote: > On Mon, A

Re: [PHP-DB] Engine?

2012-04-16 Thread Matijn Woudt
On Mon, Apr 16, 2012 at 1:09 PM, Bastien wrote: > > > Bastien Koert > > On 2012-04-16, at 2:21 AM, Karl DeSaulniers 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 fe

Re: [PHP-DB] Engine?

2012-04-16 Thread Bastien
Bastien Koert On 2012-04-16, at 2:21 AM, Karl DeSaulniers 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 etcbut >> haven'

Re: [PHP-DB] Engine?

2012-04-15 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] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
"Rikin Parekh" 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. You solve

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 wrote: > > "Rikin Parekh" wrote in message > news:fad9d02d-2add-4a31-b118-81d56183e...@gmail.com... > Thi

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

2012-04-13 Thread Jim Giner
"Rikin Parekh" 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 errors in quest

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, "J

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 wrote: > On Fri, Apr 6, 2012 at 12:33 PM, Ken Keefe 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 creat

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 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 the problem. The

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 hav

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" 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: $_Request is not the sam

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 wrote: > |DATE| >

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

2012-03-30 Thread Gavin
|DATE| => MySQL permits some keywords to be used as unquoted identifiers because many people previously used them. Examples are those in the following list: * |ACTION| * |BIT|

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

2012-03-30 Thread Lars Nielsen
fre, 30 03 2012 kl. 20:00 +0200, skrev Matijn Woudt: > On Fri, Mar 30, 2012 at 7:49 PM, Jim Giner > wrote: > > > > ""Jim Giner"" wrote in message > > news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2... > >> === > >> Martijn & Jim - > >> > >> Is it just the date that is the problem? > >

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 wrote: > > ""Jim Giner"" 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

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

2012-03-30 Thread Jim Giner
""Jim Giner"" 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 what I am d

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 Ethan Rosenberg
See below- - Original Message - From: "Ethan Rosenberg" Newsgroups: php.db To: "Matijn Woudt" Cc: "php-db-lists.php.net" ; Sent: Friday, March 30, 2012 1:00 PM Subject: Re: [PHP-DB] search of data base - again At 07:15 PM 3/29/2012, Matijn Woudt w

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 un

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

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-29 Thread Matijn Woudt
On Fri, Mar 30, 2012 at 1:10 AM, Ethan Rosenberg 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] 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, Govinda

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 > $_SESSION['

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] Excel to HTML table using PHP

2012-03-21 Thread Amit Tandon
Try this link. 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 ficti

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 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 is empty echo out only t

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 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. plugin->ListViewValue()=="") { echo ''; }

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 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 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] Help with If else if

2012-03-13 Thread Matijn Woudt
On Tue, Mar 13, 2012 at 4:53 PM, Gu®u 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 is empty echo out o

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 f

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 faceb

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 Matijn Woudt
On Tue, Mar 13, 2012 at 3:06 PM, Gu®u 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 $search->plugin->ListViewValue()=="" and $sea

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 wrote: > On Tue, Mar 13, 2012 at 1:03 PM, Gu®u wrote: > > Hi, > > > > Please help me with this code. I have 2 different fields in mysql table. > > What I want is if the fi

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 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 wrong, what it outputs

Re: [PHP-DB] Select from multiple tables

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

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 = 1

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 Vidyal

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 y

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 identify

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 wrote: > Hi,

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 Matijn Woudt
On Wed, Feb 29, 2012 at 3:01 PM, Kranthi Krishna 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 refers

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 de

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 really

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 N

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 N

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 st

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 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. I

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

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 connection

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