[PHP-DB] New to the list

2004-08-29 Thread Stuart Felenstein
also new to php and databases. Brief background to set the stage: I'm attempting to build a site. I'm using Dreamweaver, mySQL, and a RAD product called Impakt (the same people who do PHAKT). Impakt works on the php4 - ADODB model. Up to this point I haven't had to understand the code all too

Re: [PHP-DB] New to the list

2004-08-29 Thread Stuart Felenstein
no action can be taken on them. e.g., with php you can't get the selected state's city list until the user's request is submitted and a new page (with the specific city list) is returned to the user. -- Original Message -- From: Stuart Felenstein [EMAIL PROTECTED

[PHP-DB] Search page

2004-09-05 Thread Stuart Felenstein
K, first off I'm brand new to PHP and databases. So I hope my question isn't stupid or unfitting to the list. I am creating a search and results page of, right now 3 fields with more to add. Perhaps not necessary to my question, I have created a working SQL statement which involved one main

Re: [PHP-DB] Another newbie question

2004-09-06 Thread Stuart Felenstein
I think you need to put '' around joe 'joe' Stuart --- Pete Holsberg [EMAIL PROTECTED] wrote: On Mon, 6 Sep 2004 [EMAIL PROTECTED] wrote: you should copy/paste that into a command-line msyql session and see if that works. I cut the query back to SELECT * FROM Directory WHERE

[PHP-DB] Please help

2004-09-08 Thread Stuart Felenstein
I'm using a product called dbqwiksite pro. PHP generator for PHP - MySQL The code seems to be working fine except in my search page where I receive an invalid query $result = mysql_query($sql . . $sql_ext . limit 0,1) or die(Invalid query); This is the place I where the code is taking the

Re: [PHP-DB] Please help

2004-09-08 Thread Stuart Felenstein
. -- Peter Ellis - [EMAIL PROTECTED] Web Design and Development Consultant naturalaxis | http://www.naturalaxis.com/ On Wed, 2004-09-08 at 12:29 -0700, Stuart Felenstein wrote: I'm using a product called dbqwiksite pro. PHP generator for PHP - MySQL The code seems to be working fine except

Re: [PHP-DB] Please help

2004-09-09 Thread Stuart Felenstein
it's fine. Thank you , Stuart --- Steve Davies [EMAIL PROTECTED] wrote: What's contained in $sql and $sql_ext ??? Stuart Felenstein wrote: I'm using a product called dbqwiksite pro. PHP generator for PHP - MySQL The code seems to be working fine except in my search page where I

Re: [PHP-DB] Please help

2004-09-10 Thread Stuart Felenstein
] wrote: I think everyone knows that $sql is a statement. But what people are asking is: what is that statement?! Because if there are incorrect characters or 's in that statement, then that can break your code/statement. ~Philip On Sep 9, 2004, at 5:49 PM, Stuart Felenstein wrote

Re: [PHP-DB] Please help

2004-09-10 Thread Stuart Felenstein
On Friday 10 September 2004 07:49 am, Stuart Felenstein wrote: As I said this is a code generator (dbqwiksite). So, describing the process for creating the code is different. The $sql is fine, as far as typos or incorrect characterrs. I've gone through those statement very

Re: [PHP-DB] Please help

2004-09-10 Thread Stuart Felenstein
the WHERE column properly. I'm not familiar with the system you're using, but keep in mind, that mysql_error will usually not steer you wrong. -Micah On Friday 10 September 2004 10:03 am, Stuart Felenstein wrote: I had not, my apologies. I think your post slipped by. Anyway

Re: [PHP-DB] Please help

2004-09-10 Thread Stuart Felenstein
is? -Micah On Friday 10 September 2004 07:49 am, Stuart Felenstein wrote: As I said this is a code generator (dbqwiksite). So, describing the process for creating the code is different. The $sql is fine, as far as typos

Re: [PHP-DB] Please help

2004-09-10 Thread Stuart Felenstein
the error statement that mysql produces 2) Echo's the actual SQL statement that is sent to the DB you should be looking at #2 for answers, not your intended query. This 'actual' query is what I'm referring to. -Micah On Friday 10 September 2004 10:46 am, Stuart Felenstein wrote: I

[PHP-DB] Help please, back to an error

2004-09-13 Thread Stuart Felenstein
Thanks to help here I was able to overcome some ivalid query errors. Now I'm back, (probably the same mistake) It's coming off of this line: $sql .= And PostStart = DATE_SUB(CurDate(), Interval ['search_fd1'] day ); The 'search_fd1' is one of the form fields where a list of

Re: [PHP-DB] Help please, back to an error

2004-09-15 Thread Stuart Felenstein
PROTECTED] wrote: I'm thinking you should either get a better code generator, or learn more about php.. :) -Micah On Monday 13 September 2004 02:49 pm, Stuart Felenstein wrote: Thanks to help here I was able to overcome some ivalid query errors. Now I'm back, (probably the same

[PHP-DB] Passing URL parameters, how to hide

2004-09-19 Thread Stuart Felenstein
I'm still confused over one aspect of URL parameters. As far as a form passing data back to the server, I understand about get, post and replace. Here is my problem. I have an update form. User is logged in to the system and needs to update whatever information. Right now I'm including in the

Re: [PHP-DB] Passing URL parameters, how to hide-Nevermind

2004-09-19 Thread Stuart Felenstein
Ugh, I should rest on the weekends :) --- Stuart Felenstein [EMAIL PROTECTED] wrote: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-19 Thread Stuart Felenstein
Turned out hiding the id wasn't necessary as the awaiting update page can grab the session ID. I wasn't thinking. Sorry Stuart --- John Holmes [EMAIL PROTECTED] wrote: Stuart Felenstein wrote: I'm still confused over one aspect of URL parameters. As far as a form passing data back

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-20 Thread Stuart Felenstein
this has been dealt with more, I don't have the foggiest clue yet though how I can implement something that either hides, or prevents a user from going through records in the database by changing the id number. Appreciate any suggestions or ideas. Thank you, Stuart --- Stuart Felenstein [EMAIL

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-21 Thread Stuart Felenstein
/ -- Stuart Felenstein [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm restarting this post. I thought I was out of the woods, but not. Here situation, in most of my update forms which involve 1 record, passing

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-21 Thread Stuart Felenstein
. -- -- Jasper Howard :: Database Administration ApexEleven Web Design 1.530.559.0107 http://www.ApexEleven.com/ -- Stuart Felenstein [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I'm restarting this post

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-21 Thread Stuart Felenstein
not sure that what you speak about here is practicle or necessary for this application Stuart Bastien Koert From: M Saleh EG [EMAIL PROTECTED] Reply-To: M Saleh EG [EMAIL PROTECTED] To: Stuart Felenstein [EMAIL PROTECTED] CC: Jasper Howard [EMAIL PROTECTED], [EMAIL PROTECTED] Subject

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-21 Thread Stuart Felenstein
and assign those to various users. The permissions themselves are simply yes/no fields, assigned with checkboxes or radio buttons. Bastien Koert From: M Saleh EG [EMAIL PROTECTED] Reply-To: M Saleh EG [EMAIL PROTECTED] To: Stuart Felenstein [EMAIL PROTECTED] CC: Jasper Howard

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-21 Thread Stuart Felenstein
--- John Holmes [EMAIL PROTECTED] wrote: From: Stuart Felenstein [EMAIL PROTECTED] For whatever reason I can not use session only here. It does not return the correct record from the table. Don't say that you cannot use sessions, just say that you haven't figured out how

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-21 Thread Stuart Felenstein
So what I did was this statement: SELECT * FROM Table WHERE RecordID = blue and UserID = red blue is the variable for the recordID red is the variable for the userID So now when I change either of those variables in URL no record is returned. Did I finally get this right ? Stuart ---

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-21 Thread Stuart Felenstein
Nope, can't get to any other record. One would have to match both userid and recordID to get a hit. Perhaps now I should put this into a form and send it via hidden fields , for another layer of protection. Stuart --- John Holmes [EMAIL PROTECTED] wrote: From: Stuart Felenstein [EMAIL

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-21 Thread Stuart Felenstein
--- M Saleh EG [EMAIL PROTECTED] wrote: Ur 2nd question.. Okay .. how would u use the hidden inputs? with hidden inputs.. I mean the form hidden elements (input type=hidden name=id value=recordID /) so instead of having hyperlinks pointing to the form page use a form with submit btns

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-21 Thread Stuart Felenstein
the combination until they hit another valid record. Bastien From: Stuart Felenstein [EMAIL PROTECTED] To: John Holmes [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Passing URL parameters, how to hide Date: Tue, 21 Sep 2004 08:23:51 -0700 (PDT) Nope, can't get to any

Re: [PHP-DB] Passing URL parameters, how to hide

2004-09-21 Thread Stuart Felenstein
/ -- - Original Message - From: Stuart Felenstein [EMAIL PROTECTED] To: Jasper Howard [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 1:03 AM Subject: Re: [PHP-DB] Passing URL parameters, how to hide Up front it sounds like a good option. However, my

[PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Stuart Felenstein
I am in the process of building a search form for the database. The entire thing consists of 3 multi selects and 2 text boxes with a contains. Oh and I've only rigged 2 of the multi selects for the time being. So the way the multiselects should work that the user can choose one or the other or

Re: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Stuart Felenstein
K, I'll still take responses to this , but things seemed to have improved once I stopped using same variable for both boxes ooops! Stuart --- Stuart Felenstein [EMAIL PROTECTED] wrote: I am in the process of building a search form for the database. The entire thing consists of 3 multi

Re: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Stuart Felenstein
The list boxes are fed by tables that have state and state ID, same for industry. So all the joins are made in the main sql statement and working correctly. --- Doug Thompson [EMAIL PROTECTED] wrote: You need LocationState to be, in your example, Alabama OR California. Also, I would write

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Stuart Felenstein
select * from tablename where (jobs='accounting' or jobs='bookkeeping') and (state = 'AL' or state='CA') Bastien From: Stuart Felenstein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] MultSelect ListBox hell! Date: Wed, 22 Sep 2004 05:19:36 -0700 (PDT) I am

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Stuart Felenstein
.= OR job = '$job ; } $sql .= ); }else{ //$_POST['job'] is not an array $sql .= job = '.$_POST['job'].' ; }//end if ... ? And something like that needs to be done for each element in the search Bastien From: Stuart Felenstein [EMAIL PROTECTED] To: Bastien Koert

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Stuart Felenstein
--- Stuart Felenstein [EMAIL PROTECTED] wrote: Wow! Thank you! Stuart --- Bastien Koert [EMAIL PROTECTED] wrote: ah, i get the problem now... what you need to do is create the entire sql statement on the fly, based on whether or not there are results for a particular field

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Stuart Felenstein
See mid post: --- Ford, Mike [EMAIL PROTECTED] wrote: if (is_array($_POST['state'])){ $sql .= (; $x = 0; foreach ($_POST['state'] as $state) if ($x == 0){ $sql.= state = '$state' ; $x=1; }else{ $sql .= OR state = '$state' ;

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Stuart Felenstein
or just one if (is_array($_POST['state'])) $sql .= state='.implode(' OR state=', $_POST['state']).'; $sql .= ); }else{ $_POST['job'] is not an array $sql .= job = '.$_POST['job'].' ; } //end if ? --- Ford, Mike [EMAIL PROTECTED] wrote: -Original Message- From: Stuart

Re: [PHP-DB] MultSelect ListBox hell!

2004-09-23 Thread Stuart Felenstein
Well don't hate me for coming back here. I am shamed and embarassed enough. And while I appreciate all the great code and feedback received , I've run into a glitch. (oi) Because I'm using CodeCharge, it's not easy to just insert custom code anywhere. That is one of those code generators. I

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-24 Thread Stuart Felenstein
It's working great! I replaced the former parser with the implode. All is good again in the world! :) Mucho gracias! Stuart --- Ford, Mike [EMAIL PROTECTED] wrote: Mike - Mike Ford, Electronic Information Services

[PHP-DB] Question on Registration Method

2004-09-26 Thread Stuart Felenstein
Right now my registration / login system works like this: 1-User goes to registration page and fills out form 2-User gets to choose username but password is autogenerated by system 3-System encrypts password in database 4-Password is unencrypted and sent along with username to registrant's email

RE: [PHP-DB] Question on Registration Method

2004-09-26 Thread Stuart Felenstein
Currently there are only 2 types of users planned Each has a basic access level. I don't think this is the same as a usergroup though. If I don't have usergroups, but access levels, then perhaps I should set the level to some less then what is required login till activated. Then it sounds like

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Stuart Felenstein
the code and compare it to the ont in the database. If they match activate the user otherwise show an error. On Sun, 26 Sep 2004 05:54:14 -0700 (PDT), Stuart Felenstein [EMAIL PROTECTED] wrote: Ok , I think this is along the lines of what I've started. I added a column called active

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Stuart Felenstein
. On Sun, 26 Sep 2004 05:54:14 -0700 (PDT), Stuart Felenstein [EMAIL PROTECTED] wrote: Ok , I think this is along the lines of what I've started. I added a column called active with a default to 0. It's a tiny int since I'm think 0=fales, 1=true. So can you explain a tad more about

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Stuart Felenstein
I'm getting an error using the mysql_num_rows($result) Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/lurkkcom/public_html/lurktivate.php on line 7 Why am I counting the number of rows in the table? Shouldn't I be looking to see if the code I was

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Stuart Felenstein
Unknown column 'a338265f' in 'where clause' is the latest problem (and should be the last). I had this same error earlier while just doing a straight sql to the database. I corrected it then by putting apostrophes around the column name. That didn't help here , not quotes , maybe double

Re: [PHP-DB] Question on Registration Method

2004-09-26 Thread Stuart Felenstein
How are they any different? I'm seeing the same thing as your method. Stuart --- Jason Wong [EMAIL PROTECTED] wrote: On Sunday 26 September 2004 19:45, Stuart Felenstein wrote: While I'm okay with mine, not completely satisfied. I'd like to change it to the type where like above

[PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread Stuart Felenstein
I can't seem to figure this out. Right now I'm still trying to get the multi page form down. For the facts, running php 4.3.8, apache 1.3.x Register Globals are enabled So I'm starting the pages with: ?php session_start(); ? Now since this is a form, the user creates the value for the variable,

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread Stuart Felenstein
--- Jason Wong [EMAIL PROTECTED] wrote: If you don't have a specific reason for this to be enabled you should disable it. I don't control it. On a shared server. Question 1: is this enough to register the session variable ? No. You should read (repeatedly if necessary) manual

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread Stuart Felenstein
--- Jason Wong [EMAIL PROTECTED] wrote: The point is that you should understand *what* is going on with the examples. It's only when you've understood something that you can then apply it to other situations. Your right and I agree with you. My perspective is that the example(s) in the

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread Stuart Felenstein
I think I found the correct way. By registering the session variable in the next page is how they take. Form Page 1 - collect user input Form Page 2 - $_SESSION['name'] = $POST['myane']; This sound right? Stuart --- Stuart Felenstein [EMAIL PROTECTED] wrote: --- Jason Wong [EMAIL

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread Stuart Felenstein
Jason, thank you for all the help today! It's all working now. However, warning: I maybe back when I try to slam it all into the database. Stuart --- Jason Wong [EMAIL PROTECTED] wrote: On Monday 11 October 2004 19:42, Stuart Felenstein wrote: I think I found the correct way

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread Stuart Felenstein
I may have spoken too soon. Having one minor problem with getting an array (from a multiple select) to print out. Anyone see anything wrong here : Here is registering session array: if ( empty( $_SESSION['l_industry'] ) ) { $_SESSION['l_industry']=array(); } if ( is_array(

[PHP-DB] Suggestions for record insertion

2004-10-11 Thread Stuart Felenstein
I've put together a long form that spans 5 tables of the database. Once the user has reached the final page I want to insert into database but wonder what the logical steps would be. I'll be reading through manual , but thought I'd ask about things like rollback. I'm guessing that for whatever

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

2004-10-11 Thread Stuart Felenstein
'], $l_industry['1']... ? dave Stuart Felenstein [EMAIL PROTECTED] 10/11/2004 10:20 AM To: [EMAIL PROTECTED] cc: Subject: Re: [PHP-DB] Don't mean to be repetitive - Session Variables I may have spoken too soon. Having one minor problem

[PHP-DB] MySQL, Multiple tables, and Multipage form using sessions

2004-10-13 Thread Stuart Felenstein
Can anyone, someone please point me in the right direction. I have a multi page form, so at the last page I want to insert all data into database. Basically I'm trying to go from 0 - 90 , meaning my skills are less the basic. And this seems like a big task. Couple of other things. 1-There would

RE: [PHP-DB] mysql error and resource ID:

2004-10-14 Thread Stuart Felenstein
); --- Stuart Felenstein [EMAIL PROTECTED] wrote: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] mysql error and resource ID:

2004-10-14 Thread Stuart Felenstein
single quotes around the whole date, like '10/15/2004'. dave Stuart Felenstein [EMAIL PROTECTED] 10/14/2004 10:02 AM To: Stuart Felenstein [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql error and resource ID: Anyone see something

[PHP-DB] Converting Date for mysql

2004-10-14 Thread Stuart Felenstein
I have one of those widget calendars. Mysql keeps throwing back the date regardless of the way I format it. I'm passing session variables over to the database and have tried quotes ' around the date as well. Now I went ahead and changed this line: $_SESSION['f3k'] = $_POST['DateAvailable'];

Re: [PHP-DB] Converting Date for mysql

2004-10-15 Thread Stuart Felenstein
See below: --- John Holmes [EMAIL PROTECTED] wrote: Are you sure it's the date that's causing the rejection? What does mysql_error() say? No, I'm not sure. At first the date was being accepted but wrong in the database. It was setting it to 1/1/2000. Someone suggested I add '' around the

Re: [PHP-DB] Converting Date for mysql

2004-10-15 Thread Stuart Felenstein
Yes, my apologies to the list! Stuart --- David Robley [EMAIL PROTECTED] wrote: May I suggest that as well as echoing mysql_error() you also echo your query; that way you can see _exactly_ what is being passed to mysql and you can resolve problems like this simply and without resorting to

[PHP-DB] Help: Transactions not working

2004-10-15 Thread Stuart Felenstein
If you see the code I have the begin , then the $query follows. With both statements present, only the second one does the insert. If I // or remove the second, the first one takes. Am I missing something here ? Stuart Code: function begin() { mysql_query(BEGIN); } function commit() {

Re: [PHP-DB] Help: Transactions not working

2004-10-15 Thread Stuart Felenstein
That made a world of difference! :) Thank you. But - I want to confirm, am I still using transactions even though I'm issuing individual query calls for each insert. And, if I can ask another question to the list : In this line (from the second insert) VALUES (null, LAST_INSERT_ID(), ..);

Re: [PHP-DB] Help: Transactions not working

2004-10-15 Thread Stuart Felenstein
John, Big thank you! for your help. I had been trying out the mysql_insert_id and was not having luck. It's working great (with just a few more bumps to get over). --- John Holmes [EMAIL PROTECTED] wrote: Stuart Felenstein wrote: But - I want to confirm, am I still using transactions

Re: [PHP-DB] Help: Transactions working but question / issue

2004-10-15 Thread Stuart Felenstein
Here is my situation , not sure how I should handle it. I have this multi page form, at the end I use mysql transaction to get the data into all the tables. All the tables are innodb with the exception of one. The last page has one field which takes a copy/paste of a document, so it's a text

[PHP-DB] Array and insert statement throws error

2004-10-15 Thread Stuart Felenstein
Trying to get array of values into table. Each value will be part of a new record, so it's a loop. I am getting a parse error though and for further down in the code though I know this is what's causing it. Is there anything wrong with this statement ? if ( is_array( $_SESSION['l_industry'] )

Re: [PHP-DB] Array and insert statement throws error

2004-10-15 Thread Stuart Felenstein
Where would that go? Stuart --- Matt M. [EMAIL PROTECTED] wrote: if ( is_array( $_SESSION['l_industry'] ) ) { foreach ( $_SESSION['l_industry'] as $p ) { $query = INSERT INTO Profiles_Industries (ProfileID, IndID) VALUES ($LID, $p); } do you have a } for the if

Re: [PHP-DB] Array and insert statement throws error

2004-10-15 Thread Stuart Felenstein
Yep, I had found it shortly before. Only it's not looping. It is taking last value only. Stuart --- Matt M. [EMAIL PROTECTED] wrote: if ( is_array( $_SESSION['l_industry'] ) ) { foreach ( $_SESSION['l_industry'] as $p ) { $query = INSERT INTO Profiles_Industries

Re: [PHP-DB] Array and insert statement throws error

2004-10-15 Thread Stuart Felenstein
Actually it did just loop. I need to test again. The insert statement is the the one $query = So it's after yes, but contained in the braces, like you diagram below. Stuart --- Matt M. [EMAIL PROTECTED] wrote: where is your insert statement? I am guessing it is after your loop if (

Re: [PHP-DB] Array and insert statement throws error

2004-10-15 Thread Stuart Felenstein
. Assuming it MySQL: ... foreach(...) { $query = INSERT INTO ...; mysql_query($query); } On Oct 15, 2004, at 4:40 PM, Stuart Felenstein wrote: Yep, I had found it shortly before. Only it's not looping. It is taking last value only. Stuart --- Matt M. [EMAIL

[PHP-DB] Transactions - working but unsure about steps

2004-10-16 Thread Stuart Felenstein
My statements are all working but I'm not sure if things are set up correctly. I say this because at one point the first $query failed, yet the rest of inserts wre committed. Now I believe I need to set autocommit to 0 , yet the query failed due to a syntax error. Hence 0 records effected

Re: [PHP-DB] Transactions - working but unsure about steps

2004-10-16 Thread Stuart Felenstein
I think you are adding a conditonal /validaton statement as the constraint ? More then x characters will generate an error. My understaning is an error in mysql transaction will rollback should rollback the entire set of transactions. error handling for each statement- values will be coming from

Re: [PHP-DB] Transactions - working but unsure about steps

2004-10-16 Thread Stuart Felenstein
See Interspersed: --- Martín Marqués [EMAIL PROTECTED] wrote: I was tryiong to generate a validation that would fail with certain inserts (or modification of a register). Using more then 25 characters in the second field would yield the same result. Got that and yes, for my pages , they

RE: [PHP-DB] Transactions - working but unsure about steps

2004-10-16 Thread Stuart Felenstein
: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: 16 October 2004 13:53 To: [EMAIL PROTECTED] Subject: [PHP-DB] Transactions - working but unsure about steps My statements are all working but I'm not sure if things are set up correctly. I say this because at one point the first

[PHP-DB] Question: Putting seperate form elements into an array

2004-10-16 Thread Stuart Felenstein
Right now this seems something like solving a rubic's cube. While I process, I hope it's alright that i'm asking here. I think my quantity of posts have been high :) I have these form elements:(these are the names of the elements) skill1sky1 slu1 skill2sky2 slu2 skill3

RE: [PHP-DB] Question: Putting separate form elements into an array

2004-10-17 Thread Stuart Felenstein
Not exactly sure what I did here. there are 5 skill textfields name skill[] then the years sky[] then the last used slu[] I was following the format of my other arrays, so stored them list this: if ( empty( $_SESSION['l_skill'] ) ) { $_SESSION['l_skill']=array(); } if ( is_array(

RE: [PHP-DB] Question: Putting separate form elements into an array

2004-10-17 Thread Stuart Felenstein
); //Above line is where I am having the problem. There is something between LUID and the implode statement. LUID is not passing into the insert generating a sql error. $result = mysql_query($query); echo $query; --- Stuart Felenstein [EMAIL PROTECTED] wrote: -- PHP Database Mailing List

Re: [PHP-DB] Question on Registration Method

2004-09-28 Thread Stuart Felenstein
Well, finally suceeding to get by activation page working, where the 0 is flipped to 1 to mean actived, I'm stuck on the login page. Unfortunately I'm stuck :) with what I have below. It's part of an authentication system. This code doesn't include the includes, but I thought maybe significant

[PHP-DB] Capturing a sql query

2004-09-29 Thread Stuart Felenstein
I'm trying to capture a sql query and save it to the database. Not as a stored procedure , more a URL parameter string , to be called up at will. I have this code that I believe will take the URL, just not sure how to go about grabbing it. I think maybe a hidden form with POST. I'm open to

Re: [PHP-DB] Capturing a sql query

2004-09-29 Thread Stuart Felenstein
Let me explain what I'm trying to emulate. If you have seen any of the major job boards, they allow you to save search agents. Those agents at least on Monster, Dice, HotJobs I think , spare you the hassle of going to the search page and reentering the criteria. The agents can act in various

Re: [PHP-DB] Capturing a sql query

2004-09-29 Thread Stuart Felenstein
Joseph, So the cron job is where the rest of the query statement resides ? What I know about cron is that it's a way to schedule processes. But my point / question is , how are the keywords finding their way back into the statement. Thank you, Stuart --- Joseph Crawford [EMAIL PROTECTED] wrote:

Re: [PHP-DB] Capturing a sql query

2004-09-30 Thread Stuart Felenstein
Serialized because it is easier to store ? Stuart --- M Saleh EG [EMAIL PROTECTED] wrote: I'd recommand u to use a serialized variable saved in ur database. As in the an array of keywords saved in an serialized variable once the form is submited to save the query. e.g. $searchQuery =

Re: [PHP-DB] Capturing a sql query

2004-09-30 Thread Stuart Felenstein
Trying to set this up and have a question: Example below , the example for state. The field name is s_LocationState The variable is set to state. $State = ; // check any item is selected if (count($s_LocationState) 0 AND is_array($s_LocationState)) { $State = '.implode(',',

Re: [PHP-DB] Capturing a sql query

2004-10-01 Thread Stuart Felenstein
Just a followup and you can give me your opinion (which would be greatly appreciated. While I was working through the code, I came across a variable not previously in my awareness: $_SERVER[QUERY_STRING] all i do now is grab that and it inserts everything past the ? into the database. I

Re: [PHP-DB] Capturing a sql query

2004-10-01 Thread Stuart Felenstein
Right, and it is storing more then I need. After running it a few times, I decided to see what happens if someone chose every parameter possible. What I found is that even if I just saved the keywords, I'd still need to use mediumtext. In mysql, there doesn't seem to be anything between varchar

Re: [PHP-DB] Capturing a sql query

2004-10-01 Thread Stuart Felenstein
It's more then keywords actually. There are 3 list boxes, one for states, one for industries and one for taxterm., so 50 states , industries, something like 20 i think but may grow, taxterm - not many. Plus city search, job title search, how far back in days do you want to search, and finally

[PHP-DB] Invisible Submit

2004-10-01 Thread Stuart Felenstein
I'm sure this can be done, just not sure how, or more what it's called. If I have an awaiting form to capture input from session and url variables , instead of having a button to click to submit the form, a way that the form submits on it's own ? Stuart -- PHP Database Mailing List

Re: [PHP-DB] Invisible Submit

2004-10-01 Thread Stuart Felenstein
nothing to do with submitting a form. PHP just process the data passed to it. You can you javascript timers to automatically submit a form after a certain interval. On Oct 1, 2004, at 10:19 AM, Stuart Felenstein wrote: I'm sure this can be done, just not sure how, or more what

[PHP-DB] Multiple Selections from List Box

2004-10-03 Thread Stuart Felenstein
I'm creating some multiple selection list boxes. I believe this would be close to the correct code to pull the selections: select name=select size=3 multiple=multiple ?php $arrayselect = explode( , Please Select); ? option value=NY ?php for ($i=0; $isizeof($arrayselect); $i++) {if (NY

[PHP-DB] Opinions wanted - Multi select lists , implode explode

2004-10-04 Thread Stuart Felenstein
I was just told that having an array pulling multiple selections from a user out of a list box is a bad practice. Can this be true ? I was under the assumption it was perfectly effective. Thank you, Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] Opinions wanted - Multi select lists , implode explode

2004-10-04 Thread Stuart Felenstein
.$elements[1]; }elseif(($numOpts1)(in_array($elements[0],$matches))){ echo option value=\.$elements[0].\ SELECTED.$elements[1]; }else{ echo option value=\.$elements[0].\.$elements[1]; } }//end for echo /select; }//end function ? From: Stuart Felenstein [EMAIL

[PHP-DB] Multi Page Form

2004-10-04 Thread Stuart Felenstein
Not sure if I posted about this yesterday, anyway new question. I'm building a multi page form. So Im using hidden fields and echoing them to the next page in the loop. Now someone tells me this is dangerous. because someone can save the final page (with most of the hidden values) locally,

Re: [PHP-DB] Multi Page Form

2004-10-05 Thread Stuart Felenstein
Regarding Session Variables - Can't the session be set to expire , so that if someone tried to reload later it would fail ? Stuart --- Frank Flynn [EMAIL PROTECTED] wrote: Using hidden fields is not less secure than using visible fields - or session variables which were filled out by end

[PHP-DB] Session confusion

2004-10-06 Thread Stuart Felenstein
Back to my multi page form again ;) I am going to try it with Session variables . So, one thing is confusing me. The page requires the user to be logged in and is being tracked via authentication. Do I still need to do a session_start();, at the beginning of the form process ? Stuart -- PHP

Re: [PHP-DB] Re: Session confusion

2004-10-06 Thread Stuart Felenstein
variables. Here is a link of a tutorial about using sessions: http://www.phpfreaks.com/tutorials/41/3.php Look for the word MUST in red and read that paragraph. It should tell you what you need to know. Hope that helps, Aaron Stuart Felenstein [EMAIL PROTECTED] wrote

[PHP-DB] Obfuscator

2004-10-07 Thread Stuart Felenstein
I have been planning, when the time is right (site is ready for real time) , to add obfuscation to pages. Wondering what others are doing in this area. Is this a typical thing that better sites use ? I see some commercial PHP obfuscators out there, anyone have recommendations ? Thank you ,

[PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
Okay , so I'm working on the multi page form. Insert into DB will come at the last page. Couple of things I want to confirm: 1-Each page should have validiation for each field. Probably doesn't make any sense to wait for last page ? or maybe ? Below is the first page of the form: I only have

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
See interspersed: --- Bastien Koert [EMAIL PROTECTED] wrote: Hi Stu 1. why not check it on every page, then if it fails the user won't need to make it to the end and then have to go back to the beginning to fix something minor. 2. You could use hidden fields to pass the data back

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: Saturday, 9 October 2004 1:57 AM To: Bastien Koert; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Help: First Time Form with Sessions See interspersed: --- Bastien Koert [EMAIL PROTECTED] wrote: Hi Stu 1. why not check it on every

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
Well I guess too much success at once is a bad thing. For some unapparent reason, the variables here are not carrying over. Anyone see anything wrong here ? Page1 (Somewhat snipped) ?php session_start(); if ( empty( $_SESSION['l_education'] ) ) { $_SESSION['l_education']=array(); } if (

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
Figured it out. Page 2 had to have the field name in the $SESSION parameters, not the holder from the Page1 array register. Stuart --- Stuart Felenstein [EMAIL PROTECTED] wrote: Well I guess too much success at once is a bad thing. For some unapparent reason, the variables here

[PHP-DB] Help: Arrays with Session Variables not happening

2004-10-08 Thread Stuart Felenstein
Back again , sorry :) I had my form set up with 7 multi selects , on the return page, all 7 arrays were returned correctly. Now that I've changed back 5 to regular menu selects (1 selection), the 2 arrays left won't return the values. The menus work fine. Here is my code: Page 1: ?php

  1   2   >