Re: [PHP-DB] Re: php-db foreign key

2011-08-09 Thread Chris Stinemetz
Your php code had more than one query running (one inside the other). It's the outer query that runs twice, not the inner one returning double the results Thanks Peter, Do you have any suggestions on how to fix this? Thank you, Chris -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] Re: php-db foreign key

2011-08-09 Thread Peter Lind
On 9 August 2011 22:25, Chris Stinemetz chrisstinem...@gmail.com wrote: Your php code had more than one query running (one inside the other). It's the outer query that runs twice, not the inner one returning double the results Thanks Peter, Do you have any suggestions on how to fix this?

Re: [PHP-DB] Re: php-db foreign key

2011-08-09 Thread Chris Stinemetz
Yes, debug your code and figure out why it's looping twice instead. For instance, try the other query in the mysql console. Thank you! It was the first query. I put a LIMIT 1 on it and now it is working correctly. I appreciate your help! Thank you, Chris -- PHP Database Mailing List

Re: [PHP-DB] Re: php-db foreign key

2011-08-09 Thread Peter Lind
On 9 August 2011 22:38, Chris Stinemetz chrisstinem...@gmail.com wrote: Yes, debug your code and figure out why it's looping twice instead. For instance, try the other query in the mysql console. Thank you! It was the first query. I put a LIMIT 1 on it and now it is working correctly. I

Re: [PHP-DB] Re: clues to cache-like behavior

2011-08-09 Thread Donovan Brooke
Jim Giner wrote: So you're saying a page refresh in your browser doesn't cure the problem? Hi, sorry for the delay.. Yes, page refresh/s is basically what I am doing to get to the latest edits (by clicking in and out of the edit area). Reloading the page one or more times works as well.

[PHP-DB] clues to cache-like behavior

2011-08-08 Thread Donovan Brooke
Hello, I took some PHP/MySQL code that seemed to be working fine from a LAMP setup and brought it to a MAMP (mac OS) setup. Now I am seeing a cache-like behavior in my admin forms, where my last changes don't stick. To be clearer, I go to make a database change in the forms I built to

[PHP-DB] Left Join

2011-08-07 Thread Chris Stinemetz
I am tyring to build a query that will take the most recent stores.store_date column then join it with store_list.store_name where store_list.store_name and stores.store_subject match then return the most recent stores.store_date. I am guessing this will require some sort of join. I have been

Re: [PHP-DB] Left Join

2011-08-07 Thread Peter Lind
Maybe it's just me, but I can't see anything that would work as foreign key for you to join on - neither table seems to have a foreign key On 7 August 2011 21:53, Chris Stinemetz chrisstinem...@gmail.com wrote: I am tyring to build a query that will take the most recent stores.store_date column

Re: [PHP-DB] Left Join

2011-08-07 Thread Chris Stinemetz
On Sun, Aug 7, 2011 at 3:00 PM, Peter Lind peter.e.l...@gmail.com wrote: Maybe it's just me, but I can't see anything that would work as foreign key for you to join on - neither table seems to have a foreign key Sorry for my ignorance. How do I create the foreign key? The two columns from

RE: [PHP-DB] Left Join

2011-08-07 Thread Toby Hart Dyke
my permission to tell the owner off ;-) Not that this really has anything to do with PHP, but I won't say anything if you won't. Toby -Original Message- From: Chris Stinemetz [mailto:chrisstinem...@gmail.com] Sent: Sunday, August 07, 2011 9:33 PM To: Peter Lind Cc: php-db

Re: [PHP-DB] Insert query error

2011-08-06 Thread Gavin Chalkley
Chris, Why not escape, and extract the data prior to Insert string? On 06/08/2011 05:41, Chris Stinemetz wrote: I am getting the following error trying to run the below query. Any suggestions on what I am doing wrong? Thank you, Something went wrong while inserting your store visitCannot add

[PHP-DB] RE: 47951 by: Chris Stinemetz

2011-08-06 Thread Geoffrey Pitman
. And, finally if all of that checks out, I'd check your SQL and see if you have appropriate data types, etc. I hope that may help. Geoff From: Chris Stinemetz chrisstinem...@gmail.com To: php-db@lists.php.net Date: Fri, 5 Aug 2011 23:41:06 -0500 Subject: Insert query error I am getting the following

Re: [PHP-DB] Insert query error

2011-08-06 Thread Amit Tandon
Chris The error is indicated by the keywords a foreign key constraint fails, This implies that some value in store table is missing which u are trying to insert in posts. So check for the value u are trying to input in post table. U have to check for the values of post_store field from the input

[PHP-DB] Oracle NClobs

2011-08-05 Thread N . A . Morgan
Guys, Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. The following piece of code works with a CLOB, but not with an NCLOB. Can anyone shed any light please? $SQL = UPDATE $d_sid.srs_spd SET spd_fuld = EMPTY_CLOB() WHERE spd_stuc = :stuc AND spd_seqn = :seqn

Re: [PHP-DB] Oracle NClobs

2011-08-05 Thread Lester Caine
n.a.mor...@brighton.ac.uk wrote: Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. It may not be related, but there were a number of issues with BLOB ids in Firebird which were not fixed until 5.2.7, I don't have anything that old running now, but I think that it was

RE: [PHP-DB] Oracle NClobs

2011-08-05 Thread N . A . Morgan
Lester, Thanks for the advice, I tried to run this on a 5.2.17 install as well with the same results. Thanks anyway, Neil -Original Message- From: Lester Caine [mailto:les...@lsces.co.uk] Sent: 05 August 2011 17:08 To: php-db@lists.php.net Subject: Re: [PHP-DB] Oracle NClobs n.a.mor

Re: [PHP-DB] Oracle NClobs

2011-08-05 Thread Christopher Jones
On 08/05/2011 09:08 AM, Lester Caine wrote: n.a.mor...@brighton.ac.uk wrote: Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. It may not be related, but there were a number of issues with BLOB ids in Firebird which were not fixed until 5.2.7, I don't have anything

Re: [PHP-DB] Oracle NClobs

2011-08-05 Thread Christopher Jones
On 08/05/2011 08:55 AM, n.a.mor...@brighton.ac.uk wrote: Guys, Can anyone help please? I am using Oracle 10g (10.2.0.3) with PHP 5.2.5. The following piece of code works with a CLOB, but not with an NCLOB. Can anyone shed any light please? There is no support for NCLOB in PHP OCI8.

[PHP-DB] Insert query error

2011-08-05 Thread Chris Stinemetz
I am getting the following error trying to run the below query. Any suggestions on what I am doing wrong? Thank you, Something went wrong while inserting your store visitCannot add or update a child row: a foreign key constraint fails (`store`.`posts`, CONSTRAINT `posts_ibfk_1` FOREIGN KEY

[PHP-DB] Listing parent ids

2011-07-28 Thread Arno Kuhl
Not strictly a php issue but it's for a php app, hope that counts (plus I haven't had much joy googling this) I have a table with an id and a parentid. If it's a top-level record the parentid is 0, otherwise it points to another record, and if that record isn't a top-level record its parentid

RE: [PHP-DB] Listing parent ids

2011-07-28 Thread Arno Kuhl
Arno Kuhl wrote: Not strictly a php issue but it's for a php app, hope that counts (plus I haven't had much joy googling this) I have a table with an id and a parentid. If it's a top-level record the parentid is 0, otherwise it points to another record, and if that record isn't a top-level

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
On 28 July 2011 10:39, Arno Kuhl a...@dotcontent.net wrote: Arno Kuhl wrote: Not strictly a php issue but it's for a php app, hope that counts (plus I haven't had much joy googling this) I have a table with an id and a parentid. If it's a top-level record the parentid is 0, otherwise it

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
And http://www.amazon.co.uk/exec/obidos/ASIN/1558609202/onlinepricecouk -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Lester Caine
Arno Kuhl wrote: I'm currently using MySQL but I'll switch databases if there's a compelling reason and no drawbacks. Thanks for the lead, I'm googling recursive queries. 'common table expression' is the thing to google for, but MSDN seem to have hijacked all the top spots.

RE: [PHP-DB] Listing parent ids

2011-07-28 Thread Arno Kuhl
On 28 July 2011 10:39, Arno Kuhl a...@dotcontent.net wrote: Arno Kuhl wrote: Not strictly a php issue but it's for a php app, hope that counts (plus I haven't had much joy googling this) I have a table with an id and a parentid. If it's a top-level record the parentid is 0, otherwise it

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
On 28 July 2011 12:30, Arno Kuhl a...@dotcontent.net wrote: On 28 July 2011 10:39, Arno Kuhl a...@dotcontent.net wrote: Arno Kuhl wrote: Not strictly a php issue but it's for a php app, hope that counts (plus I haven't had much joy googling this) I have a table with an id and a parentid. If

RE: [PHP-DB] Listing parent ids

2011-07-28 Thread Arno Kuhl
I'm currently using MySQL but I'll switch databases if there's a compelling reason and no drawbacks. Thanks for the lead, I'm googling recursive queries. 'common table expression' is the thing to google for, but MSDN seem to have hijacked all the top spots.

[PHP-DB] Re: Listing parent ids

2011-07-28 Thread Jim Giner
Arno Kuhl a...@dotcontent.net wrote in message news:487F03135D2B452B89F22C95E278C7D4@point01... I have a table with an id and a parentid. If it's a top-level record the parentid is 0, otherwise it points to another record, and if that record isn't a top-level record its parentid points to

RE: [PHP-DB] Re: Listing parent ids

2011-07-28 Thread Arno Kuhl
I have a table with an id and a parentid. If it's a top-level record the parentid is 0, otherwise it points to another record, and if that record isn't a top-level record its parentid points to another record, etc (a linked list). Is there a single select that will return the complete

Re: [PHP-DB] Re: Listing parent ids

2011-07-28 Thread Jim Giner
Arno Kuhl a...@dotcontent.net wrote in message news:D349CC15D13F48DD8D4F6ED70062138C@point01... Hi Jim. I wanted the list of related parentids from current id to top-level (parentid=0). Ah - now that is a much different question! From your statement above, are you now saying you

Re: [PHP-DB] Re: Listing parent ids

2011-07-28 Thread Richard Quadling
On 28 July 2011 14:09, Arno Kuhl a...@dotcontent.net wrote: I have a table with an id and a parentid. If it's a top-level record the parentid is 0, otherwise it points to another record, and if that record isn't a top-level record its parentid points to another record, etc (a linked list).

RE: [PHP-DB] Re: Listing parent ids

2011-07-28 Thread Arno Kuhl
Hi Jim. I wanted the list of related parentids from current id to top-level (parentid=0). Ah - now that is a much different question! From your statement above, are you now saying you only want ONE list of related ids, not the entire society of possible 'families' in your table? Also -

Re: [PHP-DB] Re: Listing parent ids

2011-07-28 Thread Jim Giner
Arno Kuhl a...@dotcontent.net wrote in message news:DB930522404B4552B8A15AF991C57E30@point01... Hi Jim. Only one linked list of parentids. No siblings. Multiple records can have the same parentid, but that doesn't play a role. Okay. So you want only one 'family tree' at any given time, and

RE: [PHP-DB] Re: Listing parent ids

2011-07-28 Thread Arno Kuhl
If your data is based upon parentid and uniqueid, then you will need to change your data... http://data.bangtech.com/sql/nested_set_treeview.htm and once you've done that and find you can't deal with things (maybe it isn't for you), then

Re: [PHP-DB] UNION ALL

2011-07-18 Thread Amit Tandon
Dear Ron Try this === SELECT `cross_reference_article_2` FROM `frequently_accessed_passages_of_scripture_cross_reference` WHERE `cross_reference_article_1` = 1 UNION ALL SELECT `cross_reference_article_1` FROM

[PHP-DB] UNION ALL

2011-07-16 Thread Ron Piggott
I am trying to setup a cross reference database query for the first time. What I am trying to do is have a table with the structure: CREATE TABLE IF NOT EXISTS `frequently_accessed_passages_of_scripture_cross_reference` ( `reference` int(5) NOT NULL AUTO_INCREMENT,

[PHP-DB] Bruno Sandivilli deseja bater papo

2011-07-15 Thread Bruno Sandivilli
--- Bruno Sandivilli deseja manter contato com você de uma forma melhor usando alguns dos novos produtos mais legais do Google. Se você já tem Gmail ou o Google Talk, visite:

[PHP-DB] Bruno Sandivilli deseja bater papo

2011-07-15 Thread Bruno Sandivilli
--- Bruno Sandivilli deseja manter contato com você de uma forma melhor usando alguns dos novos produtos mais legais do Google. Se você já tem Gmail ou o Google Talk, visite:

Re: [PHP-DB] how does this regular expression works

2011-07-14 Thread Richard Quadling
On 13 July 2011 14:04, Shahriyar Imanov sh...@imanov.name wrote: \head.*?\(?Phead_tag_innerHTML.*?)\\/head\ head.*?(?Phead_tag_innerHTML.*?)/head Options: case insensitive; ^ and $ match at line breaks Match the characters “head” literally «head» Match any single character that is not a line

Re: [PHP-DB] how does this regular expression works

2011-07-14 Thread Richard Quadling
On 13 July 2011 13:42, who.cat win@gmail.com wrote: head[^]*(.*?)/head head[^]*(.*?)/head Options: case insensitive; ^ and $ match at line breaks Match the characters “head” literally «head» Match any character that is NOT a “” «[^]*» Between zero and unlimited times, as many times as

[PHP-DB] cascading select

2011-07-14 Thread Chris Stinemetz
I am trying to create a cascading seletct with 3 menu choices. For some reason my third select menu is not populating. It does not seem like my ajax is correctly sending $_post values to the final query in my PHP class I built. By the time I make it to the final (third) select menu there are no

Re: [PHP-DB] functions, the best way to implement and arrange them..

2011-07-13 Thread Taco Mathijs Hillenaar-Meerveld
yes, it was a structure like that i was looking for. so a class is a group of functions? i have heard about 'wrappers' to and from what i've heard it is the same thing? On Tue, Jul 12, 2011 at 11:36 PM, Karl DeSaulniers k...@designdrumm.comwrote: On Jul 12, 2011, at 7:28 AM, Taco Mathijs

Re: [PHP-DB] functions, the best way to implement and arrange them..

2011-07-13 Thread Karl DeSaulniers
On Jul 13, 2011, at 3:09 AM, Taco Mathijs Hillenaar-Meerveld wrote: yes, it was a structure like that i was looking for. so a class is a group of functions? i have heard about 'wrappers' to and from what i've heard it is the same thing? On Tue, Jul 12, 2011 at 11:36 PM, Karl DeSaulniers

Re: [PHP-DB] functions, the best way to implement and arrange them..

2011-07-13 Thread Gunawan Wibisono
using function is good.. I like to use it in my script.. but I do think about you should use Class because Class make your script more structure.. and you can hide your setting to make everyone unable to see or hack you system.. example.. I always like to use h1bla/h1 then i built function h1($s)

[PHP-DB] how does this regular expression works

2011-07-13 Thread who.cat
Reading some code from the web spider,got the such a expression : preg_match(@head[^]*(.*?)\/head@si,$file, $regs); It's about get the head content of a website,i wanna know the match detail .Could someone give some tips , thanks in advance . All you best What we are

RE: [PHP-DB] how does this regular expression works

2011-07-13 Thread Shahriyar Imanov
[mailto:who@gmail.com] On Behalf Of who.cat Sent: 13 iyul 2011 15:43 To: php-db@lists.php.net Subject: [PHP-DB] how does this regular expression works Reading some code from the web spider,got the such a expression : preg_match(@head[^]*(.*?)\/head@si,$file, $regs); It's about get the head content

[PHP-DB] Parsing words

2011-07-13 Thread Ron Piggott
Hi Everyone. Using the following query: SELECT `topic` FROM `frequently_accessed_passages_of_scripture` WHERE `frequently_accessed_passages_of_scripture_theme_reference` = 1 I would like to parse all the words out of the column topic that are 4 characters long or more, in alphabetical

Re: [PHP-DB] functions, the best way to implement and arrange them..

2011-07-13 Thread Tamara Temple
On Jul 12, 2011, at 7:28 AM, Taco Mathijs Hillenaar-Meerveld wrote: It might be a simple question for the local die-hards among here, but i'm really wondering about how developers arrange their scripts and keep their map structures. today i was looking for the best way to keep my scripts

[PHP-DB] functions, the best way to implement and arrange them..

2011-07-12 Thread Taco Mathijs Hillenaar-Meerveld
It might be a simple question for the local die-hards among here, but i'm really wondering about how developers arrange their scripts and keep their map structures. today i was looking for the best way to keep my scripts clear and to put them into maps so i have a clear overview. the same thing i

Re: [PHP-DB] functions, the best way to implement and arrange them..

2011-07-12 Thread Karl DeSaulniers
On Jul 12, 2011, at 7:28 AM, Taco Mathijs Hillenaar-Meerveld wrote: It might be a simple question for the local die-hards among here, but i'm really wondering about how developers arrange their scripts and keep their map structures. today i was looking for the best way to keep my scripts

Re: [PHP-DB] Duplicate table results

2011-07-06 Thread Karl DeSaulniers
I love the teddy bear effect... Corrected Code::: (or at least it works now :) (database.php) /** * getFiles - Returns all uploaded images for a print order. F * If query fails, NULL is returned. */ function getFiles($username, $fileID){ //to just get the current upload files

Re: [PHP-DB] Duplicate table results

2011-07-06 Thread Karl DeSaulniers
Hi Barry, $dbarray = array(); while($row = mysql_fetch_array($result)) { array_push($dbarray, $row['fileName']); } That was the difference. The while($row = Best, Karl On Jul 6, 2011, at 12:41 PM, Barry Stear wrote: Hmmm i didn't even see a different in the code

[PHP-DB] Eliminate the short search term

2011-07-05 Thread Guru™
Hi All, I have a search engine which is working fine. However let say if a user search for books or book its giving results having book or books as keywords. However when a user types books on computers its searching for whole 3 words like books on computers. I want to eliminate the search terms

[PHP-DB] Re: Eliminate the short search term

2011-07-05 Thread Bastien
On 2011-07-05, at 8:30 AM, Guru™ nagendra802...@gmail.com wrote: Hi All, I have a search engine which is working fine. However let say if a user search for books or book its giving results having book or books as keywords. However when a user types books on computers its searching for

[PHP-DB] Duplicate table results

2011-07-05 Thread Karl DeSaulniers
Hello All, I am wondering if you can help untie the knot in my head. I have a table that stores the reference to an uploaded file on an order form. Each upload has an upload ID as well as an Order ID So say I upload 4 files on this form for an order. All the files are getting uploaded

Re: [PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] PHP EOL

2011-07-04 Thread Karl DeSaulniers
Hello Stuart, After some closer look at the RFC Compliant manuals you suggested, I have determined that the creator of that code was in fact RFC821 Compliant. Being that this was a code I found several years ago, RFC822 may not have been in effect. This being the reason (I believe) that the

[PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] PHP EOL

2011-07-04 Thread Stuart Dallas
On Mon, Jul 4, 2011 at 7:11 AM, Karl DeSaulniers k...@designdrumm.comwrote: Hello Stuart, After some closer look at the RFC Compliant manuals you suggested, I have determined that the creator of that code was in fact RFC821 Compliant. Being that this was a code I found several years ago,

Re: [PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] PHP EOL

2011-07-04 Thread Karl DeSaulniers
@Stuart Ah, then you are right that they were not compliant. The code is not that old. Thank you so much for the links and information too. Much more than I expected. I did not know that they were sent OS-Independent, but that makes perfect sense. Again, please excuse my lack of

[PHP-DB] Re: [PHP] PHP EOL

2011-07-04 Thread Tim Streater
On 04 Jul 2011 at 08:01, Stuart Dallas stu...@3ft9.com wrote: On Mon, Jul 4, 2011 at 7:11 AM, Karl DeSaulniers k...@designdrumm.comwrote: Hello Stuart, After some closer look at the RFC Compliant manuals you suggested, I have determined that the creator of that code was in fact RFC821

Re: [PHP-DB] Re: [PHP] PHP EOL

2011-07-04 Thread Karl DeSaulniers
On Jul 4, 2011, at 2:34 AM, Tim Streater wrote: On 04 Jul 2011 at 08:01, Stuart Dallas stu...@3ft9.com wrote: On Mon, Jul 4, 2011 at 7:11 AM, Karl DeSaulniers k...@designdrumm.comwrote: Hello Stuart, After some closer look at the RFC Compliant manuals you suggested, I have determined

[PHP-DB] vend-bot?

2011-07-03 Thread Kirk Bailey
OK, I want to send someone back from paypal to a thank you page; this reloads to the actual file they will purchase. BUT, I want to include a magic cookie that will prevent someone else from going to that url at a later time and getting the payload without paying for it. Any thoughts on how to

Re: [PHP-DB] vend-bot?

2011-07-03 Thread Tamara Temple
On Jul 3, 2011, at 10:58 AM, Kirk Bailey wrote: OK, I want to send someone back from paypal to a thank you page; this reloads to the actual file they will purchase. BUT, I want to include a magic cookie that will prevent someone else from going to that url at a later time and getting the

[PHP-DB] Re: [PHP] PHP EOL

2011-07-03 Thread Karl DeSaulniers
Hello All, Just so you know, this is not something I made up myself. It was taken from an online HTML email tutorial. Also, It has worked for years with no problem and I would still use it, however I found out about the PHP_EOL and was just curious as to the difference. Thanks viraj... Best,

[PHP-DB] Re: [PHP] PHP EOL

2011-07-03 Thread Stuart Dallas
On Sun, Jul 3, 2011 at 10:31 PM, Karl DeSaulniers k...@designdrumm.comwrote: Hello All, Just so you know, this is not something I made up myself. It was taken from an online HTML email tutorial. Also, It has worked for years with no problem and I would still use it, however I found out about

Re: [PHP-DB] Re: [PHP] PHP EOL

2011-07-03 Thread Karl DeSaulniers
@Stuart, Actually that is what made me look into the PHP_EOL Stuart. Wanting to do things right. Did you not read my initial email? I am not suggesting anyone adopt my code. The question was directed to what the differences are so I COULD learn the right way. Being that this was something I

[PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] PHP EOL

2011-07-03 Thread Stuart Dallas
On Sun, Jul 3, 2011 at 11:22 PM, Karl DeSaulniers k...@designdrumm.comwrote: @Stuart, Actually that is what made me look into the PHP_EOL Stuart. Wanting to do things right. Did you not read my initial email? I am not suggesting anyone adopt my code. The question was directed to what the

[PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] PHP EOL

2011-07-03 Thread Karl DeSaulniers
I see. Yes, I was referring to the PHP manual. I will investigate the RFC manuals as well like you had noted. No offense taken. Thank you for the clarification. Best, Karl On Jul 3, 2011, at 6:07 PM, Stuart Dallas wrote: On Sun, Jul 3, 2011 at 11:22 PM, Karl DeSaulniers k...@designdrumm.com

[PHP-DB] PHP EOL

2011-07-02 Thread Karl DeSaulniers
Hello All, Happy pre independence for my American PHPers. And good health to all others. Have a quick question.. I have this code I use for the end of line characters used in my mailers. [Code] // Is the OS Windows or Mac or Linux if (strtoupper(substr(PHP_OS,0,5)=='WIN')) {

Re: [PHP-DB] PHP EOL

2011-07-02 Thread Karl DeSaulniers
On Jul 2, 2011, at 3:01 AM, Karl DeSaulniers wrote: Hello All, Happy pre independence for my American PHPers. And good health to all others. Have a quick question.. I have this code I use for the end of line characters used in my mailers. [Code] // Is the OS Windows or Mac or Linux if

[PHP-DB] Re: [PHP] PHP EOL

2011-07-02 Thread Stuart Dallas
On Sat, Jul 2, 2011 at 9:01 AM, Karl DeSaulniers k...@designdrumm.comwrote: Hello All, Happy pre independence for my American PHPers. And good health to all others. Have a quick question.. I have this code I use for the end of line characters used in my mailers. [Code] // Is the OS

Re: [PHP-DB] Re: [PHP] PHP EOL

2011-07-02 Thread Karl DeSaulniers
Thanks Stuart! Karl Sent from losPhone On Jul 2, 2011, at 8:45 AM, Stuart Dallas stu...@3ft9.com wrote: On Sat, Jul 2, 2011 at 9:01 AM, Karl DeSaulniers k...@designdrumm.comwrote: Hello All, Happy pre independence for my American PHPers. And good health to all others. Have a quick

[PHP-DB] Re: [PHP] PHP EOL

2011-07-02 Thread viraj
hi all, looking at the code Karl has posted, this code bit is not going to be a help in setting the 'new line' character in an email body, because it decides based on the server operating system. if (strtoupper(substr(PHP_OS,0,5)**=='WIN')) { $eol=\r\n; when sending out emails, the most

Re: [PHP-DB] A question about mysql

2011-07-01 Thread Tamara Temple
On Jun 30, 2011, at 9:57 PM, Guru™ wrote: I have a question about php-mysql. Is it possible that I can have 2 different fields in a mysql table, and when a user fill out the form for the first time the input goes to first field and when the second user fill out the form the input goes to 2nd

[PHP-DB] A question about mysql

2011-06-30 Thread Guru™
Hi All, I have a question about php-mysql. Is it possible that I can have 2 different fields in a mysql table, and when a user fill out the form for the first time the input goes to first field and when the second user fill out the form the input goes to 2nd field. For example: Lets say I have 2

Re: [PHP-DB] A question about mysql

2011-06-30 Thread Karl DeSaulniers
Hi Guru, You could disable the input field or set it to readonly after it has been filled in... input type=text name=name1 value=persons name disabled=disabled / or input type=text name=name1 value=persons name readonly=readonly / but you will have to do that client side with some

[PHP-DB] What is wrong with this code??

2011-06-29 Thread Guru™
Hi All, I have this search code for a library. however I have the same script in 2 different files, one with just search script and another with the pagination. But when I combined it its giving me few errors. I am getting the below errors. *Notice*: Undefined index: start in

Re: [PHP-DB] What is wrong with this code??

2011-06-29 Thread Zendyani
Hi list,GURU, For the first notice error, if you try to get value from post,get variable and the value is not sent or not present you have this kind of notice error, this is why you have to check for every get/post value if it's set or it's secure and you can do it with isset or empty: example:

[PHP-DB] Need Help with Search Engine

2011-06-28 Thread Guru™
Hi All, I coded a search engine which is pretty good on its own terms. I have functions and conditions for blank entries or any SQL injection. However I have a problem. When a user start search he uses words like in, for, the, at, on etc... For example: Hotels in India or Car for rent etc.. How

[PHP-DB] Re: Need Help with Search Engine

2011-06-28 Thread Bastien
On 2011-06-28, at 5:41 PM, Guru™ nagendra802...@gmail.com wrote: Hi All, I coded a search engine which is pretty good on its own terms. I have functions and conditions for blank entries or any SQL injection. However I have a problem. When a user start search he uses words like in, for,

Re: [PHP-DB] radio form submission

2011-06-24 Thread Guru™
I guess if you are storing the value of post_tptest in the database, it should return the same value what the user selected in the radio option. If I am right in your display you are just calling the data from the database. Check if the data is properly storing the radio button values in the

Re: [PHP-DB] Re: radio form submission

2011-06-24 Thread Karl DeSaulniers
Hi Chris, Here is the corrected code. Yes, call the function before the SQL SELECT like so. You may have to work with it a bit. This was just off the top of the head. But now that I look at it, I think Jim may be right. What's the purpose of the inputs having 1, 2, 3, etc and not the

Re: [PHP-DB] Re: radio form submission

2011-06-24 Thread Chris Stinemetz
Thanks everyone. If there is no purpose, I would make the values of the inputs the values you want to store in your database. Muuch easier.. So I am trying to keep this simple and just assign the value with the radio button and then insert it into mysql database, but with the following code

Re: [PHP-DB] Re: radio form submission

2011-06-24 Thread Jim Giner
The error is pretty explicit - there is no field in your table called '250kbps'. What you should have is a field (column) called speed for example, with values from 1...5 or whatever. To the users they will only deal with actual speed values on their screen if you use the speeds as the value

[PHP-DB] MSsql madness

2011-06-24 Thread Troy Oltmanns
Hey php-dbers, I have a helper script that connects to an MSsql database to select retailer location information, which is then processed into mysql statements to be inserted into another remote database (this one MYsql). Currently it is ran manually from a windows system that was preconfigured

Re: [PHP-DB] MSsql madness

2011-06-24 Thread Paul Wilson
please remove me from this list On Fri, Jun 24, 2011 at 3:02 PM, Troy Oltmanns toltma...@gmail.com wrote: Hey php-dbers, I have a helper script that connects to an MSsql database to select retailer location information, which is then processed into mysql statements to be inserted into

Re: [PHP-DB] MSsql madness

2011-06-24 Thread Daniel Brown
On Fri, Jun 24, 2011 at 16:07, Paul Wilson paulwilso...@gmail.com wrote: please remove me from this list Email php-db-unsubscr...@lists.php.net. -- /Daniel P. Brown Network Infrastructure Manager http://www.php.net/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Re: mysql COUNT row results

2011-06-23 Thread Geoff Lane
Hi Ron, On Thursday, June 23, 2011, 6:14:38 AM, you wrote: Is there a way that SELECT COUNT(auto_increment) as total_subscribers , `email` FROM `table` may exist within the same query and provide more than 1 row of search results? When I run a query like this the COUNT portion of the

[PHP-DB] Re: mysql COUNT row results

2011-06-23 Thread Ron Piggott
-Original Message- From: Geoff Lane Sent: Thursday, June 23, 2011 2:15 AM To: Ron Piggott Cc: php-db@lists.php.net Subject: Re: mysql COUNT row results Hi Ron, On Thursday, June 23, 2011, 6:14:38 AM, you wrote: Is there a way that SELECT COUNT(auto_increment

[PHP-DB] Re: mysql COUNT row results

2011-06-23 Thread Jim Giner
If you're looking for a count of ALL records, why do you want to append that to EACH record? Now if you're looking for a count of subscribers who have certain attributes (ie, unique groups of subscribers), then you would use a group by clause and include the attributes that define the group in

[PHP-DB] radio form submission

2011-06-23 Thread Chris Stinemetz
So far I am good on creating the form and submitting it to mysql database and calling the submitting value from a different script. My question is: How can I make it so when a user selects radio option value 1 it will then be displayed as 0-250kbps when I call it the value in the bottom script?

Re: [PHP-DB] radio form submission

2011-06-23 Thread Karl DeSaulniers
Try this... function getSpeed($val) { if($val != 'undefined') { switch ($val){ case 1: $post_tptest = 0-250kbps; break; case 2:

Re: [PHP-DB] radio form submission

2011-06-23 Thread Chris Stinemetz
On Thu, Jun 23, 2011 at 2:49 PM, Daniel P. Brown daniel.br...@parasane.net wrote: On Thu, Jun 23, 2011 at 15:46, Chris Stinemetz chrisstinem...@gmail.com wrote:    Use an if or a switch.  For example: I think your suggestions are exactly what I am looking for. I am not sure exactly where

Re: [PHP-DB] radio form submission

2011-06-23 Thread Karl DeSaulniers
I also think you need to use the mysql_free_result like so.. echo 'select name=store_mar'; while($row = mysql_fetch_assoc($result)) { echo 'option value=' .

Re: [PHP-DB] radio form submission

2011-06-23 Thread Daniel P. Brown
On Thu, Jun 23, 2011 at 15:46, Chris Stinemetz chrisstinem...@gmail.com wrote:    Use an if or a switch.  For example: I think your suggestions are exactly what I am looking for. I am not sure exactly where to place it. Do I insert it after the query statment? During your while() loop.

Re: [PHP-DB] radio form submission

2011-06-23 Thread Chris Stinemetz
   Use an if or a switch.  For example: I think your suggestions are exactly what I am looking for. I am not sure exactly where to place it. Do I insert it after the query statment? Thank you, Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: radio form submission

2011-06-23 Thread Jim Giner
Try reading a good html reference on how radio buttons work. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] radio form submission

2011-06-23 Thread Tamara Temple
On Jun 23, 2011, at 2:32 PM, Karl DeSaulniers wrote: Try this... function getSpeed($val) { if($val != 'undefined') { switch ($val){ case 1: $post_tptest = 0-250kbps; break;

[PHP-DB] Re: radio form submission

2011-06-23 Thread Jim Giner
If you put the 0-250kbps as the value= of your html input tag, php would give you that when you did this: $rb_picked = $_POST['post_tptest']. No need for a switch or anything to re-interpret what the user picked. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] radio form submission

2011-06-23 Thread Daniel P. Brown
On Thu, Jun 23, 2011 at 16:08, Chris Stinemetz chrisstinem...@gmail.com wrote: I must be missing something. I am just getting a blank page. Your help is greatly apprecieated. This is why you're supposed to take the advice and write it out yourself, not copy and paste the code. ;-P By

Re: [PHP-DB] radio form submission

2011-06-23 Thread Daniel P. Brown
On Thu, Jun 23, 2011 at 14:18, Chris Stinemetz chrisstinem...@gmail.com wrote: So far I am good on creating the form and  submitting it to mysql database and calling the submitting value from a different script. My question is: How can I make it so when a user selects radio option value 1 it

<    8   9   10   11   12   13   14   15   16   17   >