Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 29
Search took 0.01 seconds.
Search: Posts Made By: scottiegirl
Forum: PHP Databases July 28th, 2008, 09:57 AM
Replies: 2
Views: 1,580
Posted By scottiegirl
John, I must be having a senior moment, and...

John,

I must be having a senior moment, and I do apologize, but I can't quite place (d chorus in heaven...) so I'm having difficulty placing you. Sorry again.

I appreciate your programming...
Forum: PHP Databases July 8th, 2008, 10:42 AM
Replies: 2
Views: 1,580
Posted By scottiegirl
Extracting a flexible amount of text from a field

I'll try to keep this as simple as possible. Here is the sample table (named News): ID, NewsTitle, NewsItem, NewsAuthor, NewsDate. I'm sure you can extrapolate their data types and possible lengths....
Forum: PHP Databases March 11th, 2008, 12:19 PM
Replies: 4
Views: 2,069
Posted By scottiegirl
And the Hallelujah Chorus rings throughout the...

And the Hallelujah Chorus rings throughout the heavens! Thank you, jmaronilla! It Works!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

HollyAnn
aka Scottiegirl

"I was put on Earth to...
Forum: PHP Databases December 7th, 2007, 07:38 PM
Replies: 4
Views: 2,069
Posted By scottiegirl
Nik, You are correct; there ARE 2 pages to...

Nik,

You are correct; there ARE 2 pages to handle this. They are both calling from the same table, but page 2, content is NOT generated from page 1's output.

Hmmm.... I really needed something...
Forum: PHP Databases December 7th, 2007, 03:57 PM
Replies: 4
Views: 2,069
Posted By scottiegirl
link to anchor in a db-generated page

I have monthly and non-monthly programs loaded into a table, field=moprog, that link to an anchor on another page that is db-generated.

Page 1 code:

if($data['moprog'] == 'Yes') echo "<p><a...
Forum: PHP Databases December 1st, 2007, 12:43 PM
Replies: 13
Views: 1,944
Posted By scottiegirl
Mike, Thanks for all of your help! I am...

Mike,

Thanks for all of your help! I am going to go to the client and ask if I can alter the layout of the home page slightly to accommodate the new coding, which, by the way, now works!

Here...
Forum: PHP Databases November 30th, 2007, 11:13 PM
Replies: 13
Views: 1,944
Posted By scottiegirl
OK, so I lied about when I was leaving my desk,...

OK, so I lied about when I was leaving my desk, and my hubby's not to happy about it either. I'm going to bed now, but I'll leave y'all with this tidbit....
Forum: PHP Databases November 30th, 2007, 07:57 PM
Replies: 13
Views: 1,944
Posted By scottiegirl
Sorry, Mike. I desperately needed some food, so I...

Sorry, Mike. I desperately needed some food, so I went out to dinner. I'm back in the office and will be here for another 2 hours or so.

I tried substituting DATA_SUB and it still doesn't work. I...
Forum: PHP Databases November 30th, 2007, 05:05 PM
Replies: 13
Views: 1,944
Posted By scottiegirl
OK. New plan everybody! Here's the scoop: ...

OK. New plan everybody! Here's the scoop:

Check this out:

$result2 = mysql_query("SELECT id, first_name, last_name, company, date_format( entry_date, '%Y' ) AS formatted_year, date_format(...
Forum: PHP Databases November 30th, 2007, 04:46 PM
Replies: 13
Views: 1,944
Posted By scottiegirl
SORRY! I forgot to tell you to use the newer URL:...

SORRY! I forgot to tell you to use the newer URL: http://www.hudsonmohawkastd.org/index-test3.php

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

HollyAnn
aka Scottiegirl

"I was put on Earth to...
Forum: PHP Databases November 30th, 2007, 04:45 PM
Replies: 13
Views: 1,944
Posted By scottiegirl
Definitely not a dumb question. I know I'm...

Definitely not a dumb question. I know I'm connecting to the db properly because the query for the "Upcoming Programs & Events" section above works perfectly (see below).

$result =...
Forum: PHP Databases November 30th, 2007, 03:17 PM
Replies: 13
Views: 1,944
Posted By scottiegirl
No problem. I've substituted your new code...

No problem.

I've substituted your new code and don't get any visible results. The page in question is http://www.hudsonmohawkastd.org/index-test2.php. The information should show up under the...
Forum: PHP Databases November 30th, 2007, 02:00 PM
Replies: 13
Views: 1,944
Posted By scottiegirl
Mike, Wow! That was fast! I put it in and...

Mike, Wow! That was fast!

I put it in and I'm getting an error:


Thoughts?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

HollyAnn
Forum: PHP Databases November 30th, 2007, 01:25 PM
Replies: 13
Views: 1,944
Posted By scottiegirl
Need date comparison and month from same db field

Greetings all, and happy holidays!

I need to find records of those who were entered into a db 3, 2, and 1 month(s) from the current month. I also need to echo the name of the month they were...
Forum: PHP Databases June 21st, 2006, 10:49 AM
Replies: 5
Views: 1,304
Posted By scottiegirl
Rich, You are just the bees knees! It works...

Rich,

You are just the bees knees! It works like a charm! I can't thank you enough!

To see what you've helped me with (many thanks again!), go to...
Forum: PHP Databases June 20th, 2006, 11:10 AM
Replies: 5
Views: 1,304
Posted By scottiegirl
Rich, That works great! What a beautiful...

Rich,

That works great! What a beautiful table!

My next step is to make the paging work. It shows all 40 items in the table on one page. I need to get it broken into groups of 10. Any further...
Forum: HTML Code Clinic June 20th, 2006, 07:52 AM
Replies: 4
Views: 1,663
Posted By scottiegirl
Your code: <form name = "hiddenForm" style =...

Your code: <form name = "hiddenForm" style = "position:absolute; padding:1; margin-left:1; left:219px; top:50px">
seems to have some misinformation in it. Why do you have margin-left, left, and...
Forum: PHP Databases June 20th, 2006, 07:38 AM
Replies: 5
Views: 1,304
Posted By scottiegirl
new table cols per record, paging, & select

I am producing an online catalog with no shopping cart for a client. Every sample I find to emulate either puts every record in its own row or fills one row with everything. My current page has the...
Forum: MySQL March 2nd, 2004, 04:02 PM
Replies: 4
Views: 1,527
Posted By scottiegirl
:D Vijay, you are a godsend. Everything printed...

:D Vijay, you are a godsend. Everything printed with all of the proper single quotes AND all gets inserted into the db properly.

I vow to review my PHP variables and MySQL query syntax!

Ever in...
Forum: MySQL March 2nd, 2004, 03:00 PM
Replies: 4
Views: 1,527
Posted By scottiegirl
You know, Vijay, I'll get this yet. [:I] Maybe a...

You know, Vijay, I'll get this yet. [:I] Maybe a sledgehammer would work better.....

Question: Do I remove the following code if I put in the "print" coding?

$result = mysql_query($query);
if...
Forum: MySQL March 2nd, 2004, 01:22 PM
Replies: 4
Views: 1,527
Posted By scottiegirl
Writing to an external database

Hello again all! Problem: Writing data gathered from an online form to a database on a server not at my location. The only info the server company can give me is Perl, not PHP.

Here is the table...
Forum: MySQL March 2nd, 2004, 12:55 PM
Replies: 25
Views: 3,706
Posted By scottiegirl
Sorry for the EXTREME delay in responding, Vijay....

Sorry for the EXTREME delay in responding, Vijay. Your suggestion worked! Hurrah! Life is good...



HollyAnn
aka Scottiegirl

"I was put on Earth to accomplish a certain number of things....
Forum: MySQL October 28th, 2003, 02:04 PM
Replies: 25
Views: 3,706
Posted By scottiegirl
1. I just found out I need the ",$dbcnx" in the...

1. I just found out I need the ",$dbcnx" in the query because of the nature of the server I'm on. Thanks for the info though.
2. I put the result into both types of "mysql_fetch_"s for testing.
...
Forum: MySQL October 28th, 2003, 10:31 AM
Replies: 25
Views: 3,706
Posted By scottiegirl
Thanks for the advice, but it's still a no go. I...

Thanks for the advice, but it's still a no go. I tried:
$result = mysql_query("SELECT pw FROM p WHERE id=$id", $dbcnx);

and
$result = mysql_query("SELECT pw FROM p WHERE id=id", $dbcnx);

and...
Forum: MySQL October 27th, 2003, 04:13 PM
Replies: 25
Views: 3,706
Posted By scottiegirl
Using a variable in a SELECT WHERE query

Hello! I am trying to query a table (p) with 2 columns (id, pw) to find the corresponding "password" using an "id" input by a user.

Page 1: inputs $id.
Page 2 follows:
<?php
// Connect to db...
Showing results 1 to 25 of 29

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.