Re: [PHP-DB] PHP2 Forum Crashed

2003-10-28 Thread Jim Hunter
Can't help you if you take the site down. It didn't do you any good to post the link if your code is no longer there. Jim ps- I tried to reply directly to you but it seem that Earthlink does not want to accept my e-mails because I am not an EarthLink user. How lame is that!? 550-EarthLink do

Re: [PHP-DB] mysql field not resolving comaparison condition for zip code locator

2003-09-23 Thread Jim Hunter
Jennifer is correct, the query that you have below will never return anything. The last two AND statements exclude each other. You need to change the greater than and less than signs on them and try it again. For now, don t take what the developer is telling you as the gospel, go with what the log

RE: [PHP-DB] Browser-Trouble with Query

2003-09-03 Thread Jim Hunter
Sounds like you had a cache problem going on. I wanted to suggest that but got tied up on something else. Whenever you see the same results, even though you are changing the code, try and delete the cache files in the browser, exit the browser, then come back in and try it again. Usually this clear

Re: [PHP-DB] Apache Problem

2003-03-12 Thread Jim Hunter
What does the code look like for the page you are trying to load? There is an error in the code that is causing the problem, or the page does not return anything viewable. If you call a PHP page that returns nothing because of problems with your code, this is the error you will get. Start by adding

Re: [PHP-DB] Define()

2003-03-12 Thread Jim Hunter
The reason it doesn't work may go beyond PHP. You are trying to make an HREF point to an exact location on your hard drive. When the user of your web page clicks the link, they do not have that location on their system so it will fail. Always use relative locations for links. Then once you get that

Re: [PHP-DB] Real Killer App!

2003-03-12 Thread Jim Hunter
from a web page. Jim Hunter ---Original Message--- From: Nicholas Fitzgerald Date: Wednesday, March 12, 2003 10:15:52 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Real Killer App! Rich Gray wrote: >>I'm having a heck of a time trying to write a little web crawler f

Re: [PHP-DB] how to show online members.

2003-03-12 Thread Jim Hunter
There was a post yesterday on PHP Classes that is this very thing. Go to www PHPclasses.org and search for UsersOnline2. This should help you out a bunch Jim hunter ---Original Message--- From: Smita Manohar Date: Wednesday, March 12, 2003 09:59:42 AM To: [EMAIL PROTECTED] Subject

Re: [PHP-DB] some php and database questions!

2003-03-11 Thread Jim Hunter
to the database. Jim Hunter ---Original Message--- From: JeRRy Date: Tuesday, March 11, 2003 17:23:47 To: [EMAIL PROTECTED] Subject: [PHP-DB] some php and database questions! Hi, I am currently running a tipping competition where people tip the team they think will win the given g

Re: [PHP-DB] retrieve last n records

2003-03-06 Thread Jim Hunter
last n rows where user_id = whatever, then be able to sort those last 3 rows ASC or DESC by any field. Jim Hunter wrote: > > > I guess I am confused, how does one query effect a query that you have in > an other part of the page? The two queries are not related. The second thing >

Re: [PHP-DB] retrieve last n records

2003-03-06 Thread Jim Hunter
I guess I am confused, how does one query effect a query that you have in an other part of the page? The two queries are not related. The second thing I am confused on is: Do you want the last n records that were added to the table or do you want the last n records in a given index? Jim ---

Re: [PHP-DB] Members area

2003-01-22 Thread Jim Hunter
Gavin, Download PHP-Nuke and look to see how they handle Non-Users/users/Admins and go from there. It's actually quite easy. They have a table structure that you could utilize and some generic routines for determining if a user is logged in or if they are an Admin. www.phpnuke.org Jim

Re: [PHP-DB] mysql wildcard

2003-01-08 Thread Jim Hunter
If you want all records, remove the where clause. select * from mytable Jim ---Original Message--- From: Edward Peloke Date: Wednesday, January 08, 2003 02:03:04 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql wildcard I have an query: select * from offtime where

Re: [PHP-DB] multiple pages

2003-01-08 Thread Jim Hunter
The simplest way is to use the LIMIT keyword in your SQL statement. Set, or allow the user to set, the number of items to show at one time, then keep this number as a hidden field and use it to determine what record to go to when they click the page number or the next button. So a sample would look

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Jim Hunter
Alex, Your setup will not work like you think. To do what you want you are going to need 2 hubs unless you are doing some sort of NAT on the server. I have this exact same setup and have set up many like it. If you write me directly I can help you out on this, there are a few questions I have

Re: [PHP-DB] Parse Error...

2002-12-02 Thread Jim Hunter
In that case, your logic is not going to work. You have live PHP code inside a string. You are going to need to build the $message in pieces. Start with the HTML, then add the result from each itteration of your PHP loop to $message then add the trailing HTML to form the complete $message. Your

Re: [PHP-DB] Credit Card Info & Cryptography

2002-10-23 Thread Jim Hunter
There is a simple alternative that you might not be aware of, and that is use Advantage Database (I am assuming that you are using MySQL right now). You can get a free version to try and it provides encryption at the table level. There is a PHP interface for it and everything can be found at www ad

Re: [PHP-DB] Flush database

2002-09-27 Thread Jim Hunter
First make sure that you are storing the IP and the time it was saved in the database. Then I would have 3 queries: 1) a query to see if the IP address is in the database and less then an hour old. 2) a query to save the IP and time into the database 3) a query to delete all entries over 1 hou

Re: [PHP-DB] Can't see the results

2002-09-06 Thread Jim Hunter
Your problem seems to stem from the $content .= $row; $row is an Array and you must use an index to get at any given value it holds. If you need all of the values in $row, use the count() function to get the number of elements (columns in this case), then loop through them adding them to $content

Re: [PHP-DB] not a valid MySQL result

2002-09-06 Thread Jim Hunter
Oops, you have one more error that I see, one one line you reference author-cat as a table name and on another you refer to it as author_cat. Make the appropriate change and try it again. One of the table references is wrong and will generate a missing table error. Jim ---Original Messag

RE: [PHP-DB] not a valid MySQL result

2002-09-06 Thread Jim Hunter
Change your query to be: $query_cat = "select concat(author_names, ' ', author_surnames) as somenewcolname from author, author-cat where author_cat.cat_code = $code and author.author_code = author-cat.author_code"; Change somenewcolname to whatever you want the column to be called or lea

Re: [PHP-DB] best way to stare true, false

2002-08-11 Thread Jim Hunter
se globals there as well avaialable to all your programs without thinking about it again. Remember, keep your code readable, runable and reusable! Jim Hunter Diamond Computing ---Original Message--- From: andy Date: Saturday, August 10, 2002 07:40:19 AM To: [EMAIL PROTEC

RE: [PHP-DB] adding a space in mysql

2002-07-31 Thread Jim Hunter
the equals operator, then you are guaranteed an exact match. If you are concerned about matching any case, then set both strings to UPPER case then do the compare. Jim Hunter ---Original Message--- From: Hutchins, Richard Date: Wednesday, July 31, 2002 13:48:17 To: 'ron w