[PHP] Tracking what has been changed

2005-05-04 Thread Robb Kerr
t_r() the SESSION variable, I still get "Array" as the contents. What's up? Thanx in advance for any help. -- Robb Kerr Digital IGUANA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Multiple Select Field

2005-04-03 Thread Robb Kerr
Please excuse the length and complexity of this post. I am facing a complicated problem and need to find a solution. Also, I have posted this on both PHP and MySQL boards so please overlook the possibly slightly off-topic subject. I have got one table that contains personal information about us

[PHP] Test post from a new client

2004-11-14 Thread Robb Kerr
This is a test post from a new client. I'm trying to decide whether or not to keep it. Please post a reply so that I can see how it shows up. Thanx, Robb

Re: [PHP] Advanced Query Wizard

2004-09-10 Thread Robb Kerr
On Fri, 10 Sep 2004 14:57:29 -0500, Greg Donald wrote: > On Fri, 10 Sep 2004 14:00:47 -0500, Robb Kerr > <[EMAIL PROTECTED]> wrote: >> This is not a sales post. > > It sure sounds like one, not that I care or anything. > > Curious.. did they have a non-windows v

[PHP] Advanced Query Wizard

2004-09-10 Thread Robb Kerr
and easily write sophisticated, joined queries with conditionals and sorting from many tables at once. It has made my life considerably easier so I wanted to pass on the information. https://www.advancedextensions.com/products.htm Thanx -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve

Re: [PHP] What's faster? MySQL Queries or PHP Loops?

2004-09-08 Thread Robb Kerr
>> loop through it generating a PHP array and pull from this array later OR I >> can query the database every time through the loop while creating the >> repeat region. >> >> Robb Kerr >> Digital IGUANA >> Helping Digital Artists Achieve their Drea

[PHP] What's faster? MySQL Queries or PHP Loops?

2004-09-08 Thread Robb Kerr
notice a measurable difference in speed? If my MySQL Server were a different machine, I'm sure that there would be a noticable difference because all of the queries would be across a network (possibly the internet) and traffic would become a factor. Just wondering what other people have notic

[PHP] Keep from using cache

2004-08-26 Thread Robb Kerr
owser to NOT use the cached version of the page. Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- PHP General Mailing List (http://www.php.net/) T

[PHP] Re: HTML Table display based upon field contents

2004-07-24 Thread Robb Kerr
On Sat, 24 Jul 2004 23:23:49 +0200, Tularis wrote: > Robb Kerr wrote: > >> I have a complicated table that needs to be altered depending upon the >> contents of a field in one of my recordsets. I've tried several approaches >> and need to know what you recomme

Re: [PHP] HTML Table display based upon field contents

2004-07-24 Thread Robb Kerr
ork? > > Sorry if this is just dumb. Trying to learn. :) > > Kevin > > -----Original Message- > From: Robb Kerr [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 24, 2004 4:47 PM > To: [EMAIL PROTECTED] > Subject: [PHP] HTML Table display based upon field contents

[PHP] HTML Table display based upon field contents

2004-07-24 Thread Robb Kerr
technique won't work.                         Should I simply describe the entire relevant s on one line, appropriately escape them, assign the to a variable and then use an ECHO to put them on the page? Or does someone have a simpler more elegant

Re: [PHP] Nested If...Else...

2004-07-24 Thread Robb Kerr
On Sat, 24 Jul 2004 12:09:41 -0400, Scot L. Harris wrote: > On Sat, 2004-07-24 at 12:05, Robb Kerr wrote: >> What's wrong with this syntax. I just can't see my mistake. >> >> if ($vBkgrndImage == "AnswerPage") { >> if ($vAnswerID_RS_Pa

Re: [PHP] Nested If...Else...

2004-07-24 Thread Robb Kerr
]) { >> $vBkgrndImage = "Bkgrnd-Body-Incorrect.jpg"; >> } else { >> $vBkgrndImage = "Bkgrnd-Body-Correct.jpg"; >> } >> } >> >> Thanx >> -- >> Robb Kerr > > I can't see anything wrong. What's the e

Re: [PHP] Nested If...Else...

2004-07-24 Thread Robb Kerr
On Sat, 24 Jul 2004 12:09:41 -0400, Scot L. Harris wrote: > On Sat, 2004-07-24 at 12:05, Robb Kerr wrote: >> What's wrong with this syntax. I just can't see my mistake. >> >> if ($vBkgrndImage == "AnswerPage") { >> if ($vAnswerID_RS_Pa

Re: [PHP] Nested If...Else...

2004-07-24 Thread Robb Kerr
On Sat, 24 Jul 2004 18:18:23 +0200, Marek Kilimajer wrote: > Robb Kerr wrote: >> On Sat, 24 Jul 2004 12:09:41 -0400, Scot L. Harris wrote: >> >> >>>On Sat, 2004-07-24 at 12:05, Robb Kerr wrote: >>> >>>>What's wrong with this syntax.

Re: [PHP] Nested If...Else...

2004-07-24 Thread Robb Kerr
On Sat, 24 Jul 2004 12:09:41 -0400, Scot L. Harris wrote: > On Sat, 2004-07-24 at 12:05, Robb Kerr wrote: >> What's wrong with this syntax. I just can't see my mistake. >> >> if ($vBkgrndImage == "AnswerPage") { >> if ($vAnswerID_RS_Pa

[PHP] Nested If...Else...

2004-07-24 Thread Robb Kerr
"Bkgrnd-Body-Correct.jpg"; } } Thanx -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] If...Or...Else

2004-07-24 Thread Robb Kerr
>From time to time I need an If statement that includes an Or condition... What's the correct syntax for the If line? Thanx -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.

[PHP] Code elegance and cleanliness

2004-07-23 Thread Robb Kerr
tive.gif"); $imgName = $imgBkgrnd[$table['field']]; The first example uses one more variable and a longer code block but is easier to read and debug. The second example uses one less variable and a shorter code block but is harder to debug later. Should I be striving for the shortest

Re: [PHP] Array help

2004-07-23 Thread Robb Kerr
ot;=> "bkgrnd-default.gif", "2" => "bkgrnd-positive.gif", "3" => "bkgrnd-negative.gif"); imgNeeded = table['field']; imgName = ??? Now, how do I get the image name associated with the key number obtained from my table out of the array

[PHP] JavaScript in PHP or PHP in JavaScript

2004-07-23 Thread Robb Kerr
h would be better? JavaScript in PHP several lines of JavaScript PHP in JavaScript several lines of JavaScript <?php if (conditional) { echo 'lines of JavaScript'; } else { echo 'other lines of JavaScript'; } ?> several lines of Java

[PHP] Array help

2004-07-23 Thread Robb Kerr
g entries in the field ("1" or "2" or "3", etc.) with image filenames ("bkgrnd-default.gif" or "bkgrnd-positive.gif" or "bkgrnd-negative.gif", etc.) Thanx, Robb -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve

Re: [PHP] HTML Escaping

2004-07-23 Thread Robb Kerr
?> > > You can close out your php declaration at any time and just put in > regular text. It's a lot easier doing it this way than echo'ing many > lines and you don't have to worry about escaping quotes. > > On Jul 23, 2004, at 2:07 PM, Robb Kerr wrote:

Re: [PHP] HTML Escaping

2004-07-23 Thread Robb Kerr
On Fri, 23 Jul 2004 14:43:29 -0400, John W. Holmes wrote: > Robb Kerr wrote: >> I've got a conditional button that needs to appear/hide on my page >> depending upon the contents of a field in my database. The button is an >> image and has a long URL and JavaScript for

[PHP] HTML Escaping

2004-07-23 Thread Robb Kerr
quot; characters. My conditional works great but I want to know if there is an easy way to escape the whole href so that the "'" characters will not be seen as PHP quote marks. See below... ; ?> Thanx in advance, Robb -- Robb Kerr Digital IGUANA Helpin

[PHP] htmlArea look-a-like

2004-07-21 Thread Robb Kerr
trigued by it. Does anyone know of anthing else like these availlable on the market? htmlArea = http://www.interactivetools.com/products/htmlarea/ EditLive! = http://www.ephox.com/product/editliveforjava/default.asp Thanx, Robb -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve th

Re: [PHP] OT but need guidance in timing page views

2004-07-19 Thread Robb Kerr
lemented correctly. > > On the other hand, it will be a bit load producing, while that > subsequent writes to database... > > Hope it helped a bit, > regards, > m. > > Robb Kerr wrote: > >> I know that this is somewhat off topic, but I just need a starting p

Re: [PHP] OT but need guidance in timing page views

2004-07-19 Thread Robb Kerr
e to pass an exam at the end of the course. So, if they just leave the page open and don't read the contents, they probably won't be able to pass the test. At least I can report to the accredidation agency that the student had the course open for the required amount of time. Robb --

[PHP] OT but need guidance in timing page views

2004-07-19 Thread Robb Kerr
chine crash? Also, if anyone knows of a good javascript newsgroup, please pass along the info. Thanx, Robb -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org --

Re: [PHP] Help with array / list looping syntax

2004-06-29 Thread Robb Kerr
gt; $vowels = array('a', 'e', 'i', 'o', 'u'); >> echo 'Member has a'.(in_array($table['field'][0], $vowels) ? 'n' : >> '').' '.$table['field'].' who is...'; > >

[PHP] Help with array / list looping syntax

2004-06-29 Thread Robb Kerr
loppy version of what I'm trying to do... There's got to a cleaner way to do this. Perhaps using a list or array containing the vowels and steping through it checking the first letter of the field contents against each member of the list. But, I don't know how to code this sys

[PHP] Random Record Retrieval

2004-05-22 Thread Robb Kerr
then have MySQL retrieve that ID. Is this the way to go or is there something simpler. And, if this is the best way to go, unfortunately I don't know how to write a random number generator in PHP so would appreciate any help. Thanx in advance, Robb -- Robb Kerr Digital IGUANA Helping Digita

[PHP] Use PHP to copy MySQL tables

2004-04-08 Thread Robb Kerr
ss to the MySQL server and don't want them backing up to their hard drive. I prefer to simply copy the tables to "backup" versions on the server so that if problems arise, I can log into the server and simply copy the "backups" to the originals. Thanx in advance. -- Robb Ker

Re: [PHP] Keyword Search

2004-04-06 Thread Robb Kerr
e.tablename MATCH (dbname.fieldname) AGAINST 'Figs' > [/snip] > > A. Belongs on a SQL list (and there are plenty) > 2. SELECT * FROM dbname.tablename WHERE (dbname.fieldname) LIKE '%Figs%' Thanx for the advice. I'll give it a try. BTW, I know that some of my que

[PHP] Keyword Search

2004-04-06 Thread Robb Kerr
search on this field to return all of the records containing "Figs". What's the search syntax? I've tried... SELECT * from dbname.tablename MATCH (dbname.fieldname) AGAINST 'Figs' It doesnt' work. Thanx in advance -- Robb Kerr Digital IGUANA

Re: [PHP] Connecting to Databases

2004-04-06 Thread Robb Kerr
On Tue, 6 Apr 2004 10:24:29 -0500, Robb Kerr wrote: > On Tue, 6 Apr 2004 11:18:11 -0400, John W. Holmes wrote: > >> From: "Robb Kerr" <[EMAIL PROTECTED]> >> >>> I have found that it is not uncommon when trying to connect to a database >>> on

Re: [PHP] Connecting to Databases

2004-04-06 Thread Robb Kerr
On Tue, 6 Apr 2004 11:18:11 -0400, John W. Holmes wrote: > From: "Robb Kerr" <[EMAIL PROTECTED]> > >> I have found that it is not uncommon when trying to connect to a database >> on an Apache server to get a return similar to "Access denied for user: >

[PHP] Connecting to Databases

2004-04-06 Thread Robb Kerr
connect although I can connect Dreamweaver to the database without problem even though the IPAdress is not listed as part of the username. What's up? -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org

[PHP] MySQL Connection Help

2003-11-16 Thread Robb Kerr
uot;newbieness" of this question but it's been driving me crazy and I'm sure I'm just missing something simple. Thanx in advance for any help provided. -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreal

[PHP] DW Php update record form with menu from another table

2003-11-10 Thread Robb Kerr
ached is the entire page for consulting. I've also posted this message on Dreamweaver's newsgroup but haven't been getting any responses so thought I'd see if this group had any suggestions. Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://

[PHP] Re: DW Php update form where one field is menu from another table

2003-11-09 Thread Robb Kerr
Thanx. I placed there as well, but wasn't getting any responses so thought I'd try this group as it has been invaluable in the past. Finally got a response on the Macromedia group so I'll try that suggestion. -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve th

[PHP] DW Php update form where one field is menu from another table

2003-11-08 Thread Robb Kerr
#x27;s up? These "drop-downs from another table" work fine in "Add" forms. They just seem to crap out in "Update" forms. Attached is the entire page for consulting. Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www

[PHP] JavaScript Newsgroup

2003-11-03 Thread Robb Kerr
What's your favorite JavaScript newsgroup? This group has been invaluable in helping me learn PHP and need the same for JS. Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- PHP General Mailing

Re: [PHP] more proplems with passing arrays

2003-11-02 Thread Robb Kerr
rray)); > > Then in the code that gets the serialized array: > > $original_array = unserialize(base64_decode($_GET["whatever"])); > > HTH Lowell, Thank you VERY MUCH for your response. I've been messing with this problem all day and your response was the first

[PHP] more proplems with passing arrays

2003-11-02 Thread Robb Kerr
t my test files follow this URL... http://www.cancerreallysucks.org/SerializeTest/Search01.htm Attached are the HTM & PHP files. Please take a look and tell me what's wrong. I appreciate any help. I just can't seem to get the seemingly simple thing to work. Thanx, -- Robb Kerr D

[PHP] passing an array via GET and a hidden form element

2003-11-02 Thread Robb Kerr
..&manufacturer%5B%5D=Array..." When analyzing the variable on the results page, I wind up with $manufacturer equaling an array with one element equaling "Array"... Array ( [0] => Array ) Any suggestions? Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achiev

[PHP] Re: passing variables to subsequent pages

2003-11-02 Thread Robb Kerr
tion Except for the last two entries, the others all passed "...&manufacturer%5B%5D=Array..." Any more suggestions? Thanx, -- Robb Kerr Digital IGUANA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] passing variables to subsequent pages

2003-11-02 Thread Robb Kerr
using a SUBMIT button and don't know how to include this information in the URL being passed. Any suggestions? Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- PHP General Mailing List (http://w

[PHP] eliminating dupes from MySQL query results

2003-11-01 Thread Robb Kerr
y duplicates. I need to remove all duplicates so that each entry is only displayed once. Another query based upon a selection from this list will display all of the appropriate records. Can anybody help with the syntax? Do I need a loop or is there a MySQL command/function which I am overlooking?

[PHP] deleting characters from strings

2003-11-01 Thread Robb Kerr
query winds up with an extra "OR" at the end. I need to simply delete characters (STRLEN($string) - 3) through STRLEN($string). What's the proper syntax? Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreal

[PHP] Php processor and return window

2003-10-31 Thread Robb Kerr
ctly where the error occurred. Does anyone know about anything like this for PhP? Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, v

[PHP] multiple entries for a variable passed with GET

2003-10-29 Thread Robb Kerr
RobesonWeb/robeson1searchB.php?manufacturer=JUKI&manufacturer=REECE&manufacturer=WELDTRON&Submit=Submit Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- PHP General Mailing List (http://www.php.net/) To un

[PHP] conditional within SELECT

2003-10-29 Thread Robb Kerr
OM robeson_inv WHERE MATCH (robeson_inv.specs) AGAINST ('vKeywords') AND robeson_inv.manufacturer = 'vManufacturer' ORDER BY robeson_inv.model Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreall

[PHP] Favorite Online Language Guide

2003-10-29 Thread Robb Kerr
What's your favorite online Php language guide? I'm a newbie and most interested in a syntax guide. Thanx, -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- PHP General Mailing List (http://www.ph

[PHP] Re: Query explanation

2003-10-29 Thread Robb Kerr
code.Code FROM areacode, state > WHERE areacode.State = state.ID > ORDER BY state.Name, areacode.Code > > Alexander Thanx. It looks like I'm actually learning this stuff. hehe -- Robb Kerr Digital IGUANA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Query explanation

2003-10-29 Thread Robb Kerr
t; are field names in two different tables. But, I can't find a place where these variables are initiated in the preceding code. I also don't understand what's going on in the FROM statement. "Areacode" and "state" are table names. That I understand. What's with

Re: [PHP] Menu populated based on previous menu

2003-10-28 Thread Robb Kerr
lt;?php > $count = 0; > while (!$users->EOF)) > { > echo 'users['.$count.'] = '.$users->fields['username'].chr(10); > $count++; > $users->MoveNext(); > } > ?> > //--> > > > The users array will now be popula

Re: [PHP] Menu populated based on previous menu

2003-10-28 Thread Robb Kerr
s accessed via PhP. In Java line... new Array() can I embed the PhP... > Thanx, -- Robb Kerr Digital IGUANA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Menu populated based on previous menu

2003-10-28 Thread Robb Kerr
Thanx for the tips. I'll search the JavaScript sites and see what I can come up with. -- Robb Kerr Digital IGUANA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Menu populated based on previous menu

2003-10-28 Thread Robb Kerr
the first selection is made without adding a SUBMIT button and loading a second page. Anyone know how to accomplish this? Thanx in advance. -- Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.cancerreallysucks.org -- PHP General Mailing

Re: [PHP] keyword search syntax

2003-10-28 Thread Robb Kerr
executing a MATCH... AGAINST command worked like a dream. -- Robb Kerr Digital IGUANA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] keyword search syntax

2003-10-27 Thread Robb Kerr
On Tue, 28 Oct 2003 02:09:06 +, David Otton wrote: > > Personally, I'd normalize that into a keyword table, a record table and a > joining table. > > However, the SQL keyword you're looking for is LIKE > > WHERE field LIKE '%$variable%' I agree. I'd structure the data quite differently. Bu

[PHP] keyword search syntax

2003-10-27 Thread Robb Kerr
ds entered to a variable which is passed via GET to the results page. What is the syntax for generating this query. I tried the following but it doesn't work... WHERE field CONTAINS $variableContainingKeywordEntry Can anyone help? Thanx in advance, Robb Kerr - Digital IGUANA Helping

Re: [PHP] PhP/MySQL Search Results code

2003-10-27 Thread Robb Kerr
That was it! Thanx for the help. This board has proven invaluable to me. Robb -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PhP/MySQL Search Results code

2003-10-27 Thread Robb Kerr
g, "$vManufacturer_rs_RobesonResultsList = (get_magic_quotes_gpc()) ? manufacturer : addslashes(manufacturer);" Anyone know what the problem may be? Thanx in advance for any help provided, Robb Kerr Digital IGUANA Helping Digital Artists Achieve their Dreams http://www.digitaliguana.com http://www.c

[PHP] Re: Avoiding blank lines in HTML when field is empty

2003-10-24 Thread Robb Kerr
On Thu, 23 Oct 2003 12:46:29 -0500, Robb Kerr wrote: Thanx for all the help. Your suggestions worked beautifully. Robb > I'm a PhP /MySQL newbie so please excuse the simple question. I'm returning > results from a MySQL query on a webpage.

[PHP] Avoiding blank lines in HTML when field is empty

2003-10-23 Thread Robb Kerr
I'm a PhP /MySQL newbie so please excuse the simple question. I'm returning results from a MySQL query on a webpage. My code includes... , , Phone: Email: Here's the problem. Some of the fields are empty (for instance 'Address') an