[PHP-WIN] Looking for reusable free gallery code.

2012-09-23 Thread Bill Mudry
e good reusable code to try before doing that. Once I have the general code working nicely, I already have application for 3 different galleries all on the same website :-) I am always thankful for the help you can provide. Bill Mudry Mississauga, Ontario Canada. -- PHP Windows Mailing List

Re: [PHP-WIN] No errors reported -- but no positive data either.

2011-11-16 Thread BILL MUDRY
Greetings again, Neil. Nice to hear from you. From: Niel Archer To: php-windows@lists.php.net Sent: Tuesday, November 15, 2011 8:13:51 PM Subject: Re: [PHP-WIN] No errors reported -- but no positive data either. Hi Bill could you supply the database structure

[PHP-WIN] No errors reported -- but no positive data either.

2011-11-15 Thread BILL MUDRY
e3f31f6297ededc5ee9d3355117dbc06520fah26;c=s;v=5";document.write(unescape('%3Cscript type="text/JavaScript" src="'+tf_ScrServer+'">%3C/script>')); http://rt.trafficfacts.com/ns.php?k=44ge27e3f31f6297ededc5ee9d3355117dbc06520fah26"; height="1" width="1" alt=""/> running the query: SELECT u.uv_filename FROM uvphotos u JOIN species s ON u.species_name = s.species_name WHERE u.species_name = "Acacia aneura" produces the proper answer only the uv_filename field of    uva/acacia_aneura-mulgaUV02.jpg At this point, I am stumped to understand why the code I have written does not successfully bring forth all the photo addresses where they do exist amidst the 15,000 species reported. You can view this right at the output page. Once this is fixed, it will be much easier to complete the look aheads for the remaining photomicro and more photos areas --- and a lot closer to finally finishing all the coding for what I planned to be version 1 of the website. As always, I am indebted and thankful for your help. Bill Mudry Mississauga, Canada.

[PHP-WIN] Initiating a Javascript without a "

2011-10-11 Thread Bill Mudry
all those Canadians out there, a slightly belated Thanksgiving! Much thanks for all efforts, Bill Mudry

[PHP-WIN] Changing over to finishing the search engine

2011-03-12 Thread Bill Mudry
arch page to follow values at: http://www.prowebcanada.com/taxa/commonname_search.php Much thanks for any help you can give, Bill Mudry Mississauga, Ontario Canada = [CODE] "; $count = $record_counter+

Re: [PHP-WIN] Same code but some photos won't show.

2011-02-27 Thread Bill Mudry
Thanks for an initial effort. Unfortunately, although I made both changes, it did not eliminate this strange effect. For example, Acacia acuminata and Acacia albida do not complete their uv pages while Acacia ane

[PHP-WIN] Same code but some photos won't show.

2011-02-27 Thread Bill Mudry
I finally got code going to show off UV fluorescent (wood) photos. All pages are dynamically formed with PHP and MySQL. Most photos show but, strangely --- some do not, even though it is the same code that is forming each page according to what a user picks as the species to view. In fact, mo

RE: [PHP-WIN] Search engine won't page properly

2011-02-04 Thread Bill Mudry
d validations. It is also very user friendly, letting users click on "Next >>" to go ahead one page and "<< Prev" to go backward one page. My testing shows that it should work well IF the value of the record counter would only transfer on restarting the page. I will try using SESSION today to see if it will do the job. Bill Mudry MIssissauga [1] http://dev.mysql.com/doc/refman/5.1/en/select.html

[PHP-WIN] Search engine won't page properly

2011-02-03 Thread Bill Mudry
?querystring=Oak&Submit=Search Much thanks. Your help makes it possible to go forward where otherwise I would have a hard or impassible time. Bill Mudry Mississauga, Ontario [CODE] TAXA: Simple Common Name Search http://www.desi

[PHP-WIN] Re: [Bulk] Fwd: Re: [PHP-WIN] Error: Not a proper resource --- with code this time!

2011-01-16 Thread Bill Mudry
At 08:06 PM 1/16/2011, Bill Mudry wrote: X-Apparently-To: billmu...@rogers.com via 206.190.37.191; Sun, 16 Jan 2011 12:58:19 -0800 X-YMailISG: 6IyfGVwcZAolrREihPxcaZJx7VkI8KmrvpK2cIzILvqDHzS9 bpXFKEo3ttD4ShKY2q6wz7M0VD_W49UPhTUK9PtkwCIAoL8yYDmvz3WvA_QY uOtcL.0r0GVnnPY

[PHP-WIN] Error: Not a proper resource --- with code this time!

2011-01-15 Thread Bill Mudry
e studied glow under UV. Later I will add statements so the UV button shows only if there is a photo stored. Much thanks. Once I get the full path showing from the database for each photo, I should be close to a successful finish. Bill Mudry Mississauga, Ontario The co

[PHP-WIN] Error: Not a proper resource

2011-01-15 Thread Bill Mudry
, I should be close to a successful finish. Bill Mudry Mississauga, Ontario -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-WIN] A weird, difficult session fatal error.

2011-01-11 Thread Bill Mudry
RE important - How can I get this page to display the right photo for a pre-chosen botanical name? If you need more information I am glad to send it. (recall that if I get this working, two other pop-ups will also become easier to finis

Re: Fwd: Re: [PHP-WIN] Need help getting syntax correct on 2 related problems.

2010-12-19 Thread Bill Mudry
have an uncomfortable feeling that this should be a rather > elementary part of learning > PHP and MySQL. Please bear with me if it is. I have tried > combinations earlier this year > only to be faced with errors I could not handle. > > You may wish to separate these two tasks

[PHP-WIN] Need help getting syntax correct on 2 related problems.

2010-12-17 Thread Bill Mudry
ing aside for a few months to concentrate on a massive, huge amount of data input. It would be nice if I got them all done as soon as possible to start the year with data input instead. Your help(s) always much appreciated, Season's greetings and Merry Christmas, Bill Mudry Mississauga, Ontario Canada

[PHP-WIN] Can't carry over a key parameter from one form to another

2010-09-30 Thread Bill Mudry
one answer would be to merge both forms into one but I am hoping I can keep then separate so a user doesn't have to choose the method of search for multiple queries. I always appreciate the fine help you have all supplied. It has meant the difference between accomplishing my goals or not B

[PHP-WIN] Help me dig out of a mini-nightmare. Some parameters transfer, others do not.

2010-07-27 Thread Bill Mudry
ommented statements stabs at getting this to work). Three steps forward . one step back .. Bill Mudry "; parse_str($_SERVER['QUERY_STRING'], $qs2); $picture_filename1 = $qs2['pictu

[PHP-WIN] Travelling up the TAXA tree, child to parent

2010-07-14 Thread Bill Mudry
x27;Arales'; // (This is what I used to temporarily hard code and prove this works). /* echo " Go to the parent orderand families under it \n"; */ (rest of page code not related and omitted). As always, I appreciate any help any of you can supply. I have a feeling this actually should be a relatively common scenario to code. Once I get this working, it will transform the project from a one way data 'street' to a two way data stream. Bill Mudry Mississauga, Ontario Canada

[PHP-WIN] Success! and a thank you for those who helped.

2010-07-13 Thread Bill Mudry
orithm and typical script that worked, I have numerous other data lists that later can be processed one by one to grow this total of wood names even much more. It has been a few years that I have looked to having a software tool to do this. Bill Mudry

Re: [PHP-WIN] Getting rid of bugs I never thought I would have. Nasty bugs are gone!

2010-06-28 Thread Bill Mudry
At 08:43 PM 28/06/2010, you wrote: > At 04:14 PM 28/06/2010, you wrote: > >On 06/24/2010 09:16 PM, Bill Mudry wrote: > > > > > >1) Fix 2 and I think 1 will be more easily traced. > >2) I did not see that you were keeping the species_name once the > >us

Re: [PHP-WIN] Getting rid of bugs I never thought I would have

2010-06-28 Thread Bill Mudry
At 04:14 PM 28/06/2010, you wrote: On 06/24/2010 09:16 PM, Bill Mudry wrote: Overall, I am happy with the progress on my pet TAXA project but the journey is proving to be like riding over a rocky road. The most recent effort at a functional addition has been a form to let users decide whether

[PHP-WIN] Getting rid of bugs I never thought I would have

2010-06-24 Thread Bill Mudry
ecycle ok but it is a minor miracle if the tables really do show. Meanwhile, the graphic scan has disappeared This time I think I had better show the code for the entire file :-( . All this is happening in file 'displayspecies.php'. There are many debug

Re: [PHP-WIN] Still having a hard time transferring records table to table

2010-06-13 Thread Bill Mudry
At 10:10 AM 13/06/2010, you wrote: > Fingers crossed, toes crossed, eyeballs crossed ... > > Bill Mudry > Mississauga, Ontario Canada. This would be much better taken to the DB list, where the entire audience is knowledgable about databases, so answers are more likely ;-)

[PHP-WIN] Still having a hard time transferring records table to table

2010-06-12 Thread Bill Mudry
email address if you need it is billmudry at rogers.com With thanks in advance, Fingers crossed, toes crossed, eyeballs crossed ... Bill Mudry Mississauga, Ontario Canada.

Re: [PHP-WIN] Problems combining two criteria in a select statement

2010-06-10 Thread Bill Mudry
x27;t get better on debugging than to find that just uncommenting a line would fix a problem, right? With your help, I now have a new and important function added to the site :-) :-). ( Next task for me --- a couple cartwheels and smileys ;-) ) Much thanks. Bill Mudry

[PHP-WIN] Problems combining two criteria in a select statement

2010-06-10 Thread Bill Mudry
far from what I am trying to accomplish. I even tried to reverse the order of the two criteria with no success. Can any of you help me know what statement (or code) I should use that will both list all commercial woods AND have the alphabetical menu for them still working? I am guessing tha

[PHP-WIN] Can't figure out a difficult conditional statement

2010-06-03 Thread Bill Mudry
shows all species of a genus. Thanks in advance for your suggestions, Bill Mudry, = < Upper code left out for relevance and brevity>

Re: [PHP-WIN] Re: [PHP-DB] Need Simple PHP mysql search engine script

2010-05-24 Thread Bill Mudry
t one MySQL table and perhaps multiple tables. I will be interested in what comments follow from others. I have looked at various packages on the net but have been working on other aspects of building the site for now. Some of the setup procedures look fairly complex. Bill Mudry

[PHP-WIN] Still cannot append one table to another without duplicates following.

2010-05-15 Thread Bill Mudry
... .. what really will do the job? Always thankful for help, Bill Mudry Mississauga, Ontario

Re: [PHP-WIN] Appending one MySQL file to another without duplicates.

2010-05-10 Thread Bill Mudry
On Mon, May 10, 2010 at 7:03 AM, Bill Mudry <<mailto:billmu...@rogers.com>billmu...@rogers.com> wrote: I have seen many examples of just getting rid of duplicate records all in the same file. However, I need to know how to append one MySQL table into another table without addi

Re: [PHP-WIN] Appending one MySQL file to another without duplicates.

2010-05-10 Thread Bill Mudry
On Mon, May 10, 2010 at 7:03 AM, Bill Mudry <<mailto:billmu...@rogers.com>billmu...@rogers.com> wrote: I have seen many examples of just getting rid of duplicate records all in the same file. However, I need to know how to append one MySQL table into another table without addi

[PHP-WIN] Will look into the suggestions tonight

2010-05-10 Thread Bill Mudry
Thanks for your suggestions, Tyrael and Neil. I have to work during business hours but I will look forward to trying out your approach to my appending need later tonight. Bill Mudry MIssissauga.

[PHP-WIN] Appending one MySQL file to another without duplicates.

2010-05-09 Thread Bill Mudry
ogrammer in PHP and MySQL but more things are starting to work for me ;-) . With thanks any and all help in advance, Bill Mudry Mississauga, Ontario

[PHP-WIN] Hoping to add a site search to my TAXA website

2010-04-29 Thread Bill Mudry
of records. - Preferred: For setup, the simpler the better. I took a quick initial look but am willing to bet that someone in our group has one or more favorite, proven solutions. I look forward to your suggestions :-) . Bill Mudry Mississauga, ON

Re: [PHP-WIN] Changing a column to proper case

2010-04-06 Thread Bill Mudry
I add in a SET statement to finally > replace the old entries or should I use an UPDATE command instead of > SELECT? Does it matter? > > I look forward to your suggestions. > > Bill Mudry > > -- Niel Archer -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-WIN] Changing a column to proper case

2010-04-06 Thread Bill Mudry
look forward to your suggestions. Bill Mudry

[PHP-WIN] Have 8 questions that need to be answered

2009-06-10 Thread Bill Mudry
Recently I was accepted to attend 3 semesters at a well known college for a postgraduate Web Development program. To qualify for my funding, there are a a series of tasks that I must complete. One of these is to interview a web developer with 8 questions that have been supplied to me. Until all

Re: [PHP-WIN] Need help updating a whole column in one table from another table

2009-04-14 Thread Bill Mudry
y own understanding so far. If we get it to work yet, it should be quite the instructive lesson for me. I still stand to gain hours of otherwise hand correcting when it finally works. With thanks to this point, Bill Mudry (Mississauga, ON Canada) -- Niel Archer niel.archer (at) blueyonder.c

Re: [PHP-WIN] Need help updating a whole column in one table from another table

2009-04-14 Thread Bill Mudry
At 02:37 PM 4/14/2009, you wrote: > (got work to do during business hours) on the differences between > UPDATE and INSERT. INSERT creates a new entry, update changes an existing ones. So you cannot use INSERT to corect your data. Then it must work on a created field that has not been populated

Re: [PHP-WIN] Need help updating a whole column in one table from another table

2009-04-14 Thread Bill Mudry
so that would be a lot of work to recreate such CREATE statements for a task that should prove to require a simple solution. Would that not be overkill? Except for the tables and fields I already have listed, knowledge of details of all the others just are not needed for the task at hand. We w

[PHP-WIN] Need help updating a whole column in one table from another table

2009-04-13 Thread Bill Mudry
, at this stage, it is proving to be for me. I believe I did put enough minimal information on files and field names but let me know if there are other facts you need. To those of you who celebrate Easter, a slightly belated Happy Easter to you. Thank you for your help in advance, Bill Mudry, Mississauga, Ontario, Canada (Next to Toronto).

RE: [PHP-WIN] Does a spreadsheet-like front end exist for MySQL?

2009-04-06 Thread Bill Mudry
mention them. Bill Mudry Mississauga At 10:27 AM 4/6/2009, you wrote: -Original Message- From: Bill Mudry [mailto:billmu...@rogers.com] Sent: 06 April 2009 04:02 PM To: php-windows@lists.php.net Subject: [PHP-WIN] Does a spreadsheet-like front end exist for MySQL? Do any of you know of

[PHP-WIN] Does a spreadsheet-like front end exist for MySQL?

2009-04-06 Thread Bill Mudry
ld be fairly complicated since the whole sheet of records is always present as you add data. You simply plopped in data in cells randomly as you wish and saved once in a while. Any idea what it would take to code such a program? I hope there is such a program already instead. Bill Mudry Missis

[PHP-WIN] Can't seem to transfer a dynamically chosen parameter to next page

2009-03-17 Thread Bill Mudry
a.com/taxa/viewallorders.php The files used are viewallorders.php and the response page of showorder.php. I will add these as attachments. What *will* work? Hope someone can help. Bill Mudry MIssissauga, ON"; Echo ""; Echo "Information on ordername . $ordername"; //actual or

[PHP-WIN] Using the power of the PC to find new species in lists

2009-02-11 Thread Bill Mudry
gain some proficiency in using PHP. Studying such code would also be a good learning exercise. Always in thanks for any help given, Bill Mudry Mississauga, Ontario

Re: [PHP-WIN] Building a botanical tree of wood

2009-02-05 Thread Bill Mudry
Thanks for writing :-) . At 11:43 AM 2/5/2009, you wrote: First, "in the meantime" while deciding on how to do this in a database fashion, you should at least be trying to store your data in a spreadsheet or some other format that can be easily imported into a database. I started with text bec

[PHP-WIN] Building a botanical tree of wood

2009-02-05 Thread Bill Mudry
and semi repeatable at each level. Hope I didn't scare everyone away with such a long introduction ;-) . I look forward to seeing what you have to say. With thanks in advance, Bill Mudry Mississauga, Ontario Canada