RE: [PHP-DB] saving details problem (big)

2002-04-04 Thread Beau Lebens
Dave, would it be possible (not ideal, but might work) to do something like this; - user fills out form - user clicks submit - submit fires off 2 events, one submits to AFD server, the other opens a new window, behind the current, submits certain values (the 3 new ones) and saves them into the

[PHP-DB] saving details problem (big)

2002-04-04 Thread Dave Carrera
Hi all I am making use of AFD postcode lookup application. What it dose is ask for your postcode and returns your address. You may have seen this around the web.. Well my problem is that I have added 3 extra fields Name, email, phone number And I need to save this info. I ha

Re: [PHP-DB] Databse Access Problem...

2002-04-04 Thread Marius Ursache
do a file called phpinfo.php see what version of php are you using, then check in manual if your version is old enough for "ocilogon" Pusta a écrit : > A little background information: > > Running PHP on Apache server bundled with Oracle Portal on Redhat Linux 7.1. > Trying to access the Orac

Re: [PHP-DB] Databse Access Problem...

2002-04-04 Thread Wayne Bastow
Pusta, Sounds like Oracle support hasn't been compiled into PHP. Wayne Pusta wrote: >A little background information: > >Running PHP on Apache server bundled with Oracle Portal on Redhat Linux 7.1. >Trying to access the Oracle database from the web using PHP and when I write >the connect state

[PHP-DB] Databse Access Problem...

2002-04-04 Thread Pusta
A little background information: Running PHP on Apache server bundled with Oracle Portal on Redhat Linux 7.1. Trying to access the Oracle database from the web using PHP and when I write the connect statement, I get this error: Fatal error: Call to undefined function: ocilogon() in /home/student

Re: [PHP-DB] Forms and mysql

2002-04-04 Thread Jason Wong
On Friday 05 April 2002 13:42, Jennifer Downey wrote: > If you had read more carefully you'd see that I don't have THE email sent > to me. The replies were never in the archives. Email & posts, many people don't know/don't differentiate/don't care about the difference. Obviously you're not one o

Re: [PHP-DB] Forms and mysql

2002-04-04 Thread Marius Ursache
if you have full access to internet (no proxy or something) try to search on news servers (alt.php or oher php related newsgroups) news server: news2.euro.net or other... Jennifer Downey a écrit : > In any case the email or replies are not in the archives. I have searched > them and came up emp

Re: [PHP-DB] Forms and mysql

2002-04-04 Thread Jennifer Downey
In any case the email or replies are not in the archives. I have searched them and came up empty. "Marius Ursache" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Jennifer Downey a écrit : > > > If you had read more carefully you'd see that I don't have THE

Re: [PHP-DB] Forms and mysql

2002-04-04 Thread Marius Ursache
Jennifer Downey a écrit : > If you had read more carefully you'd see that I don't have THE email sent to > me. The replies were never in the archives. > I guess since I am a woman everyone feels they need to send private email > instead of replying with a post. > maybe... maybe not... on my NS

Re: [PHP-DB] Forms and mysql

2002-04-04 Thread Jennifer Downey
If you had read more carefully you'd see that I don't have THE email sent to me. The replies were never in the archives. I guess since I am a woman everyone feels they need to send private email instead of replying with a post. Jennifer "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMA

Re: [PHP-DB] viewing records

2002-04-04 Thread Jason Wong
On Friday 05 April 2002 03:35, Natividad Castro wrote: > Hi to all, > I created an application that uses authentication. When the user enters the > username and password, if it is valid, he will have access to the first > record, which I'm displaying in a form. My question is: can another user > v

Re: [PHP-DB] Forms and mysql

2002-04-04 Thread Jason Wong
On Friday 05 April 2002 07:55, Jennifer Downey wrote: > Hi all, > > I know I've asked this before and wouldn't be asking again if I had the > email that you people replied back with. Windows took a you know what on me > and I had to format the hard drive. If this has been answered before then sea

[PHP-DB] mail function help

2002-04-04 Thread CrossWalkCentral
For some reason the mail command will not work on all systems mybe I am using it wrong can some one provide some feedback on this. here is a code snip. $msg = "\tFirst Name: $custfname\n \tLast Name: $custlname\n \tEmail Address: $custemail\n \tCategory: $dservice\n \tDescription: $custpdes\

[PHP-DB] Time diference

2002-04-04 Thread Clever
Hi, I need to build a piece of code do calculate the total working time of a employee. I have the tables: # # Table structure for table 'card_ticks' # CREATE TABLE card_ticks ( cod bigint(20) unsigned NOT NULL auto_increment, tick datetime , employee int(10) unsigned NOT NULL DEFAULT '0' ,

[PHP-DB] Forms and mysql

2002-04-04 Thread Jennifer Downey
Hi all, I know I've asked this before and wouldn't be asking again if I had the email that you people replied back with. Windows took a you know what on me and I had to format the hard drive. Anyway here is what I have. This is items.php: "; echo "$return[name]"; echo "Quantity $return[quanti

[PHP-DB] how to question...

2002-04-04 Thread jas
Ok here is what I would like to accomplish, I am sure someone has done something like this but I need an example to go from since I am still not able to write php from scratch... I need to write a function to count the contents of a directory, like the file names and place them into an array so I

Re: [PHP-DB] Editing/Updating Data with Forms

2002-04-04 Thread DL Neil
Josh, Look up JaneBuilder (or something like See Jane Code) in Google. This pkg will generate basic HTML forms from a MySQL (etc) db tbl schema. A bit basic, but possibly enough to get you where you're going... =dn - Original Message - From: "Jonathan Hilgeman" <[EMAIL PROTECTED]> To: "'E

[PHP-DB] viewing records

2002-04-04 Thread Natividad Castro
Hi to all, I created an application that uses authentication. When the user enters the username and password, if it is valid, he will have access to the first record, which I'm displaying in a form. My question is: can another user view the same record at the same time? if the answer is yes, is t

[PHP-DB] Re: [PHP] New to PHP Need Help

2002-04-04 Thread Philip Olson
Firstly, cross-posting like this is a huge no-no, please don't do that again. > When the script runs it displays Array. Printing arrays directly will do that. Logically speaking, how do you expect PHP to know what value to get here? You are SELECTing many. > I am running WIN2K and IIS 5

[PHP-DB] HTTP authentication

2002-04-04 Thread John Hughes
Earlier I posted a question about why the failure message in my HTTP authentication script wasn't working. I figured out the answer. There was no place to go if the user entered a username or password that wasn't in the database. Below is the corrected code. John Hughes \n"); } #END IF ON SQL

RE: [PHP-DB] Editing/Updating Data with Forms

2002-04-04 Thread Jonathan Hilgeman
Just look at your basic PHP tutorials like Devshed's PHP 101: http://www.devshed.com/Server_Side/PHP/PHP101 - Jonathan -Original Message- From: Evans, Josh [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 7:31 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Editing/Updating Data with

RE: [PHP-DB] grouping by category

2002-04-04 Thread Jonathan Hilgeman
Hi Big Al, You're just running full-steam ahead into these mailing lists. :) Anyhow, as olinux pointed out, you can get everything you want in one query, but I would choose a different query (no need to GROUP BY category), and then use a multi-dimensional array to organize the data. Here's my ver

RE: [PHP-DB] Please help count ?

2002-04-04 Thread Rosser, Chris
Dave, Try: $postcode_parts = explode(" ", $postcode); The first part of the postcode will be available in $postcode_parts[0]. - Chris > -Original Message- > From: Dave Carrera [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 04, 2002 5:29 PM > To: [EMAIL PROTECTED] > Subject:

RE: [PHP-DB] Please help count ?

2002-04-04 Thread Rick Emery
$post = ereg_replace("(.*) ","\\1", $old_post); If you want to search mysql for this that is something else -Original Message- From: Dave Carrera [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 10:29 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Please help count ? Hi All I

Re: [PHP-DB] Please help count ?

2002-04-04 Thread Shane Wright
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 you can do this... $myvar = ecplode(' ', $postcode); $firsthalf = $myvar[0]; But not everyone puts the space in there S On Thursday 04 April 2002 5:29 pm, Dave Carrera wrote: > Hi All > > > > I have a variable returned by my application. > >

[PHP-DB] No logro tomar los datos de un formulario

2002-04-04 Thread Sergio Cornejo
Hola. Estoy tratando de generar una respuesta a un formulario pero no logro que el PHP tome los datos que bienen. trabajo con apache para win 1.2, PHP 4, Dreamweaver 4 y MySQL 3.1 he aqui los códigos de los archivos en cuestion: el formulario: - Tu nombre Tu

[PHP-DB] Please help count ?

2002-04-04 Thread Dave Carrera
Hi All I have a variable returned by my application. For clarity it is a post code so result could be EX3 T56 or BG56 G67 or CA2 123 But I only need the first bit of the postcode to continue my search. How do I set my var to only include the first bit of the postcode. It is

RE: [PHP-DB] New to PHP Need Help

2002-04-04 Thread Rick Emery
Jason, If you don't have one, I would also recommend a good book that combines PHP and MYSQL interaction. I would strongly suggest the one I cut my PHP teeth on: PHP Essentials by Julie Meloni -Original Message- From: Julie Meloni [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 20

Re: [PHP-DB] New to PHP Need Help

2002-04-04 Thread Julie Meloni
JT> $Location_Info = mysql_fetch_row($result); JT> echo "$Location_Info"; After you fetch the row, you have to extract the elements from the array that makes up the row. For more than one row in your result, you have to call mysql_fetch_row() again. >From http://www.php.net/manual/en/function

[PHP-DB] RE: [PHP] New to PHP Need Help

2002-04-04 Thread Rick Emery
change: $Location_Info = mysql_fetch_row($result); to: $row = mysql_fetch_array($result); $Location_Info = $row['fieldname']; replace "fieldname" with the real name of your database field -Original Message- From: Jason Tobias [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 9:2

RE: [PHP-DB] How to link a MYSQL table to a dbase file

2002-04-04 Thread Gurhan Ozen
Hi Marij, Cron is a tool in UNIX/LINUX server used to execute commands/programs automatically in a fixed period basis. You can always read unix man pages to learn more , just type man cron and man crontab. You may also want to see this link: http://www.faqts.com/knowledge_base/view.phtml/aid/1

[PHP-DB] New to PHP Need Help

2002-04-04 Thread Jason Tobias
I am trying to define variables through an anchor tag to retrive data from MySQL, When the script runs it displays Array. I am running WIN2K and IIS 5 echo "Camp Street Cafe"; Here is the script that is called. $Location_Info"; ?> -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] How to link a MYSQL table to a dbase file

2002-04-04 Thread Rick Emery
cron is an application/utility on ALL unix servers. It is used to execute ANY unix command or script at specified dates, times, etc. type the following to learn more: man cron man ctrontab your cron job would execute the command to translate the dbase file to sql. Then execute mysql to read in t

Re: [PHP-DB] Editing/Updating Data with Forms

2002-04-04 Thread Bob
Sounds like you're more in need of a consultant than a mailing list.. Bob - Original Message - From: "Evans, Josh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 8:30 AM Subject: [PHP-DB] Editing/Updating Data with Forms > Can anyone help me with editing/upda

RE: [PHP-DB] Editing/Updating Data with Forms

2002-04-04 Thread Rick Emery
Josh, Your question is too vague to answer. Do you know mysql? Do you know PHP or PERL? If not, learn these, then ask. If so, create code, then ask -Original Message- From: Evans, Josh [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 9:31 AM To: [EMAIL PROTECTED] Subject: [PHP-

[PHP-DB] HTTP authentication script failure display

2002-04-04 Thread John Hughes
I have adapted a HTTP authentication script from Leon Atkinson's Core PHP book. I've done something that stopped the failure message from displaying. The password request works and valid users are sent to the correct page. But instead of getting "This directory requires a user name and password"

RE: [PHP-DB] Database Sorting by date

2002-04-04 Thread Rick Emery
Ron, This would indicate that $table was not set. Or that the table indicated in $table does not exist. Print out $query; is it as you expected? Enter the SELECT at the mysql command prompt: what is the result? -Original Message- From: Allen, Ronald L CIV [mailto:[EMAIL PROTECTED]] Sen

[PHP-DB] Editing/Updating Data with Forms

2002-04-04 Thread Evans, Josh
Can anyone help me with editing/updating data in a table with using a form? Josh Evans ACS Helpdesk [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP-DB] Updating Forms Values

2002-04-04 Thread Bzdpltd
Hi there again. I have tried using the urlencode method but for some reason it is still doing the same thing and stripping the rest of the name. I will try to explain more how this works. I have a site where you login using a name and passord. These values are stored using cookies and we have th

FW: [PHP-DB] PHP Certificate

2002-04-04 Thread Evans, Josh
Can anyone help or point me to a good tutorial for using forms to update data in a table? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.p

Re: [PHP-DB] How to link a MYSQL table to a dbase file

2002-04-04 Thread Marij Bellen
I run my site on a linux webserver. I don't really know what a cron is? I can also get a csv file. I also have a function to translate the dbase-file to sql. Is a cron a tool or whatever to automatically load data into the database? == Can you use a cron (Unix) or at

RE: [PHP-DB] How to link a MYSQL table to a dbase file

2002-04-04 Thread Rick Emery
Can you use a cron (Unix) or at (Windows) job to dump the dbase data to a comma-separated-value table? Then suck up the csv into the mysql databasde. -Original Message- From: Marij Bellen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 8:37 AM To: '[EMAIL PROTECTED]' Cc: '[EMA

RE: [PHP-DB] Database Sorting by date

2002-04-04 Thread Rick Emery
Ron, What problem are you having? I'm looking at your code, and it's so clean, I could eat off of it. My only suggestion would be that $month will NEVER == "NULL". If you are testing for NULL, the test is: if ($month == NULL ) Second, $month will be assigned a value, so it will never be NULL e

[PHP-DB] How to link a MYSQL table to a dbase file

2002-04-04 Thread Marij Bellen
How can I extract data for a mysql-table from a dbase file? This is the situation: 1) we have a dbase-file with data 2) the dbase-file is put on the server 3) we have a mysql-table that needs to get his data out of this dbase-file. How can I link this mysql-table to this file! !!note: -

RE: [PHP-DB] Submitting Dynamic Form

2002-04-04 Thread Rick Emery
I use the PHP manual and the on-line resources/tutorials, such as PHP.net I have lots of time to read these things, because...well...I have no life I just kind of stumble on these things. -Original Message- From: Chris MacKenzie [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002

[PHP-DB] PHP Certificate

2002-04-04 Thread Hayan Al Mamoun
Hi, Does anyone knows a way to get PHP certificate?? Best Regards Hayan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Updating Forms Values

2002-04-04 Thread Paul Burney
on 4/4/02 8:35 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] appended the following bits to my mbox: > home.php?name=Barry Zimmerman > > This once you have eddited a page becomes: > > home.php?name=Barry You'll need to url encode the variable: echo 'home.php?name=' , urlencode($username); HTH.

[PHP-DB] Re: Date Question

2002-04-04 Thread Ron Allen
Steve is right you can do it that way, but I would put in the area where you insert the information into the database. Either way is correct. but I find this way easier and you don't take up any area on your from. (preferences) @mysql_select_db("$DBName") or die("Unable to select database $DBName

[PHP-DB] Database Sorting by date

2002-04-04 Thread Ron Allen
Here is the problem I want to be able to view all or search through the currency lists in the database by the month. Any help would be great!!! Here is the code Select a CCSD: SELECT VIEW ALL March 2002 April 2002 May 2002 June 2002 July 2002 August 2002 September 2002 October 2002 November

[PHP-DB] Updating Forms Values

2002-04-04 Thread Bzdpltd
Hi group, Wonder if anyone has a quick solution to this problem I am having. I have an authentication system using cookies. The system lets a user login and then they are shown a list of clients which are allocated to there username. They can then add press releases or edit them from the links