[PHP] inset data to multiple tables

2009-02-16 Thread PJ
I am trying to find a solution to enter data from a web page to several tables in the same database; actually, I have 9 tables bus several are basically id fields for foreign keys. So far, I have found: "use mysql_insert_id()" - the examples and directions are incomprehensible (to me, anyway) "use

Re: [PHP] Re: inset data to multiple tables

2009-02-16 Thread PJ
Hell, I feel about as dumb as can be. I just goth things straight and it seems to work just fine... Here is where my problem was... $sql1 = "INSERT INTO books ( title, sub_title, descr, comment, bk_cover, publish_date, ISBN, language ) VALUES

Re: [PHP] Full versus relative URLs

2009-02-17 Thread PJ
Dotan Cohen wrote: >>> So put it all in one place: >>> >>> >> include "path.inc"; >>> print""; >>> ?> >>> >>> Full URLs don't break when users save the pages to disk. >> That would be fine if the pages weren't being crafted in Dreamweaver, >> where inserting links like that is a pain. >> > > For th

Re: [PHP] Full versus relative URLs

2009-02-17 Thread PJ
Michael A. Peters wrote: > PJ wrote: > >>> >> I hope I'm not out of place here, but I have a problem that seems to be >> related. >> I am using some include statements for page headers with the pages in >> various directories on the site. The problem i

Re: [PHP] Full versus relative URLs

2009-02-17 Thread PJ
Michael A. Peters wrote: > PJ wrote: >> Michael A. Peters wrote: >>> PJ wrote: >>> >>>> I hope I'm not out of place here, but I have a problem that seems >>>> to be >>>> related. >>>> I am using some include stateme

Re: [PHP] Full versus relative URLs

2009-02-17 Thread PJ
Stuart wrote: > 2009/2/17 PJ : > >> Dotan Cohen wrote: >> >>>>> So put it all in one place: >>>>> >>>>> >>>> include "path.inc"; >>>>> print""; >>>>> ?> >>

Re: [PHP] Full versus relative URLs

2009-02-18 Thread PJ
Stuart wrote: > 2009/2/17 PJ : > >> Stuart wrote: >> >>> 2009/2/17 PJ : >>> >>> >>>> Dotan Cohen wrote: >>>> >>>> >>>>>>> So put it all in one place: >>>>>&g

[PHP] escape your variables

2009-02-18 Thread PJ
To focus on mysql_real_escape_string, I am recapping... questions below QUOTE:== Instead of doing this (for an imaginary table): $sql = "insert into table1(field1, field2) values ('$value1', '$value2')"; do $sql = "insert into table1(field1, field2) values ('" . mysql_real_escape_string($v

Re: [PHP] Full versus relative URLs

2009-02-18 Thread PJ
Stuart wrote: >>> This generates a Fatal error: Cal to undefined function dirname() I must be really dense... What I don't understand in the above is this - dirname refers to what directory? -- the directory of the file that is including? what if the directory is the root directory of t

Re: [PHP] Full versus relative URLs

2009-02-18 Thread PJ
Stuart wrote: > 2009/2/18 PJ : > >> Stuart wrote: >> >>>>> >>>>> >> This generates a Fatal error: Cal to undefined function dirname() >> > > The dirname function is present in both PHP 4 and 5

Re: [PHP] Full versus relative URLs

2009-02-18 Thread PJ
Bastien Koert wrote: > On Wed, Feb 18, 2009 at 12:05 PM, PJ wrote: > >> Stuart wrote: >>> 2009/2/18 PJ : >>> >>>> Stuart wrote: >>>> >>>>>>> >>>>>>> >>>> This generates a Fatal error:

Re: [PHP] Full versus relative URLs

2009-02-18 Thread PJ
Paul M Foster wrote: > On Wed, Feb 18, 2009 at 12:05:21PM -0500, PJ wrote: > >> Stuart wrote: >>> 2009/2/18 PJ : >>> >>>> Stuart wrote: >>>> >>>>>>> >>>>>>> > > > >>> >>

[PHP] multiple choice dropdown box puzzle

2009-02-23 Thread PJ
I think this is a tough one... and way above my head: PLEASE READ ALL OF THE ABOVE TO UNDERSTAND WHAT I AM TRYING TO DO. Having a bit of a rough time figuring out how to formulate php-mysql to insert data into fields using a multiple dropdown box in a form. to post I am using the following: snip.

[PHP] Re: multiple choice dropdown box puzzle

2009-02-23 Thread PJ
not sanitize the data before inserting. > > Brent > > On Mon, Feb 23, 2009 at 10:25 AM, PJ wrote: > >> I think this is a tough one... and way above my head: >> PLEASE READ ALL OF THE ABOVE TO UNDERSTAND WHAT I AM TRYING TO DO. >> Having a bit of a rough time

[PHP] Re: multiple choice dropdown box puzzle

2009-02-23 Thread PJ
Brent Baisley wrote: > It's actually a very simple solution, and you should do it all in a > single INSERT. Putting INSERTs in a loop will kill your performance > when you try to scale. > > $sql4 = 'INSERT INTO test (example) VALUES (' . implode('),(', > $_POST["categoriesIN"]) . ')'; > $result4 =

[PHP] Re: how to deal with multiple authors for one book

2009-02-24 Thread PJ
Reinhardt Christiansen wrote: > > > >> From: PJ >> To: MySql >> Subject: how to deal with multiple authors for one book >> Date: Mon, 16 Feb 2009 17:20:54 -0500 >> >> In my db there are a number of books with several authors; so, I am >> wonderi

Re: [PHP] Re: multiple choice dropdown box puzzle

2009-02-24 Thread PJ
Bob McConnell wrote: > From: PJ > >> Here's my test page and, so far, nothing works... >> > > Please expound on "nothing works...". What do you see in the browser? > What do you see in the server logs? > It's not in the browser that I l

[PHP] non-auto increment question

2009-02-25 Thread PJ
I want to insert a new table entry 1 number higher than the highest in the field (id). I cannot use auto-increment. And I want to show the value of the field to be added in an input field on the web page: if (isset($_REQUEST["AddNewBooksRequest"])) { $SQL = "SELECT MAX(id) FROM book"; $

Re: [PHP] RE: non-auto increment question

2009-02-25 Thread PJ
to use autoincrement, you can run into a race >> condition where two people are inserting at the same time, thus >> having the same generated id. >> >> Hope that helps. >> >> >> >> >> From: PJ [mailto:af.gour

[PHP] What in Hades?

2009-02-26 Thread PJ
Something is rotten here. Twist it any way you like and it just does not work. I am trying to figure out the working of SELECT LAST_INSERT_ID() and cannot get beyond the first $sql - But it works fine from command-line! Error performing query: " . mysql_error() . ""); exit(); } THIS IS W

Re: [PHP] RE: non-auto increment question

2009-02-26 Thread PJ
Jerry Schwartz wrote: >> Being rather new to all this, I understood from the MySql manual that >> the auto_increment is to b e used immediately after an insertion not >> intermittently. My application is for administrators (the site owner & >> designates) to update the database from and administra

Re: [PHP] What in Hades?

2009-02-26 Thread PJ
Richard Whitney wrote: > On Thu, Feb 26, 2009 at 9:14 AM, PJ <mailto:af.gour...@videotron.ca>> wrote: > > Something is rotten here. Twist it any way you like and it just > does not > work. > I am trying to figure out the working of SELECT LAST_INSER

Re: [PHP] What in Hades?

2009-02-26 Thread PJ
Ashley Sheridan wrote: > On Thu, 2009-02-26 at 11:14 -0500, PJ wrote: > >> Something is rotten here. Twist it any way you like and it just does not >> work. >> I am trying to figure out the working of SELECT LAST_INSERT_ID() and >> cannot get beyond the first

Re: [PHP] What in Hades?

2009-02-26 Thread PJ
p://www.ubuntu.com> > ------ > > > 2009/2/26 PJ mailto:af.gour...@videotron.ca>> > > Something is rotten here. Twist it any way you like and it just > does not > work. > I am trying to figure out the working of S

[PHP] catch the error

2009-02-26 Thread PJ
What is wrond with this file? same identical insert works from console but not from this file :-( Untitled Error performing 1st query: " . mysql_error() . ""); exit(); } ?> Seems to be good to print out the error message, but that's all. db not written. -- Phil Jourdan ---

[PHP] Re: catch the error

2009-02-26 Thread PJ
t is wrond with this file?" :-) > Hi PJ, > Could it be that you have "//include ("lib/db1.php"); " commented > out? Try uncommenting that line and see what happens. The error > message will always print because the query is never executing > properly if you ha

Re: [PHP] catch the error

2009-02-26 Thread PJ
Ashley Sheridan wrote: > On Thu, 2009-02-26 at 12:28 -0500, PJ wrote: >> What is wrond with this file? same identical insert works from console >> but not from this file :-( >> >> >> >> Untitled >> >> >> >> > //include ("

[PHP] Re: catch the error

2009-02-26 Thread PJ
t; . mysql_error() . ""); exit(); } ?> > > On Thu, Feb 26, 2009 at 11:46 AM, PJ <mailto:af.gour...@videotron.ca>> wrote: > > It is commented out because I am using "mysql_connect" > I don't think it would be good to use both,

[PHP] Re: catch the error

2009-02-26 Thread PJ
Ricardo Dias Marques wrote: > Hi PJ, > > On Thu, Feb 26, 2009 at 17:28, PJ wrote: > > >> What is wrond with this file? same identical insert works from console >> but not from this file :-( >> >> [snip] >> >> > //include ("lib/db

[PHP] Re: catch the error

2009-02-26 Thread PJ
ected: (but it still does not work) Error performing 1st query: " . mysql_error() . ""); exit(); } ?> > > That should fix the problem. > > On Thu, Feb 26, 2009 at 12:46 PM, PJ wrote: > >> It is commented out because I am using "mysql_connect&

[PHP] Re: catch the error

2009-02-26 Thread PJ
Jerry Schwartz wrote: > >> -Original Message- >> From: PJ [mailto:af.gour...@videotron.ca] >> Sent: Thursday, February 26, 2009 12:28 PM >> To: php-general@lists.php.net; MySql >> Subject: catch the error >> >> What is wrond with this f

Re: [PHP] Re: catch the error

2009-02-26 Thread PJ
Ashley Sheridan wrote: > On Thu, 2009-02-26 at 13:34 -0500, Darryle Steplight wrote: > >> Hi PJ, >>$db_host = 'biggie'; >> $db_user = 'root'; >> $db_pass = 'gu...@#$'; >> $db_name = 'biblane'; >> >> >

Re: [PHP] Re: catch the error

2009-02-26 Thread PJ
Here's the working code... Error performing 3st query: " . mysql_error() . ""); } echo $sql1; echo ""; echo $db_select; exit(); ?> This works fine either as is or using the include... :-) 9el wrote: > But the question is PJ, have you got it out o

Re: [PHP] RE: non-auto increment question

2009-02-26 Thread PJ
Ashley Sheridan wrote: > On Thu, 2009-02-26 at 13:44 -0500, Jerry Schwartz wrote: > >>> Here's how I mostly do it (albeit simplified): >>> >>> $query = "INSERT INTO `sometable`(`title`,`content`) >>> VALUES('$title','$content')"; >>> $result = mysql_query($query); >>> $autoId = mysql_insert_id($

Re: [PHP] Re: catch the error

2009-02-26 Thread PJ
Ashley Sheridan wrote: > On Thu, 2009-02-26 at 13:56 -0500, PJ wrote: > >> Ashley Sheridan wrote: >> >>> On Thu, 2009-02-26 at 13:34 -0500, Darryle Steplight wrote: >>> >>> >>>> Hi PJ, >>>>$db_host = '

[PHP] verify text in field

2009-02-26 Thread PJ
Is there a shorter way of determining if a field contains text? This works but I wonder if I can K.I.S.S. it? I really only need to know if there is or is not a field containing the text specified. I don't need to see it. Error performing query: " . mysql_error() . ""); exit(); }

Re: [PHP] Re: catch the error

2009-02-26 Thread PJ
ws! >> >> # GOOD: >> $db = mysql_connect([options]); >> $result = mysql_query([some query], $db); # same resource link from >> mysql_connect >> >> See? >> >> HTH, >> >> >> // Todd >> > > Yes, and I would also st

Re: [PHP] Re: catch the error

2009-02-26 Thread PJ
Ashley Sheridan wrote: > On Thu, 2009-02-26 at 14:15 -0500, PJ wrote: > >> Ashley Sheridan wrote: >> >>> On Thu, 2009-02-26 at 13:56 -0500, PJ wrote: >>> >>> >>>> Ashley Sheridan wrote: >>>> >>&

Re: [PHP] verify text in field

2009-02-26 Thread PJ
ql) ) { > echo("" . $row["title"] . ""); > } > } > > My Ideas my not make some people happy with my design but I use it and it > works very well > > > > -Original Message- > From: PJ [mailto:af.gour...@videotron.ca] > Sent: Th

[PHP] multiple categories

2009-03-02 Thread PJ
I have a list of some 60 categories for a book database and am wondering what would be the best approach for inserting and selecting the data. My choices are to (1.)simply use one field in a books table and enter the categories for each book separated by a comma (or whatever) as a text field and th

Re: [PHP] multiple categories

2009-03-02 Thread PJ
Andrew Ballard wrote: > On Mon, Mar 2, 2009 at 11:50 AM, PJ wrote: > >> I have a list of some 60 categories for a book database and am wondering >> what would be the best approach for inserting and selecting the data. >> My choices are to >> (1.)simply use one fi

[PHP] retrieve multiple select

2009-03-02 Thread PJ
I'm sure this has been hashed over and over on the web, only I can't find anything that makes sense or the explanations given have been erroneous. This is what I am trying: Choose Categories... History Temples Pharaohs and Queens Cleopatra Mummies f

Re: [PHP] retrieve multiple select

2009-03-02 Thread PJ
PJ wrote: > I'm sure this has been hashed over and over on the web, only I can't > find anything that makes sense or the explanations given have been > erroneous. > This is what I am trying: > > Choose Categories... > History > Tem

Re: [PHP] Re: retrieve multiple select

2009-03-02 Thread PJ
Shawn McKenzie wrote: > PJ wrote: > >> I'm sure this has been hashed over and over on the web, only I can't >> find anything that makes sense or the explanations given have been >> erroneous. >> This is what I am trying: >> >> Choose

Re: [PHP] retrieve multiple select

2009-03-02 Thread PJ
Michael A. Peters wrote: > PJ wrote: >> I'm sure this has been hashed over and over on the web, only I can't >> find anything that makes sense or the explanations given have been >> erroneous. >> This is what I am trying: >> >> Choose Ca

Re: [PHP] retrieve multiple select

2009-03-02 Thread PJ
Shawn McKenzie wrote: > PJ wrote: >> PJ wrote: >>> I'm sure this has been hashed over and over on the web, only I can't >>> find anything that makes sense or the explanations given have been >>> erroneous. >>> This is what I am trying

Re: [PHP] multiple categories

2009-03-02 Thread PJ
Paul M Foster wrote: > On Mon, Mar 02, 2009 at 11:50:15AM -0500, PJ wrote: > > >> I have a list of some 60 categories for a book database and am wondering >> what would be the best approach for inserting and selecting the data. >> My choices are to >> (1.)simp

Re: [PHP] retrieve multiple select

2009-03-02 Thread PJ
Michael A. Peters wrote: > PJ wrote: > >> Well, I think 60+ checkboxes get kind of garbagy > > I bet it is easier to select the fields you want from 4 columns of 15 > checkboxes than from a big long list of 60 in a select. > > But you might be right. I don't des

Re: [PHP] retrieve multiple select

2009-03-02 Thread PJ
Shawn McKenzie wrote: > PJ wrote: > >> Shawn McKenzie wrote: >> >>> PJ wrote: >>> >>>> PJ wrote: >>>> >>>>> I'm sure this has been hashed over and over on the web, only I can't >

[PHP] whoami explanation

2009-03-03 Thread PJ
This really needs some explanation I found this on the web: with it there was the comment "the direction of those single-quotes matters" (WHY ?) and it works But this (_*FROM THE PHP MANUAL***_ * - exec()* executes the given /command/ ) does not, COPIED AND PASTED: | | What is going on here?

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Per Jessen wrote: > PJ wrote: > > >> This really needs some explanation >> I found this on the web: >> >> with it there was the comment "the direction of those single-quotes >> matters" (WHY ?) and it works >> >> > &g

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Per Jessen wrote: > PJ wrote: > > >> This really needs some explanation >> I found this on the web: >> >> with it there was the comment "the direction of those single-quotes >> matters" (WHY ?) and it works >> >> > &g

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Per Jessen wrote: > PJ wrote: > > >> This really needs some explanation >> I found this on the web: >> >> with it there was the comment "the direction of those single-quotes >> matters" (WHY ?) and it works >> >> > &g

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Daniel Brown wrote: > On Tue, Mar 3, 2009 at 10:57, PJ wrote: > >> forgot to add: >> What's the difference between back ticks or quotes and regular single >> quotes? >> How does one enter back quotes from the keyboard? >> > > Welcome to t

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Per Jessen wrote: > PJ wrote: > > >> forgot to add: >> What's the difference between back ticks or quotes and regular single >> quotes? >> > > text in back ticks is executed via a shell, text in single quotes isn't. > Ok, but how does

Re: [PHP] Re: whoami explanation

2009-03-03 Thread PJ
Shawn McKenzie wrote: > PJ wrote: > >> This really needs some explanation >> I found this on the web: >> >> with it there was the comment "the direction of those single-quotes matters" >> (WHY ?) >> and it works >> >> But

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Daniel Brown wrote: > On Tue, Mar 3, 2009 at 11:22, PJ wrote: > >> Ok, but how does this relate to a command passed from a php Web page? >> I don't understand the processus. >> I use bash on my FreeBSD and have not needed a back quote yet that I

Re: [PHP] Re: whoami explanation

2009-03-03 Thread PJ
Daniel Brown wrote: > On Tue, Mar 3, 2009 at 11:27, PJ wrote: > >> What is not clear to me is why would I need to use a shell? What kind of >> situations call for it's use? >> > > On what kind of programming did you spend those years? > Not re

Re: [PHP] Re: whoami explanation

2009-03-03 Thread PJ
Bob McConnell wrote: > From: PJ > >> What is not clear to me is why would I need to use a shell? What kind >> > of > >> situations call for it's use? >> > > It's a matter of expectations. I am still trying to figure out why >

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Daniel Brown wrote: > On Tue, Mar 3, 2009 at 11:41, PJ wrote: > >> I appreciate the input and I take the chastizing with a ton of salt. >> > > It's all in good fun and being the new guy, it's at your expense. ;-P > > Having thick ski

Re: [PHP] Re: whoami explanation

2009-03-03 Thread PJ
Daniel Brown wrote: > On Tue, Mar 3, 2009 at 11:48, PJ wrote: > > [snip!] > >> Now I'm trying to modify my daughter's ptahhotep.com to use MySql. It's >> a learning experience. >> > > Through the years I've probably sounded li

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Daniel Brown wrote: > On Tue, Mar 3, 2009 at 11:59, PJ wrote: > >> :-* >> > > Umm thanks? > > (You do know that's the emoticon to symbolize kissing, right?) > > Let's not get too personnal here... it was meant to blow a kiss

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Boyd, Todd M. wrote: >> -Original Message- >> From: Ashley Sheridan [mailto:a...@ashleysheridan.co.uk] >> Sent: Tuesday, March 03, 2009 2:07 PM >> To: PJ >> Cc: Daniel Brown; Per Jessen; php-general@lists.php.net >> Subject: Re: [PHP] whoami explanati

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Michael A. Peters wrote: > PJ wrote: > >>> >> Gee, thanks. So, when was I supposed to have used this alias? Hell, I >> can live with my ignorance. What's a POSIX system and why is it a POSIX >> - a language, I think I heard > > cd ~ > >

Re: [PHP] whoami explanation

2009-03-03 Thread PJ
Daniel Brown wrote: > On Tue, Mar 3, 2009 at 18:56, PJ wrote: >> But I'm sorry I missed the fun earlier about the American foibles... >> unfortunately that should go on some other list and I wish I knew which >> one - one that had some smarts to it (like this one) and

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Daniel Brown wrote: > [Inhales] > > On Wed, Mar 4, 2009 at 01:01, PJ wrote: > >> Ok. You asked for it... I have to rant a bit get this off my chest as it >> has been bugging me for a while and this is not directed at anyone in >> particular. >>

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Daniel Brown wrote: > On Wed, Mar 4, 2009 at 10:42, PJ wrote: > >> Right on. Good comments. >> No offense taken and none intended. >> I am enoying the list and will continue to participate, if i may. >> I have learned a great deal already and really do appreciat

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
here might be a discrepancy. > This > is jumping to > Â Â Â Â > conclusions without proper empirical research. > > Â Â Considering I *gave* PJ the search term to use at input, I'll > consider my research to be done, complete and accurate, to the

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Shawn McKenzie wrote: > PJ wrote: > >> Daniel Brown wrote: >> >>> On Wed, Mar 4, 2009 at 10:42, PJ wrote: >>> >>> >>>> Right on. Good comments. >>>> No offense taken and none intended. >>>> I am e

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Robert Cummings wrote: > On Wed, 2009-03-04 at 16:16 -0500, PJ wrote: > >> Shawn McKenzie wrote: >> >>> PJ wrote: >>> >>> >>>> Daniel Brown wrote: >>>> >>>> >>>>> On Wed

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Shawn McKenzie wrote: > PJ wrote: > >> Shawn McKenzie wrote: >> >>> PJ wrote: >>> >>> >>>> Daniel Brown wrote: >>>> >>>> >>>>> On Wed, Mar 4, 2009 at 10:42, PJ wrote:

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Ashley Sheridan wrote: > On Wed, 2009-03-04 at 15:48 -0600, Shawn McKenzie wrote: > >> PJ wrote: >> >>> Shawn McKenzie wrote: >>> >>>> PJ wrote: >>>> >>>> >>>>> Daniel

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Paul M Foster wrote: > On Wed, Mar 04, 2009 at 04:16:40PM -0500, PJ wrote: > > >> Shawn McKenzie wrote: >> >>> PJ wrote: >>> >>> >>>> Daniel Brown wrote: >>>> >>>> >>>>> On

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Robert Cummings wrote: > On Wed, 2009-03-04 at 15:48 -0600, Shawn McKenzie wrote: > >> Whatever you do, please, please, please, for the love of all that is >> holy, please, do not vilify potatoes! ...or the Irish :-) >> > > Potatoes are best served sliced into sticks, pan-fried, covered in

[PHP] if elseif elseif elseif....

2009-03-04 Thread PJ
This is probably a mysql question, but their list is rather dull - I think they don't appreciate my humor. Beside this list is fun ... and informative. Anyway, I can't figure this out. I am trying to verify inputs on a form and even if I have all the required fields right, I still get the error tha

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Robert Cummings wrote: > On Wed, 2009-03-04 at 17:43 -0500, PJ wrote: > >> Robert Cummings wrote: >> >>> On Wed, 2009-03-04 at 15:48 -0600, Shawn McKenzie wrote: >>> >>> >>>> Whatever you do, please, please, please, for

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Ashley Sheridan wrote: > On Wed, 2009-03-04 at 17:46 -0500, Robert Cummings wrote: > >> On Wed, 2009-03-04 at 21:55 +, Ashley Sheridan wrote: >> >>> Whilst we're on the subject, what about cows, pigs and sheep, which are >>> the biggest contributors to global warming through their, erm,

Re: [PHP] if elseif elseif elseif....

2009-03-04 Thread PJ
Daniel Brown wrote: > On Wed, Mar 4, 2009 at 17:51, PJ wrote: > >>elseif ($obligatoryFieldNotPresent = 1) { >>$obligatoryFieldNotPresent = 0; >>} >> > > Are you certain you only wanted a single equal operator in the > last els

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Ashley Sheridan wrote: > On Wed, 2009-03-04 at 17:40 -0500, PJ wrote: > >> Paul M Foster wrote: >> >>> On Wed, Mar 04, 2009 at 04:16:40PM -0500, PJ wrote: >>> >>> >>> >>>

Re: [PHP] if elseif elseif elseif....

2009-03-04 Thread PJ
PJ wrote: > Daniel Brown wrote: > >> On Wed, Mar 4, 2009 at 17:51, PJ wrote: >> >> >>>elseif ($obligatoryFieldNotPresent = 1) { >>>$obligatoryFieldNotPresent = 0; >>>} >>> >>> >>

Re: [PHP] escape your variables

2009-03-04 Thread PJ
to locate the biblane " . "database at this time." ); exit(); } ?> Eric Butera wrote: > On Wed, Feb 18, 2009 at 8:34 AM, PJ wrote: >> To focus on mysql_real_escape_string, I am recapping... questions below >> QUOTE:== >> Instead of doing

Re: [PHP] whoami explanation

2009-03-04 Thread PJ
Shawn McKenzie wrote: > Robert Cummings wrote: > >> On Wed, 2009-03-04 at 15:48 -0600, Shawn McKenzie wrote: >> >>> Whatever you do, please, please, please, for the love of all that is >>> holy, please, do not vilify potatoes! ...or the Irish :-) >>> >> Potatoes are best served slic

Re: [PHP] Re: if elseif elseif elseif....

2009-03-05 Thread PJ
Davi Ramos wrote: > I tought you forgot to initializae the $obligatoryFieldNotPresent variable, > as PHP create variables when they are initialized, the > $obligatoryFieldNotPresent variable is created inside the if. > > $obligatoryFieldNotPresent = 0; > > if (strlen($_POST["titleIN"]) == 0 ) { >

Re: [PHP] whoami explanation

2009-03-05 Thread PJ
Shawn McKenzie wrote: > Shawn McKenzie wrote: > >> PJ wrote: >> >>> Shawn McKenzie wrote: >>> >>>> Robert Cummings wrote: >>>> >>>> >>>>> On Wed, 2009-03-04 at 15:48 -0600, Shawn McK

[PHP] concat woes

2009-03-05 Thread PJ
Here we go again! I'm trying to do some form entry verification and am trying to figure out how to verify if there are 4 fields entered: f_nameIN, l_nameIN, f_name2IN, l_name2IN Verifying for each is ok, but somewhat tortured and long. I thought of using CONCAT_WS but it doesn't seem to listen to m

[PHP] verify problem

2009-03-05 Thread PJ
And again, this works: if (strlen($_POST["first_nameIN"]) == 0 ) { $obligatoryFieldNotPresent = 1; ... this does not: if (strlen($_POST["first_nameIN"]) > 0 ) && (strlen($_POST["last_nameIN"]) > 0 ) { echo $first_nameIN, " ", $last_nameIN); else (echo "error";)} But, $first_nameIn an

Re: [PHP] concat woes

2009-03-05 Thread PJ
haliphax wrote: > On Thu, Mar 5, 2009 at 4:34 PM, PJ wrote: > >> Here we go again! >> I'm trying to do some form entry verification and am trying to figure >> out how to verify if there are 4 fields entered: >> f_nameIN, l_nameIN, f_name2IN, l_name2IN >&g

Re: [PHP] verify problem

2009-03-05 Thread PJ
Chris wrote: > PJ wrote: >> And again, this works: >> if (strlen($_POST["first_nameIN"]) == 0 ) { >> $obligatoryFieldNotPresent = 1; ... >> >> this does not: >> >> if (strlen($_POST["first_nameIN"]) >

Re: [PHP] verify problem

2009-03-05 Thread PJ
Nathan Rixham wrote: > Chris wrote: >> PJ wrote: >>> And again, this works: >>> if (strlen($_POST["first_nameIN"]) == 0 ) { >>> $obligatoryFieldNotPresent = 1; ... >>> >>> this does not: >>> >>> if (strle

Re: [PHP] verify problem

2009-03-05 Thread PJ
Chris wrote: > >>> Are both first_nameIN AND last_nameIN longer than 0 chars? >>> >>> var_dump($_POST['first_nameIN']); >>> var_dump($_POST['last_nameIN']); >>> >>> maybe you only filled in first_name or last_name but not both. >>> >> Well, >> echo $first_nameIN, " ", $last_nameIN; >> Prints out th

[PHP] include question

2009-03-06 Thread PJ
good morning all, How can I include src and href in include files that will refer the right paths from files in different hierarchies(directory tree levels)? Example: include dirname(_FILE_)."/../lib/header1.php"; ? This does not work: snippetysnip... Nor does this: (NOTE THE DIFFERENCES " AND

Re: [PHP] include question

2009-03-06 Thread PJ
Daniel Brown wrote: > On Fri, Mar 6, 2009 at 08:53, Stuart wrote: > >>>1.) We use regular open tags to be compatible with all stock >>> PHP configurations. >>>2.) We echo out the response from dirname() so that it's >>> output to the HTML source. >>>3.) We use dirname()

Re: [PHP] Re: if elseif elseif elseif....

2009-03-06 Thread PJ
Robert Cummings wrote: > On Fri, 2009-03-06 at 08:51 -0600, haliphax wrote: > >> On Fri, Mar 6, 2009 at 8:46 AM, Robert Cummings wrote: >> >>> On Fri, 2009-03-06 at 08:38 -0600, haliphax wrote: >>> On Fri, Mar 6, 2009 at 8:19 AM, Daniel Brown wrote: > On Fri,

Re: [PHP] Assign 2 values from Mysql to an array

2009-03-06 Thread PJ
Shawn McKenzie wrote: > Dollah Ihsan wrote: > >> I'm sorry if this is not what you're talking about... >> >> /** >> * assume your table structure just like this. >> * table: users >> * | id | country| name | population | >> * ---

[PHP] verify another flavor

2009-03-06 Thread PJ
I know I'm a pain the butt but I just can't help asking for help. You guys are so nice... ;-) I am trying to do some checks if there are entries in the db so I can then insert the right stuff. And I'm looking for ways to simplify things. I probably dont understand the flow of things here, but this

[PHP] insert array values

2009-03-06 Thread PJ
I've been racking my little peanut-brain as well as big Google with little hope... I can retrieve the array from the multiple select dropdown box but I can't quite manage to insert the data which is just id numbers for a table. I've tried some while stuff but doesn't work. I know I don't have the r

Re: [PHP] insert array values

2009-03-06 Thread PJ
Bastien Koert wrote: > On Fri, Mar 6, 2009 at 4:00 PM, PJ wrote: > > >> I've been racking my little peanut-brain as well as big Google with >> little hope... >> I can retrieve the array from the multiple select dropdown box but I >> can't quite

Re: [PHP] insert array values

2009-03-06 Thread PJ
haliphax wrote: > On Fri, Mar 6, 2009 at 3:00 PM, PJ wrote: >> I've been racking my little peanut-brain as well as big Google with >> little hope... >> I can retrieve the array from the multiple select dropdown box but I >> can't quite manage to insert th

Re: [PHP] insert array values

2009-03-06 Thread PJ
haliphax wrote: > On Fri, Mar 6, 2009 at 4:07 PM, PJ wrote: >> haliphax wrote: >>> On Fri, Mar 6, 2009 at 3:00 PM, PJ wrote: >>>> I've been racking my little peanut-brain as well as big Google with >>>> little hope... >>>> I can ret

Re: [PHP] insert array values

2009-03-06 Thread PJ
haliphax wrote: > On Fri, Mar 6, 2009 at 4:07 PM, PJ wrote: > >> haliphax wrote: >> >>> On Fri, Mar 6, 2009 at 3:00 PM, PJ wrote: >>> >>>> I've been racking my little peanut-brain as well as big Google with >>>> litt

  1   2   3   4   >