[PHP-DB] Issue with date() function...

2005-06-10 Thread Chase
I have a variable: $rec2day = date(Y-m-d); that displays correctly when echoed to the screen, but when I write it to my DB, I get the mathmatical answer to the equasion (1989 (2005-06-10)). What do I need to do to correct this?? TIA -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Issue with date() function...

2005-06-10 Thread Chase
.); ? Bruno Ferreira [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Chase wrote: I have a variable: $rec2day = date(Y-m-d); that displays correctly when echoed to the screen, but when I write it to my DB, I get the mathmatical answer to the equasion (1989 (2005-06-10)). What

[PHP-DB] User Auth and More...

2005-06-07 Thread Chase
Good Day! I am trying to create a page that will start off asking for a username and password, verify the entry against a MySQL database, and depending on what the access level is in the table, so one of five or six files on a page for downloading. I have the login script working for

Re: [PHP-DB] URL Problem

2004-04-21 Thread C Daniel Chase
will have to extract the Redirect part... -Dan -- C. Daniel Chase[EMAIL PROTECTED] Web Development Specialist(423) 425-4009 The University of Tennessee at Chattanooga http://www.utc.edu/ -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] URL Problem

2004-04-21 Thread C Daniel Chase
... Enjoy! -Dan -- C. Daniel Chase[EMAIL PROTECTED] Web Development Specialist(423) 425-4009 The University of Tennessee at Chattanooga http://www.utc.edu/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Code problem - need help.

2003-01-12 Thread Chase Urich
, not the 'value' of the query. Look up the mysql_fetch_array [http://us2.php.net/manual/en/function.mysql-fetch-array.php] and mysql_fetch_row commands. There are also several variants of these that return slightly different formats. Chase -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Re: PHP/MySQL not available remotely...

2002-12-04 Thread Chase
Okay, it was suggested that I may not have my register_globals flagged to on but I do. I still can't seem to make any remote connect to the server. Again, there are no errors, it just flat don't work. Chase Chase [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL P

Re: [PHP-DB] Re: PHP/MySQL not available remotely...

2002-12-04 Thread Chase
The phpinfo() call works great on the server itself, but I cannot get the information to display to anyone that connects to the server. Jason Wong [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Thursday 05 December 2002 00:44, Chase wrote: Yes I a

[PHP-DB] PHP/MySQL not available remotely...

2002-12-03 Thread Chase
I seem to have a bit of an issue with my PHP/MySQL settings... A basic PHP bit like ?php echo $REMOTE_ADDR; ? works great on my webserver. However, with any form of DB access the page just hangs... I don't get an error, but I don't get results either. I also have phpMyAdmin-2.3.3 running. I

[PHP-DB] Parse Error...

2002-12-02 Thread Chase
include it in the larger script for sending a mail message, I get this error. I am sure that it is something simple that I have been too stupid to catch, but any help would be great! Chase Code Follows --- ? $server = ; $user = ; $pass = ; $db = ; $table = ; ? ? $to = CKnott [EMAIL PROTECTED

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

2002-12-02 Thread Chase
There is a single quote and semicolon on the line under /html that I thought would be defining the end of the assignment. Should I have used double quotes instead of single? Chase Micah Stevens [EMAIL PROTECTED] wrote in message 1038870535.23725.123.camel@tyrell">news:1038870535.2

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

2002-12-02 Thread Chase
Okay, you just jumped WAY outside my basic knowledge... However, it does make perfect sense, so I am off to the library... Chase Jim Hunter [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... In that case, your logic is not going to work. You have live

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

2002-12-02 Thread Chase
Thank you!! This appears to have solved it... I didn't even think of using the $message variable instead of the print()... Sheesh... I still have LOTS to learn!! Chase Micah Stevens [EMAIL PROTECTED] wrote in message 1038878012.23696.129.camel@tyrell">news:1038878012.23696.129.came

[PHP-DB] Help In Colorado??

2002-11-23 Thread Chase
in such a way to get a useable answer. Please reply privately... Chase [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Variable won't be passed from HTTP address bar

2002-10-18 Thread Chase Urich
Check your register_globals setting in your php.ini file. This used to default to 'yes', but now defaults to 'no'. On Fri, 2002-10-18 at 06:26, Michel Bakkenes - bakkenes.net wrote: Ok.. I'm not a newbie I thought.. I do have experience with PHP, but I never suffered from this error. I

[PHP-DB] Multiple Sorts??

2002-09-10 Thread Chase
' Is this possible? Thanks! Chase -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SELECTing a date range from a table

2002-08-04 Thread Chase Knott
is either between a certain range, or is greater than or equal to a specified date. Any help would be great!!! Jason Wong wrote: On Sunday 04 August 2002 11:33, Chase Knott wrote: I am a newbie. There, I said it! *gryn* Maybe someone here can help me out... I am trying to figure out how

[PHP-DB] SELECTing a date range from a table

2002-08-03 Thread Chase Knott
!! Chase -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Excel to MySQL??

2002-06-29 Thread Chase
Does anyone know of a way that I can export an Excel spreadsheet to a file that I can import to MySQL? I found a program that will do this for Access, but I would rather leave Access out of this if possible. Thanks!! Chase -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Excel to MySQL??

2002-06-29 Thread Chase
My webhost is running phpMyAdmin v2.2.2 and it is giving me errors when I try to load the file. Are there any certain characters that cannot be in the file? (ie. $) Chase Peter Lovatt wrote: Hi from Excel export to csv use phpMyAdmin to load it into mysql (recent versions

[PHP-DB] RE: Images on MySQL

2002-03-29 Thread Andrew Chase
The kneejerk response always seems to be #2, store images in the filesystem and store their paths in the database. I like to compromise: store the original image in a dedicated image data table in the database (keep a separate table for image meta data (date/title/category/whatever) for faster

[PHP-DB] RE: Creating a good search engine

2002-03-25 Thread Andrew Chase
You might want to check out this article on Webmonkey: http://hotwired.lycos.com/webmonkey/97/16/index2a.html?tw=programming The article uses Perl, but the concepts are easy enough to translate to PHP. :) -Andy -Original Message- From: Mike de Libero [mailto:[EMAIL PROTECTED]]

[PHP-DB] RE: Search results

2002-02-06 Thread Andrew Chase
You can use mysql_result_rows() to check whether any rows were returned; something like: ? if(mysql_result_rows($result) 0){ while ($row = mysql_fetch_array($result)) { //Do stuff with result rows here } }else{ echo Sorry your search returned Zero

RE: [PHP-DB] RE: Search results

2002-02-06 Thread Andrew Chase
Yes, sorry about that. :P I need to eat lunch now. -Andy -Original Message- From: Chris Boget Subject: Re: [PHP-DB] RE: Search results you mean: mysql_num_rows(); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: Creating a pdf document

2002-01-24 Thread Andrew Chase
http://www.php.net/pdf You'll need Thomas Mertz' PDFlib, which is free for personal/not-for-profit use, but requires a license fee for commercial use: http://www.pdflib.com/pdflib/index.html -Andy -Original Message- From: Mihail Bota [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

[PHP-DB] RE: display text in screen

2002-01-11 Thread Andrew Chase
Just add echo statments at whatever steps you want to display comment or detail for; something like: html headtitleSome page/title/head body ? echo Connecting to database: ; $dbconnection = @mysql_connect(localhost,username,password); if($dbconnection !== false){ echo OK; }else{

RE: [PHP-DB] Re: Dynamically populating a dropdown box

2001-12-14 Thread Andrew Chase
I also prefer to use printf(option value=\%s\ so it has the value in quotes - just a fussy html thing i do though. If you like your code to be legible in a browser's 'View Source' function (which can sometimes be helpful for debugging), you can also add a newline \n character to the end of

RE: [PHP-DB] php + MYSQL based banner exchange system

2001-09-19 Thread Andrew Chase
There's also PhpAdsNew, which picks up where PhpAds left off at its last release in May of 2000: http://sourceforge.net/projects/phpadsnew/ -Andy -Original Message- From: Boaz Yahav [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 1:42 PM To: Andrius Jakutis; [EMAIL

[PHP-DB] RE: Could get all data from MYSQL using Mysql_fetch_array!!

2001-08-30 Thread Andrew Chase
-Original Message- From: Andrew Chase [mailto:[EMAIL PROTECTED]] Or you could do it longhand - while ($row= mysql_fetch_array($result,MYSQL_ASSOC)) { print ({$row[Reason]}); print ({$row[OtherField1]}); print ({$row[OtherField2]}); } Whoa! Correction

[PHP-DB] RE: Could get all data from MYSQL using Mysql_fetch_array!!

2001-08-29 Thread Andrew Chase
You did fetch all the data by using '*' in your query, but you can't use '*' as a wildcard when referring to an associative array (which is what $row is) - you need to step through each key in the array: while ($row= mysql_fetch_array($result,MYSQL_ASSOC)) { $fields = array_keys($row);

[PHP-DB] RE: Probably a stupid home server question ........

2001-07-19 Thread Andrew Chase
Make sure ahead of time whether the cable ISP gives you a static IP address or a dynamic one... Most of them in the US only give you dynamic IP's. They don't change all that often, but it does make it tough to host a domain name if your IP address is liable to change at any given moment. Also,

[PHP-DB] RE: PHP Mysql apache economy hosting

2001-07-13 Thread Andrew Chase
I used Cedant.com to host my own site for a few months, and they were excellent - no down time that I was aware of, and a handy web-based control panel (and of course SSH shell access for anything not covered by the control panel.) Although they didn't have a large tech support phone bank