[PHP-DB] User Authentication

urn false; return $result; } When I change the "return false" to "return true" in the first script (login) it authenticates, but logs any one in. Not good. Does anyone have any ideas or suggestions? Thanks in advance, Craig _

Re: [PHP-DB] User Authentication

Thanks - I can't believe I missed that. :( Craig __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimbmedia.com _ On Feb 27, 2004, at 8:34 AM, Jason Wong wrote: On Frid

[PHP-DB] mysql_num_rows

u log in. \r\n"; if (mail($username, 'Cyclists Edge login information', $mesg, $from)) return true; else return false; } __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w:

Re: [PHP-DB] mysql_num_rows

argument is not a valid MySQL result resource in /Users/choffman/Sites/www/cyclistsedge/include/ forgot_password_functions.php on line 70 Your new password has been sent to your email address. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1

Re: [PHP-DB] mysql_num_rows

I got it working! Thanks everyone! __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Mar 3, 2004, at 2:46 PM, Micah Stevens wrote: the $db variable isn't referenc

[PHP-DB] Inserting Data in Multiple Tables - MySQL

Is it possible to write one INSERT statement to populate multiple tables? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- PHP Database Mailing List (http

[PHP-DB] Inserting Data in Multiple Tables.. again

is, what is the correct way for handling something like this? Do I need to write three separate queries (INSERT) statements? I am using MySQL 4.0.17 if that helps? Thanks in advance, Craig __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946

[PHP-DB] Sessions, Cookies and other

ies the answer? Any insight on how to do this is appreciated. Thanks Craig ______ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- PHP Database Mailing List (http://w

[PHP-DB] tick mark `

POST[situp_with_twist] '.' $_POST[superman], $_POST[situps], $_POST[russian_twist], $_POST[back_extensions], $_POST[situp_crunchs], $_POST[side_crunchs], $_POST[balance_bicycles], $_POST[v_ups] '.' '$_POST[leg_rotation]', $_POST[medicine_ball_throw], $_POST[pull_up

[PHP-DB] DATE_SUB Issues

SELECT SUM(distance), DATE_FORMAT('time_upload', '%u'), WEEK('time_upload', '7') FROM TRAININGLOG WHERE DATE_SUB(NOW(),INTERVAL 7 DAY ) < =time_upload Thanks, Craig H. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (8

Re: [PHP-DB] DATE_SUB Issues

still no luck - any other suggestions? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Mar 29, 2004, at 8:18 AM, John W. Holmes wrote: From: "Craig Hoffman&quo

Re: [PHP-DB] DATE_SUB Issues

pload LIMIT 1 => Results: (This is wrong) => Weekly Miles: (Week starts on Monday) 5.34 Correct Results should be this: Weekly Miles: 30.5 ______ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED

Re: [PHP-DB] DATE_SUB Issues

WooHoo! I got it working! Basically what I did is I changed this DATE_SUB( NOW(),INTERVAL 7 DAY ) to DATE_SUB( NOW(),INTERVAL 1 DAY ) and it worked. I am not entirely sure why. Anyone know? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866

Re: [PHP-DB] DATE_SUB Issues

Thanks - I'll play with it today. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Mar 30, 2004, at 3:32 AM, Ricardo Lopes wrote: sorry, i press Control+Enter

Re: [PHP-DB] DATE_SUB Issues

sorry about the multiple reply's. I tested the query with a few future dates and it seemed to be worked. Thanks again for your help. Thanks - Craig __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclim

[PHP-DB] Graphing - bar charts

Hi there: I am looking for an open source and simple PHP script that will graph (bar) a few MySQL fields. Does anyone have any recommendations? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net

[PHP-DB] include function

include ("jpgraph/src/jpgraph_bar.php"); Parse error: parse error, unexpected T_INCLUDE in /Users/choffman/Sites/www/cyclistsedge/top_performace.php on line 36 ______ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 194

Re: [PHP-DB] include function

Ok, I figured it out. I am using jpgraph and I need to place the include statement next to the start of PHP. v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Apr 6, 2004, at 10:24 PM, Craig Hoffman wrote: Someone tell me why

[PHP-DB] Double Submission into DB if Hit Refresh

What is the best way to avoid data being resubmitted (entered twice) to DB (mysql) if the user hits refresh after POSTING data via a form? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net

[PHP-DB] compile 4.3.6

=/usr/sbin/apxs What's interesting is I update another machine with PHP 4.3.5 with GD / Fink and it work perfectly. Anyone have any ideas? Thanks - CH __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclim

Re: [PHP-DB] compile 4.3.6

... /sw checking for the location of libpng... /sw but the configure then stops and I get this error: configure: error: libjpeg.(a|so) not found. Ideas? __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net

Re: [PHP-DB] compile 4.3.6

ib-dir=/sw' '--enable-ftp' '--enable-ldap' '--with-curl=/sw' '-enable-calendar' '--with-expat-dir=/sw' '--enable-mime-magic' '--disable-debug' '--enable-pic' '--enable-sysvsem' '--enable-sysvshm' &

[PHP-DB] Image / file uploader

$photo = $_POST["photo_name"]; $query = "UPDATE users SET bio = '$bio', goals = '$goals', fav_race = '$fav_race', fav_train = '$fav_train', photo_name = '$photo_name' WHERE user_id = '$user_id'"; echo $query; $msg = "Could not update record"; $result = mysql_query($query, $db); } __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimbmedia.com _ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Image / file uploader

oughts? CH ______ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimbmedia.com _ On Apr 29, 2004, at 6:49 PM, Daniel Clark wrote: I think you want single quotes around PHP_SELF.

Re: [PHP-DB] Image / file uploader

Sorry to be a pest but I tried that. It giving me the same error. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimbmedia.com _ On Apr 29, 2004, at 7:10 PM, Daniel Clark wrote

Re: [PHP-DB] Image / file uploader

Fellows, thanks for helping. But still no luck. The error is gone, but the image / file is still not showing up in the query. What else I can provide to help trouble shoot this? echo (""); ______ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f:

Re: [PHP-DB] Image / file uploader

... Suggestions? Thanks for everyone's help. CH __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimbmedia.com _ On Apr 30, 2004, at 5:05 AM, Ford, Mike [LSS] wrote: On 30 April

Re: [PHP-DB] Image / file uploader

Hans, Thanks Hans. I tried what your suggested and still no luck. __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimbmedia.com _ On Apr 30, 2004, at 7:57 AM, Hans Lellelid wrote

Re: [PHP-DB] Image / file uploader

race] Favorite Place to Train: $row[fav_train] Upload Photo: "); __ Craig Hoffman - eClimb

Re: [PHP-DB] Image / file uploader

Bio', goals = 'Hello World - Goal', fav_race = 'Hello World - Race', fav_train = 'Hello World - Trainingf', photo_name = '' WHERE user_id = '12' Name: Craig Hoffman Bio:

Re: [PHP-DB] Image / file uploader

]; $query = "UPDATE users SET bio = '$bio', goals = '$goals', fav_race = '$fav_race', fav_train = '$fav_train', photo_name = '$photo_name' WHERE user_id = '$user_id'"; echo $query; $msg = "Could not update record"; $r

Re: [PHP-DB] Image / file uploader

That worked! Han's and everyone else thank you very much. I owe everyone who helped out a beer. ;) Thanks CH __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimbmedia.com ___

[PHP-DB] Query help

Hey Everyone, I can use some help here I have query where one can selects an "style" then a "area" and finally "rating" through a drop menu. When some selects a rating they select a range of ratings. For example: Style: Traditional Area: Yosemite Rating: From: 5.5 To: 5.10c This should

[PHP-DB] NULL and empty space

I have an form where someone can choose to upload a photo. If the person does not upload a photo, an emtpy string is inserted in the DB. How can I have it insert 'NULL' in the DB instead of an empty string when they choose NOT to upload a photo but complete the form anyway? Any help is apprecia

Re: [PHP-DB] Re: NULL and empty space

I've tried that and thanks. Bad news is I still can't get it to work. Its always the simple things that causes problems. Any other suggestions? On Aug 22, 2004, at 10:41 AM, Daniel Schierbeck wrote: Craig Hoffman wrote: I have an form where someone can choose to upload a photo. If t

[PHP-DB] Register Globals = OFF not passing variable

Hey Folks, I can use some help here. I am changing some scripts around so they work with (register) globals off. I am trying to pass variables in a function and it does not seem to be passing. The script work fine with globals turned on. I would really like to have them work with RG turned

Re: [PHP-DB] Register Globals = OFF not passing variable

that u get? wat does the function get or return?? is it a variable scope problem? or what... I dont get the picture.. maybe u should paste the error ur getting.. On Fri, 24 Sep 2004 20:12:46 -0500, Craig Hoffman <[EMAIL PROTECTED]> wrote: Hey Folks, I can use some help here. I am changing som

Re: [PHP-DB] Register Globals = OFF not passing variable

f it doesn't I suspect that some reading on superglobals will resolve your dilemma... http://www.php.net/manual/en/language.variables.predefined.php Daniel Watrous - Original Message - From: "Craig Hoffman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 24, 2004 7:12 PM

[PHP-DB] Names with apostrophe's

Hello, I could use some help here. I have an entry in the MySQL, that use an apostrophe, for example lets call it "O'Reilly". I have added addslashes to my insert statement so MySQL accepts it with out complaining. The problem I am having is I use this information "O'Reilly" in a GET UR

Re: [PHP-DB] Names with apostrophe's

Thanks everyone. urlencode worked like a charm. On Sep 29, 2004, at 3:53 PM, GH wrote: You need to use the urlencode() function On Wed, 29 Sep 2004 13:23:07 -0500, Craig Hoffman <[EMAIL PROTECTED]> wrote: Hello, I could use some help here. I have an entry in the MySQL, that use an apos

[PHP-DB] dropdown list - help

I can use some help here. I have page where a user can make updates to a DB record. The user can then select items from a drop down list. I'm trying to get my drop down list to pull from the MySQL and have the value that is stored in MySQL be the one selected in the option selected tag .

[PHP-DB] Assistance with if..elseif statement

I have this block of code which checks to see if an image has been uploaded from an update form. Everything in the form works, except I can not get the the elseif statements to behave properly. See the comments below for explanation. Any help would be appreciated. $route_photo = $_FILES['ima

Re: SV: [PHP-DB] Assistance with if..elseif statement

Thanks all - CH On Jan 17, 2005, at 8:35 AM, Henrik Hornemann wrote: Hi, } elseif ($_POST['route_photo'] = $_POST['oldimage']) Should probably be } elseif ($_POST['route_photo'] == $_POST['oldimage']) Regards Henrik Hornemann -----Oprindelig meddelels

[PHP-DB] checkboxes

I have a form that display's a checkbox if the value is NULL. The form is in a do... while loop, so the user may check multiple checkboxes. I am trying to pass the variable of each checkboxes to an update statement in MySQL. THe problem is I am only getting one of the checkboxes, even if all of

Re: [PHP-DB] checkboxes

usly: name="completed[]" Then you can access the array on your update page and do whatever you wish with it. Hope this helps. Rich -Original Message- From: Craig Hoffman [mailto:[EMAIL PROTECTED] Sent: Friday, January 21, 2005 4:03 PM To: php-db@lists.php.net Subject: [PHP-DB] chec

Re: [PHP-DB] checkboxes

will be (pseudocode again): completed(value1,value2) And from there, you just access the array contents as you would with any other multidimensional array. If you don't check anything on the page, then the array will be empty and, I think, won't even be sent in the $_POST array. I&#x

[PHP-DB] brackets []

Quick question... I am hoping some could explain this to me. I have an array like this: $completed = array($value1, $value2, $value3); where the values are sent via a form. when I do print_ r() to see what's in the array I get this: Array ( [0] => [1] => [2] => ) An empty array. But when I do th

[PHP-DB] if statement

Hi There, I am trying to write an if statement to see if an array has any values in it and if it does do something. for example: $ticklist2 = array("'$values") if (array_values(empty($ticklist2))){ do something } else { do something else } I just can't get this to work. Any help would be gre

[PHP-DB] Pear help

Hi There, I'm trying to configure my OS X box to work with PEAR. Everything seems to be working (updating PEAR libraries, etc.) except when I run my test script I get the following error: Fatal error: Cannot redeclare class db in /usr/lib/php/DB.php on line 271 Here is my test script: I've i

Re: [PHP-DB] Pear help

Thanks for getting back to me... Comments below - On Feb 28, 2005, at 10:49 AM, Martin Norland wrote: Craig Hoffman wrote: Hi There, I'm trying to configure my OS X box to work with PEAR. Everything seems to be working (updating PEAR libraries, etc.) except when I run my test script I ge

[PHP-DB] Grouping Data Together

Hello, I could use some assistance here. I'll try and explain this the best I can. I'm trying to get this query to work where it pulls up all the rows that are associated with a common id . For example let say you have data that you want to group together. For example: Group 1 would look l

Re: [PHP-DB] Grouping Data Together

Found the problem - Craig On Mar 10, 2005, at 5:47 PM, Craig Hoffman wrote: Hello, I could use some assistance here. I'll try and explain this the best I can. I'm trying to get this query to work where it pulls up all the rows that are associated with a common id . For example l

[PHP-DB] GD Question

Hello Everyone, I wrote a GD function that resizes some images and displays them as thumbnails. When I put the function in the index.php page I receive an error Warning: Headers have already been sent... then it shows a bunch of binary. I do not want re-save the file, I just want resize and sho

Re: [PHP-DB] GD Question

as your header() line below? If so, that means you're outputting something back to the browser prior to that line. I'd make sure you don't have any white space before your initial opening -philip On Tue, 5 Apr 2005, Craig Hoffman wrote: Hello Everyone, I wrote a GD functio

Re: [PHP-DB] GD Question

Thanks - it works perfectly! On Apr 5, 2005, at 1:33 PM, Simon Rees wrote: On Tuesday 05 April 2005 19:19, Craig Hoffman wrote: The script works fine when I test it on a stand alone page. I'm just not sure how to include with the "rest" of the site. You can't do it all from th

Re: [PHP-DB] GD Question

Message- From: Craig Hoffman [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 05, 2005 11:04 AM To: php-db@lists.php.net Subject: [PHP-DB] GD Question Hello Everyone, I wrote a GD function that resizes some images and displays them as thumbnails. When I put the function in the index.php page I

[PHP-DB] One more GD ? -- filename

Thanks everyone for answering my other post. However, I'm still having trouble passing the image name from the GD script to the image tag. I'm including the GD script below. Any help would be great. Thanks - Craig //GD script include ("db.php"); $query = "SELECT route_photo FROM routes WHE

Re: [PHP-DB] One more GD ? -- filename

from a db. It used the two pages like you do here and passes the ID back and forth to the image production page...maybe it will help http://www.weberdev.com/get_example-4062.html bastien From: Craig Hoffman <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] One more GD ? -- fi

Re: [PHP-DB] One more GD ? -- filename

show multiple images from 1 script. Jos -Original Message- From: Craig Hoffman [mailto:[EMAIL PROTECTED] Sent: 06 April 2005 15:24 To: php-db@lists.php.net Subject: [PHP-DB] One more GD ? -- filename Thanks everyone for answering my other post. However, I'm still having trouble passing

Re: [PHP-DB] One more GD ? -- filename

ction_gd.php?route_photo=$thumb"); Jos -Original Message- From: Craig Hoffman [mailto:[EMAIL PROTECTED] Sent: 06 April 2005 18:12 To: php-db@lists.php.net Cc: Juffermans, Jos Subject: Re: [PHP-DB] One more GD ? -- filename Hi Jos, I understand what your saying. The problem is all the image

[PHP-DB] Headers sent error msg on one server but not the other...

exit; } Best, CH __ Craig Hoffman ICQ / iChat: m0untaind0g __ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Headers sent error msg on one server but not the other.... .

ny files before you call Header(), and if there is any content outside of the "" tags in the includ()'ed or require()'d files (eg. a carraige return at the end, or a space after the "?>". Check for that and that should fix your problem. Craig Hoffman wrote: Hey

[PHP-DB] Session handler - Info wanted

Hi There, I'm going to write my own session handler for an upcoming project. I would like to store the session data in MySQL. I've never written one before; so if anyone has any tips, suggestions, in-sight, etc... please share. Thanks, Craig _______ Cra

[PHP-DB] Classes and Includes

Hi There, Question: How do I include a file or another class, such as a database connection (table, username, password, etc...) into a class? I don't want to to change the username and password on every class(file) that I upload to the server? I'm just picking up this OO stuff, I'm sor

Re: [PHP-DB] Manipulate an image automatically

I've used GD several times, it works well and its easy to use. http://us2.php.net/manual/en/function.gd-info.php Craig Hoffman IM: m0untaind0g On Apr 13, 2006, at 9:52 AM, Henry Ortega wrote: What is the quickest w

[PHP-DB] Restaurant menu

Hey there, I'm working on a menu system for a catering company. I'm having a difficult time sorting and grouping items together. For example, there may be three or four appetizers that should be group together. But I only want to display the category (appetizers) once and then the corre

[PHP-DB] Inheritance question

Hi there, I could use some help in understanding inheritance and accessing certain properties in objects. For example (see below), lets say I would like to use "public $one" property in a new class / method (such as class b)? What is the best way to accomplish this? Any help and or sugges

[PHP-DB] mysqli_prepare

s, CH Craig Hoffman IM / iChat: m0untaind0g -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Universal Update / Delete Script

and / or deletes records in MySQL, what would be the best approach in having an 2 universal scripts that updates and another one that just deletes? Does this make sense? Here's a breakdown: Events - Update / Delete (events table) News - Update / Delete (news table) ______