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

2005-06-10 Thread Chase
lt;[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 answ

[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

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

Re: [PHP-DB] URL Problem

2004-04-21 Thread C Daniel Chase
a nice associative array... 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/) T

Re: [PHP-DB] URL Problem

2004-04-21 Thread C Daniel Chase
lient-Response-Num: 1 You 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 Lis

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

2003-01-12 Thread Chase Urich
ommand returns a result set, 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 Data

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

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

2002-12-04 Thread Chase
com) or username@'%' (which would work for > > that username from any host) > > > > > > hth > > jeff > > > > > > > > "Chase" > > > biz>

[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]> w

[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 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 can access that from the ser

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.came

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

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

2002-12-02 Thread Chase
There is a single quote and semicolon on the line under 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">n

[PHP-DB] Parse Error...

2002-12-02 Thread Chase
, but when I 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 ---> " . ", " ; $to .= "Chase <[EMAIL PROTECTE

[PHP-DB] Help In Colorado??

2002-11-23 Thread Chase
tions 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
FIRST by 'cdate' then by 'vendor' 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
all entries in the database where "cdate" 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! *gr

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

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

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

[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

[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]] > Se

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: Search results

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

[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, J

[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: Some page "; echo mysql_error(); echo ""; exit; } echo "Selecting database 'foo': "; if(@mysql_select_db("foo", $dbconnection)){ echo "OK"; }else{ e

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

2001-12-14 Thread Andrew Chase
> I also prefer to use printf(" 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 each option line

[PHP-DB] RE: WYSIWYG HTML Editor with PHP

2001-12-10 Thread Andrew Chase
It depends on what platform and browser you expect contributors will be using to add content; ActiveX objects are only good for MSIE/Windows, while Java has a somewhat broader reach. WYSIWYG with HTML/DHTML/Javascript is klugey at best, even if it's PHP-based; PHP is great for making admin screen

[PHP-DB] RE: postgres optimization

2001-11-26 Thread Andrew Chase
You'll probably want to familiarize yourself with the VACUUM command and VACUUMDB utility: http://www.postgresql.org/idocs/index.php?sql-vacuum.html http://www.postgresql.org/idocs/index.php?app-vacuumdb.html -Andy > -Original Message- > From: Ric Manalac [mailto:[EMAIL PROTECTED]] > S

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; [EMAI

[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[&qu

[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, r

[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 (Usuall