stevevan

(do I dare say it? Ok...I will!) sex

view

Given the proactive attitude of TCH, I wouldn't worry too much. But this is just another reason why one makes regular backups!

Received the following error on the webpage: Here's the code in question: >// define function auth_user() function auth_user($username, $userpassword) { // Set up global variables to connect to the database and "Referee" table global $default_dbname, $user_tablename; $link_id = db_connect($default_dbname); /* Now that we're connected, create a query for a record whose "username" and "userpassword" entries correspond to the user-provided arguments, then select the Tempusername value for that record. Note that $userpassword is encrypted BEFORE it is compared with the value in the Referee table. This compares two encrypted values which have been derived by exactly the same process and will therefore (in theory anyway!) be identical. */ $query = "SELECT Tempusername FROM $user_tablename WHERE username = '$username' AND userpassword = password('$userpassword')"; $result = mysql_query($query); /* If no records match both criteria, we should return "False". Otherwise, we fetch and return the "Tempusername" value for that record. */ if(!mysql_num_rows($result)) return 0; else { $query_data = mysql_fetch_row($result); return $query_data[0]; } } I know I'm missing something with the mysql_num_rows function, but my mind is fried from looking at this all night last night and most of today. Any thot's or helpful words would be MOST helpful!

screaming

Conglomeration Naughty

sign

butter

money

Since TCH is a world-wide family, I would suggest splitting it between 2-3 charities both in the US and worldwide. I've said it before and I'll say it again... Rock Sign

FWIW...I had the same type of questions. After searching various FAQ's and getting help from various people in different forums, here's what I ended up doing. (And it works great!) First, I put the following in my form located in my /public_html directory: action="http://www.yoursite.com/cgi-sys/cgiemail/cgi-bin/eval_templ.txt" Next, I put the text file "eval_templ.txt" in my /cgi-bin, and changed the permissions to 644. I'm not sure it's the best way to do it, but it works fine for me! Hope it helps!

I am happy to report that I've finally figured what I've been doing wrong. It took some digging, trial and error, but I now got it. Many thanks to lstover and surfire for the guidance and links. BTW...msa2mys works just fine with some slight modifications. Saves a BUNCH of typing! This makes me happy I'm here with TCH! Rock Sign

I second surefire's recommendation. I liked it so much, I bought the "Pro" version! The logs make for interesting reading!

Ok...I'm officially stumped. Head Bash I've read the MySQL manual and tried to enter the syntax in to the SQL field in phpMyAdmin. However, all I got was an error message. Syntax used: mysqldump databasename < dumpfile.sql Somehow I'm just not getting it! Any and all help appreciated.

I've set up and used sqmail before when I used to work for a local ISP. We loved it. Thanks for bringing it onboard!

Jack: Thanks for the "Into to PHP" thread. It nicely puts the basics into a language everyone can easily understand. It will also nicely augment my growing stack of PHP documentation. Still having a problem trying to move my dumpfile into an actual database. I've got the database created (thanks lstover!). But I'm assuming (I know..I know!) that I can't use the mysqldump from the query field in phpMyAdmin to create the sql statement to dump the tables from the dump file into the blank database. Only select statements are allowed there, correct? I'm sure it's buried in the mysql documentation somewhere, but I'm on the road for my job and I'm limited as to how long I can stay dialed-up without being charged. I seem to remember having a difficult time first learning Oracle, but as time progressed, it started to come easily enough. I'm sure this is the same way...just gotta get over that initial stumbling block! Thanks for all the help so far.

Can't create new db. Is there a FAQ that I can look at to make sure I'm not doing something wrong?

Trying to do something like this now. I've got an Access *.mde beta that I'm trying to migrate to MySQL and then plan to create PHP pages for it. Through some research, I've been able to create a dump file and ftp'd it to my site but have been unable to locate any documentation on how to extract it onto TCH's servers. I tho't about going from *.mde to *.mdb and trying to convert that way. However, I can only get some of the data structure to convert. I realize that I'll lose some of the code in the conversion, but I can work around that. I could do each of the tables by hand, but it would take quite a bit of time. I KNOW there has to be an easier way out there somewhere! But if that's the way it has to be, so be it. (I got the time to do it!) Any suggestions/help from the "guru's" would be appreciated. TIA.

Are you by chance using MS Outlook? I have Outlook v6 on my laptop and v5 on my desktop and have the same problem. I simply use my dial-up ISP on the laptop for outgoing mail. I know it's not what you want (nor do I) but it's a work-around that works.

Suggestions noted and taken. Thanks. Just one more reason (on a long list already) of why I'm happy I switch to TCH!

Web site: www.panhandlerefs.org Description: Website for soccer referees in NW Florida Link to TCH located near top of index page Rank eval please! Steve

Thanks for the quick response. The url (in case others might want this) is http://www.webcalendarcreator.com (kinda ironic!). They want $50 for their basic program. I know that there are some free ones out there and wanted to know if anyone else knows of any good ones.

I'm looking to put a calendar on my website and I'm looking for suggestions on the good, bad, and ugly ones out there. I'd prefer PHP, but I'll take a look at anything. Steve