[PHP-DB] User Authentication

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 __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimbmedia.com

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 Friday 27

[PHP-DB] mysql_num_rows

', $mesg, $from)) return true; else return false; } __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ -- PHP Database Mailing List (http

Re: [PHP-DB] mysql_num_rows

/ 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 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _ On Mar 3, 2004, at 2:17

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 referencing

[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

? 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://www.php.net

[PHP-DB] tick mark `

], $_POST[side_crunchs], $_POST[balance_bicycles], $_POST[v_ups] '.' '$_POST[leg_rotation]', $_POST[medicine_ball_throw], $_POST[pull_ups], $_POST[push_ups], '$_POST[climbing]' );__ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED

[PHP-DB] DATE_SUB Issues

(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: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net

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 [EMAIL

Re: [PHP-DB] DATE_SUB Issues

= 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] w: www.eclimb.net

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 and i

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.eclimb.net

[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

); 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 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net

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. ? included statement __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net

[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

--with-apxs=/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.eclimb.net

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

-calendar' '--with-expat-dir=/sw' '--enable-mime-magic' '--disable-debug' '--enable-pic' '--enable-sysvsem' '--enable-sysvshm' '--enable-exif' '--with-gettext=/sw' '--with-ncurses' '--with-dom' '--with-apxs=/usr/sbin/apxs' Thanks - CH __ Craig Hoffman - eClimb Media v

[PHP-DB] Image / file uploader

'; echo $query; $msg = span style='color:red' id='message'Could not update record/span; $result = mysql_query($query, $db); } __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED

Re: [PHP-DB] Image / file uploader

='$_SERVER['PHP_SELF']' encType='multipart/form-data' Any more thoughts? 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

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

'); __ 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:32 PM, Micah Stevens wrote: Do this: echo ( form method='post' action='.$_SERVER[PHP_SELF].' encType='multipart/form

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 2004

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

/tr /table /form); __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimbmedia.com _ On Apr 30, 2004, at 8:47 AM, Chris Boget wrote: Thanks Hans. I tried what your

Re: [PHP-DB] Image / file uploader

='user_id' value='12' input type='hidden' name='postback_bio' value='true' input type='submit' value='Submit' id='submit_buttom'/td /tr /table /form /td /tr /table /body /html __ Craig Hoffman - eClimb Media v: (847) 644

Re: [PHP-DB] Image / file uploader

='message'Could not update record/span; $result = mysql_query($query, $db) or ($msg); } ? __ Craig Hoffman iChat: m0untaind0g __ On Apr 30, 2004, at 9:17 AM, Hutchins, Richard wrote: Craig, Where is the code that actually

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 pull

[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

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 the person

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

? 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 some scripts around so

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

Watrous - Original Message - From: Craig Hoffman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 24, 2004 7:12 PM Subject: [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

[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 URL

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 apostrophe

[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 =

[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

Re: [PHP-DB] checkboxes

=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] checkboxes I have a form

Re: [PHP-DB] checkboxes

will be empty and, I think, won't even be sent in the $_POST array. I'm sure somebody will correct me there if my memory has failed me. -Original Message- From: Craig Hoffman [mailto:[EMAIL PROTECTED] Sent: Friday, January 21, 2005 4:32 PM To: php-db@lists.php.net Cc: Richard Hutchins Subject: Re

[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. input type=checkbox name=completed[] value=value1 when I do print_ r() to see what's in the array I get this: Array ( [0] =

[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

[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: ?php

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 get

[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

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 let say you

[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

Re: [PHP-DB] GD Question

, Craig Hoffman wrote: 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

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 the same script (AFAIK

Re: [PHP-DB] GD Question

. Yes I know. Thanks. -Wendell -Original 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

[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 ?php include (db.php); $query = SELECT route_photo FROM routes

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

, 2005, at 9:46 AM, Bastien Koert wrote: Have a look here...I have some sample code on calling images 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

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

); // tell the browser to expect a JPG imagejpeg($thumb, , 100); // send the image to the browser (filename= = output instead of save) exit(); ? However, you cannot use that to show multiple images from 1 script. Jos -Original Message- From: Craig Hoffman [mailto

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

/function_gd.php?route_photo=$thumb' align='center' id='image'); do this: require(include/function_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

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

; } 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.... .

before you call Header(), and if there is any content outside of the ?php ? 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 Folks, I have a script that times out

[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

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 way

[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

[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

[PHP-DB] mysqli_prepare

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) ___ Craig Hoffman