RE: [PHP-DB] commas

format_number() should do what you want http://us3.php.net/manual/en/function.number-format.php Eddie -Original Message- From: Chris Mach [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 8:43 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] commas Is there a function that will strip

RE: [PHP-DB] commas

sorry, I am a backwards today...number_format() -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 9:01 AM To: Chris Mach; [EMAIL PROTECTED] Subject: RE: [PHP-DB] commas format_number() should do what you want http://us3.php.net/manual/en

RE: [PHP-DB] md5 question!

no. we added to old 'password' question to one of the sites I did for this reason. When the client registered, they picked a question, ssn, mother's maiden name, dog's name, etc and entered an answer. That way if they lost their password, they could go to a 'lost password' area, enter their

RE: [PHP-DB] md5 question!

md5() will always return the same for the same string, how else can you verify that the user entered their password? everytime they log in, you have to encrypt what they typed in $pword=md5($pword); select * from users where uname='$uname' and pword='$pword' and see if it matches the password

RE: [PHP-DB] Page Use

If it is a low traffic site, then the db writes should not be bad at all. You can simply have the user log in then set their username or something in a session variable, then you can use that to keep track of them in the db. Eddie -Original Message- From: Tim Winters [mailto:[EMAIL

RE: [PHP-DB] Session error?

you need to look in your php.ini file to see where it is dumping the session data, then make sure that directory exits... -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:21 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Session error? Ok, Tried

RE: [PHP-DB] Session error?

some of the other errors occurred ( such as the headers already sent) because you probably have white space before your php code. Eddie -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 10:21 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Session

RE: [PHP-DB] Having trouble with this SQL query

I think you are getting an error because you are using User as the table name which I believe is a reserved keyword. If you change the name to users it would probably work fine. -Original Message- From: Christopher McCourt [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 1:28 PM To:

RE: [PHP-DB] Uploading an image then storing it in a MySQL blob field

I think you might find it a better option to upload the image to a folder on the server and save the image path in the db...not the actual image. Eddie -Original Message- From: Stéphane Pinel [mailto:[EMAIL PROTECTED]] Sent: Monday, February 03, 2003 1:03 PM To: 'PHP DB' Subject:

[PHP-DB] repost..odbc

I apologize if you subscribe to the php general list also as this is a re-posting from there.. I know I can connect to another db through an odbc connection in php. Can I use php to create the connection initially? I will be uploading an access db from the users and then moving the data over

[PHP-DB] RE: [PHP] build menu with mysql data

Marc, I did something sort of along these lines with an 'auction' site I worked on. I displayed rows from a db. If the row had bid information in the db (or your case submenu info) then a + sign icon was displayed next to it. IF the plus sign was clicked, the page would reload and the bid or

RE: [PHP-DB] Re: [PHP] build menu with mysql data

; } - br Marc print $html_body_out; Edward Peloke [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Marc, I did something sort of along these lines with an 'auction' site I worked on. I displayed rows from a db. If the row had bid inf

RE: [PHP-DB] Send mail with a file

I was referred to this class and it works great. I had a page that generated a leave form (based on the users info) and e-mailed the form as an attachement to the users supervisor. http://phpmailer.sourceforge.net/ Eddie -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL

[PHP-DB] data move

Ok, I know I have asked this question several times but it is time for me to start coding so I am looking for some goog tutorials somewhere. I need to use php to transfer data from an access file to mysql db. I assume I will just use an odbc connection but I am unsure as to where to start. If

RE: [PHP-DB] data move

Message- From: Adam Voigt [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 8:48 AM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] data move Umm, if it's a one time deal, why not just have access output a CSV (comma seperated version, or something like

[PHP-DB] mysql wildcard

I have an query: select * from offtime where type='$type' then I just pass the type variable to the page. Is there a wildcard in mysql like there is in sqlserver that I can use to grab all the records? such as select * from offtime where type='%' would grab all. Thanks, Eddie -- PHP

RE: [PHP-DB] How to Make a Pop Up Window and show there a mysql table for help input data?

I need to do roughly the same thing so I am interested to see if it is possible. I am writing an air charter app so I want to allow the users to select the airport codes from a popup and it will automatically fill the box. If I find anything I will pass it on. Eddie -Original Message-

[PHP-DB] calendar system

Hello all, I need to create a basic calendar page for my office where people can post their days off. All the data will be stored in the mysql db. Does anyone know of any good code I an use to get me started? I have seen a lot online of calendar systems but I just want something to start with,

RE: [PHP-DB] extracting data

Ok, I am lost now, I am just trying to read the documentation on odbc...here is what I have so far. This seems to work...or at least not give any errors. How do I know get to the result set in the select statement to move this data somewhere else? I just want to get the entire result set so I can

[PHP-DB] extracting data

I posted this to the php general list also so forgive me if you are seeing this twice. Can I use php to extract data from an access db? The php script and access db will be local. I will then upload the file to my server. Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] mysql-windows xp

how do you do this? I guess I could look it up in the help files. I don't need the firewall as it is behind one at home. -Original Message- From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 8:45 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]

RE: [PHP-DB] mysql-windows xp

can't seem to find that line in the install file but I probably don't know what I am looking for IS this the install doc you meant? http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#In stalling Thanks, Eddie -Original Message- From: [EMAIL PROTECTED]

RE: [PHP-DB] mysql-windows xp

Thanks for all the help. I finally got it running by running winmysqladmin Eddie -Original Message- From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 9:29 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql-windows xp

[PHP-DB] setup issues again

I know this isn't db related but...I finally go mysql and apache running on my laptop now I am trying to get php working. I downloaded the php-4.2.3-installer this morning. Ran the install and am now going through the install instructions. I noticed it said to copy these lines into the apache

[PHP-DB] copying data

I asked a question sort of alone these lines the other day so please forgive me if it sounds familiar... If I have a microsoft access file .mdb on my server, can I use a php page to move the data from the file to a mysql db? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] php- odbc- access

Many of the people who will be using my php site, will also be using an app that runs an access db. I would like to create a page on my webpage that allows the users to click a button, and data is moved from their access db on their machines, to my mysql db. Is this possible? I will know where

[PHP-DB] services in php/mysql

I may be able to get my upload problem fixed by the vb app connecting to our db and pumping over the data. Can I set up a php page or service in mysql that once an hour, day, etc runs a clean up script? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] A little advise please

change this part so that $query is capitalized if (mysql_db_query ($DBName, $query, $Link)){ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 11:23 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] A little advise please Hello, I have a

[PHP-DB] mail

I know this is off the topic of dbs but I can't get the mail function to work, I get this error. Does the script need to be in the apache root? Thanks, Eddie Warning: Failed to Receive in c:\program files\apache group\apache\htdocs\aircharter\working\verify_login.php on line 69

[PHP-DB] passing variables

Hello all, I have a login/register screen for my php/mysql db. When the page opens, the user sees the log in screen but I have a button and reloads the same page, hopefully with the register screen. I know I can simply check to see if a variable is set with if ($variable){} . This does not

RE: [PHP-DB] passing variables

] passing variables I think you want: if (isset($variable)){} Ryan -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 8:33 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] passing variables Hello all, I have a login/register screen for my php

RE: [PHP-DB] passing variables

. -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:33 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] passing variables Hello all, I have a login/register screen for my php/mysql db. When the page opens, the user sees the log in screen but I have

[PHP-DB] mileage calculator

I know a lot of sites, such as car dealerships, where you can put in your zip code and then you can search for cars within 50,100, etc miles of your house. How is this done? I have a site that we want to implement a feature like this. What is stored in the db? Can I simply write a function

[PHP-DB] anchors

Ok, I know this isn't really a db specific question so forgive me. In my php/mysql page, I have a button that loops back to the same page only when it opens the page again, I want it to go to a certain spot on the page with certain parameters. For Example auction.php#map takes me to the map

RE: [PHP-DB] anchors

thanks Peter! Thanks I appreciate it! -Original Message- From: Peter Beckman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 2:21 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] anchors Try auction.php?clientid=1#map On Wed, 4 Dec 2002, Edward Peloke

[PHP-DB] autoupload

I am currently creating a php/mysql site for a client. Many of the customers who will be using this site also use a vb/access program to store a lot of the same data. The client asked me last night if we could write an app that would run on the customers machine that would routinely take data

RE: [PHP-DB] date()

When I use this, I get 12/31/69 as my date. -Original Message- From: Aaron Wolski [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 13, 2002 4:04 PM To: 'Edward Peloke'; 'Php-Db' Subject: RE: [PHP-DB] date() $date = date(m:d:y, $myrow[datefield]); Will produce: 11:13:02 http

RE: [PHP-DB] date()

it is just a datetime field and the clients use a javascript calander to pick the date, here is the exact date as it appears in the db. 2002-11-08 00:00:00 Eddie -Original Message- From: Aaron Wolski [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 2:05 PM To: 'Edward Peloke

RE: [PHP-DB] small database

I agree with the others, don't try to store the picture in the db. What I did was provide a place for users to log-in to my site, when they signed up, I created a folder (using their username since that had to be unique). When they uploaded their pictures, I put the pictures in their folder and

[PHP-DB] airport codes db

I am working on a php page where I need some airport codes data, I have seen a few places online where you can buy this data so I was wondering if anyone has used any of these databases and if anyone had a good source for a mysql airport code db. Thanks, Eddie -- PHP Database Mailing List

[PHP-DB] date()

I have a date field in my mysql db, when I output the data to the screen, I don't want to see the minutes, just the mmddyy. I can format a date but can't seem to get it to work passing in the value from $myrow[datefield]any ideas? I don't want to have to worry about just pulling what I want

RE: [PHP-DB] sql select

I don't think you can reference the aliased column timea in the select clause, I know sql server won't let you do it..try and (labor_qty*parts_time+parts_setup)labor_time -Original Message- From: Steve Dodkins [mailto:Steve.Dodkins;ebm-ziehl.co.uk] Sent: Tuesday, November 12, 2002 10:16

[PHP-DB] calling sql script

I need to use a php page to run an .sql script against a mysql db. How do I simply call the script from php? I can take parts of it and execute the statements but I would like to just call the entire script. Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] uploading

I am playing with uploading files. The names will then be stored in the db. I have a simple form: form action=upload.php method=post enctype=multipart/form-data Send these files:br input name=userfile[] type=filebr input type=submit value=Send files /form Which calls a php file that just

RE: [PHP-DB] uploading

Thanks Jeff, I will give that a shot. I am developing on windows but the server that will host the site is linux. Eddie -Original Message- From: [EMAIL PROTECTED] [mailto:Jeffrey_N_Dyke;Keane.com] Sent: Tuesday, November 05, 2002 3:32 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject

[PHP-DB] mail()

I know this is off topic to the db list but.. I am attempting to use the mail function. I have set the smtp in the php.ini file to my smtp server but when I run the script, I get the error Warning: Failed to Connect in c:\program files\apache group\apache\htdocs\lg\nuser2.php on line 50 where

RE: [PHP-DB] mail()

yep and I still get the same error...I modified the ini file in my windows directory..I assume that is the right one. Eddie -Original Message- From: Marco Tabini [mailto:marcot;tabini.ca] Sent: Thursday, October 31, 2002 2:24 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: [PHP

RE: [PHP-DB] mail()

To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] mail() did you restart apache? epeloke@echoma n.com (EdwardTo: [EMAIL PROTECTED] Peloke) cc: Subject: [PHP

[PHP-DB] images

I am attempting to create a page on my website which will allow users to upload images. I will need to rename and resize the image and then grab the location of the image and place it in the mysql db in a varchar field. I have been told there are already some code for this online that can be

[PHP-DB] images

How can I allow the user to upload images to a php website and have the image stored in the mysql db? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] images

thanks Jeff and Richard, I will give that a shot. Jeff, I see you aren't to far from here if you work at Keane, I live in NH. thanks again, Eddie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 2:59 PM To: Edward Peloke Cc: [EMAIL

[PHP-DB] sessions tutorial

Sorry, Michael, I meant to send this to the list, not just to you. I apologize. Hello all, I am a php newbie and am currently developing my first php page. My page will allow several people to log in at the same time sharing access to the mysql db. SO, I need to use sessions. Does anyone

[PHP-DB] space in query

forgive the basic question but how do I add a space in my query $result=mysql_query(SELECT * from .$dbname..grades WHERE user_id=.$uid. and subject=.$subject,$db); I need to force a space between $uid and 'and' and I don't think simply pressing the space bar does it. Thanks, Eddie --

RE: [PHP-DB] space in query

nevermind, stupid me, I got it working... -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 5:04 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] space in query forgive the basic question but how do I add a space in my query $result

[PHP-DB] results of query

What does everyone typically use to display the results of a query. For example, I have a database that has a series of subjects and grades. If I select * from the table, I want a nice way for the data to be displayed. In cold fusion, I can simply use a grid that dynamically fills in. Can I

[PHP-DB] php newbie

Hello all, I am very new to php, in fact, this is my first attempt at a script. I have just been following a tutorial online. Currently, I have a page where the user types in a username and password, I then pass those parameters to this page. This page connects to a main db, looks up their