Re: [PHP-DB] Apache, PHP and MySQL

2002-12-09 Thread Alex Francis
DN Sorry, I cant find this Action line. If you mean the DLLs being copied to the Windows\System directory, I have done that. Is there a better tutorial for installing Apache and PHP, and if so should I try to uninstall and start again. I could even reformat if necessary - all my backups on the

Re: [PHP-DB] Apache, PHP and MySQL

2002-12-09 Thread DL Neil
Alex, Sorry, I cant find this Action line. =can't find it where? It's on the page number that I quoted for WT's book (unless there's a new edition out?). If it's not in the conf file then it must be added - review p799 and around - they have a section about setting up Apache in one place, and

[PHP-DB] Fw: Insert strtoupper

2002-12-09 Thread Antonio Bernabei
Hi, I want to insert the upper case of the strings written in the forn, so I put on the php file called these lines $NOME=strtoupper($nome); mysql_query (INSERT INTO anagrafe (codice,nome, cognome, codicefiscale) VALUES

[PHP-DB] Re: Fw: Insert strtoupper

2002-12-09 Thread Bastian Vogt
Hi, in your query strtoupper is treated as a string and not as a function. You have to write this: mysql_query (INSERT INTO anagrafe (codice,nome, cognome, codicefiscale) VALUES ('.strtoupper($codicefiscale).','$NOME','.strtoupper($cognome).','.strtoupper($codicefiscale).', ... Regards, Bastian

[PHP-DB] Form TextArea Formatting

2002-12-09 Thread Keith Spiller
Hello, I've created a web form that includes a textarea input box called MessageText. The data from this form will be inserted into a mysql table. My problem is that the form users will be inserting formatted text into this textarea and I need to be able to transfer the formatting as well as the

Re: [PHP-DB] Form TextArea Formatting

2002-12-09 Thread Ignatius Reilly
What do you mean by formatted text? All you can enter in a textarea is a sequence of characters belonging to your encoding schema (including non-printing characters). Ignatius - Original Message - From: Keith Spiller [EMAIL PROTECTED] To:

RE: [PHP-DB] Re: Check Automaticaly

2002-12-09 Thread dufronte
Thanks a lot pal, that's help me so much. --www.kapsul.org-- DuFronte -Original Message- From: Adam Royle [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:50 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Re: Check Automaticaly I would imagine your

RE: [PHP-DB] Form TextArea Formatting

2002-12-09 Thread John W. Holmes
I've created a web form that includes a textarea input box called MessageText. The data from this form will be inserted into a mysql table. My problem is that the form users will be inserting formatted text into this textarea and I need to be able to transfer the formatting as well as the

Re: [PHP-DB] Apache, PHP and MySQL

2002-12-09 Thread Alex Francis
DN, Thank you, I found the line you were referring to, however I still have a problem. My browser comes back with page cannot be found. I created a small test html file, put it in the same directory and it worked alright. When I first add the action it couldn't find the extension dlls, but this

Re: [PHP-DB] Form TextArea Formatting

2002-12-09 Thread Alex Francis
You would be easier reformatting when you take it out of the database. After getting your variable representing the text in the text box do this: $variable = nl2br($variable); Then when you display your variable the all your original new lines are retrieved. John W. Holmes [EMAIL PROTECTED] wrote

Re: [PHP-DB] Form TextArea Formatting

2002-12-09 Thread Keith Spiller
Mark, Ignatius, John et.al., Thanks guys, I was able to use this: $Message = str_replace( ,nbsp;nbsp;,$MessageText); $MessageText = preg_replace(/(\015\012)|(\015)|(\012)/,nbsp;br /, $Message); It works perfectly, at least on my Windows machine. The data is not only input from the

[PHP-DB] Delay Confirmation....

2002-12-09 Thread dufronte
Hi, I'm still new in PHP..., I have some problem in using sleep() function. Actually, I want to make a script that confirm the user to wait for 10 seconds before proceed to the next step. First the message Please wait for 10 seconds while we're processing your request... will be shown to user,

RE: [PHP-DB] Delay Confirmation....

2002-12-09 Thread Ryan Jameson (USA)
javascript seems to be a more likely candidate for this. The function you'd use is: -Original Message- From: dufronte [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 7:36 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Delay Confirmation Hi, I'm still new in PHP..., I have

RE: [PHP-DB] Delay Confirmation....

2002-12-09 Thread Ryan Jameson (USA)
Anyone know how to disable CTRL-ENTER in outlook? Anyway... the what I was saying: function wait10SecondsAndThenGoToADifferentPage(){ setTimeout(window.location.href = 'pageYouWantThemOnWhenDone.php';,1); } Ryan -Original Message- From: Ryan Jameson (USA) Sent: Monday,

[PHP-DB] Enlarging tables

2002-12-09 Thread mike karthauser
We have been entering data into a mysql table and it has got to id=127 and then stopped us from entering anymore data. When i built the table i must have specified the size wrong. Can anyone recommend how to fix this? regards mikek -- Mike Karthauser Managing Director - Brightstorm Ltd Email

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Aaron Wolski
What's your table structure looks like? Aaron -Original Message- From: mike karthauser [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Enlarging tables We have been entering data into a mysql table and it has got to id=127 and then

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Snijders, Mark
http://www.mysql.com and check 'alter table' with this you can fix it but using phpmyadmin or another program is more handy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Hutchins, Richard
What kind of table? Can you provide your table creation script or the output of mysqldescribe tablename; -Original Message- From: mike karthauser [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Enlarging tables We have

[PHP-DB] load data

2002-12-09 Thread Steven Dowd
when using the 'load data infile' commands how do i force the data thats being loaded to completely be loaded ie LOAD DATA INFILE data.txt INTO TABLE datacontent.misc_code; I have a file eg: data.txt thats 36 lines long, but is full of misc text including some php + mysql code, so its not

Re: [PHP-DB] Enlarging tables

2002-12-09 Thread mike karthauser
on 9/12/02 2:50 pm, Aaron Wolski at [EMAIL PROTECTED] wrote: What's your table structure looks like? ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra |

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Hutchins, Richard
By definition a tinyint has a value from range -127 to 127. Try using a smallint instead. -Original Message- From: mike karthauser [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:56 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Enlarging tables on 9/12/02 2:50 pm,

RE: [PHP-DB] Delay Confirmation....

2002-12-09 Thread dufronte
Thanks for the Javascript... but my real case is in PHP not Javascript... :D I've tried with javascript, it worked, but not with PHP... I've tried what Michael Hazelden said. print(Please wait for 10 seconds while we're processing your request...); flush(); sleep(10); But it didn't work...

RE: [PHP-DB] Enlarging tables

2002-12-09 Thread Hutchins, Richard
Premature clickage... Or you could use a mediumint or int. Just check the mysql manual and select the int type that suits the size of your db best. -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 9:56 AM To: 'mike karthauser';

Re: [PHP-DB] Enlarging tables

2002-12-09 Thread mike karthauser
on 9/12/02 2:58 pm, Hutchins, Richard at [EMAIL PROTECTED] wrote: Premature clickage... Or you could use a mediumint or int. Just check the mysql manual and select the int type that suits the size of your db best. Ta. Thats working now. Thanks from a 3 week old newbie. -- Mike Karthauser

[PHP-DB] passing variables

2002-12-09 Thread Edward Peloke
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

2002-12-09 Thread Edward Peloke
That's just it, for some reason the variable isn't being set. Here is the code: When the page loads, the form loads under if (!$login_clients and !$register_clients){ When I click the minus.gif image, I want the page to reload with the other code but it still loads the form under if

RE: [PHP-DB] passing variables

2002-12-09 Thread Ryan Jameson (USA)
You may need to look in the global array. The more recent versions of PHP default to register_globals off ... which means that form variables do not turn into individual variables, but they are still in their respective arrays $_SERVER,$_GET,$_POST ... depending on the method your using it will

RE: [PHP-DB] passing variables

2002-12-09 Thread Jonathan
One of many possible things. Dependent on the version of PHP you are using, you might have register_globals set to off in your php.ini file, which is preferable. In which case you'll have to use If($_REQUEST['variable']) Or If(isset($_REQUEST['variable'])) Second possible is: I've never

RE: [PHP-DB] passing variables

2002-12-09 Thread Ryan Jameson (USA)
I missed the part where he was using an image. Without a value property, I don't see how it could pass anything at all A note on my recent post, to emulate register_globals do this: if (!empty($_SERVER)) extract($_SERVER); if (!empty($_GET)) { extract($_GET); } else if

Re: [PHP-DB] Delay Confirmation....

2002-12-09 Thread Paul Burney
on 12/9/02 9:35 AM, dufronte at [EMAIL PROTECTED] appended the following bits to my mbox: Actually, I want to make a script that confirm the user to wait for 10 seconds before proceed to the next step. First the message Please wait for 10 seconds while we're processing your request... will be

Re: [PHP-DB] passing variables

2002-12-09 Thread Jason Wong
On Tuesday 10 December 2002 00:03, Edward Peloke wrote: That's just it, for some reason the variable isn't being set. Here is the code: When the page loads, the form loads under if (!$login_clients and !$register_clients){ When I click the minus.gif image, I want the page to reload with

RE: [PHP-DB] passing variables

2002-12-09 Thread Hutchins, Richard
Eddie, whenever I start having problems with variables, I drop this code in: begin code snip... ? // these lines format the output as HTML comments // and call dump_array repeatedly echo \n!-- BEGIN VARIABLE DUMP --\n\n; echo !-- BEGIN GET VARS --\n; echo !--

RE: [PHP-DB] passing variables

2002-12-09 Thread Edward Peloke
Thanks for all the help everyone -Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 11:14 AM To: [EMAIL PROTECTED] Cc: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] passing variables Eddie, whenever I start having problems with variables, I

Re: [PHP-DB] passing variables

2002-12-09 Thread Adam Williams
www.php.net/isset if !isset($var) { echo var is not set to anything; } else { echo var is set to $var; } On Mon, 9 Dec 2002, Edward Peloke wrote: 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

[PHP-DB] Last Record

2002-12-09 Thread Jim
Is there a quick and easy way to find out the record id of the last record in a table? I need to read the last record and let the user know what the date of the last record added is. -- Jim Freedom is worth protecting -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] Last Record

2002-12-09 Thread John W. Holmes
Is there a quick and easy way to find out the record id of the last record in a table? I need to read the last record and let the user know what the date of the last record added is. SELECT date FROM table ORDER BY date DESC LIMIT 1 ---John W. Holmes... PHP Architect - A monthly magazine

RE: [PHP-DB] passing variables

2002-12-09 Thread Mark
--- Ryan Jameson (USA) [EMAIL PROTECTED] wrote: You are absolutely correct. However, the only value that security feature has is in the case that the program really cares which method the variable was received. I never have, and I doubt I ever will. I have had cases where I thought I'd be

[PHP-DB] mssql_next_result and stored procedures

2002-12-09 Thread Gene Dymarskiy
It appears that mssql_next_result does not work with stored procedures. I was able to use the function with PHP side queries. However when a stored proc returns multiple result sets I am able to grab only first set and get the following warning: Warning: mssql_execute: multiple recordsets from

[PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
At last I have Apache and PHP running on my server. My server IP is 192.168.1.1 and I have set ServerName 192.168.1.1 in my httpd.conf file. I can access my test files from the server using either http://localhost or http://192.168.1.1, however if I try the same on my main workstation I can't

RE: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Gene Dymarskiy
make sure both your server and workstation can see each other. try pinging the server: ping 192.168.1.1 -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:39 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] More Apache Installation problems

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Adam Williams
can your main workstation ping 192.168.1.1 On Mon, 9 Dec 2002, Alex Francis wrote: At last I have Apache and PHP running on my server. My server IP is 192.168.1.1 and I have set ServerName 192.168.1.1 in my httpd.conf file. I can access my test files from the server using either

[PHP-DB] How do I... (update one table from one page which displays multipleeditable tables)?

2002-12-09 Thread Michael Knauf/Niles
I have a simple form that displays the values of some fields in a table so the user can edit those values and update the database. (mySql) the form action is $php_self, and it triggers an update query that I haven't written yet, because on the way there, I hit a small snag that I hope you can

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
It seems like a network problem. I can access the network through windows network neighborhood but can't ping it, any suggestions? Gene Dymarskiy [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... make sure both your server and workstation can see each other. try

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Adam Williams
can you ping your router? is it filtering ICMP? can you ping anything? is your cat 5 cable crimped properly and you have link lights on your switch/hub/router and network card? Adam On Mon, 9 Dec 2002, Alex Francis wrote: It seems like a network problem. I can access

RE: [PHP-DB] How do I... (update one table from one page which displays multiple editable tables)?

2002-12-09 Thread SELPH,JASON (HP-Richardson,ex1)
use a hidden variable in each form to tell which action to do. i.e. each separate form embed this. form name=products method=post action=$php_self input type=hidden name=form_number1 value=form1_action ... ... ... input type=submit name=Submit value=Submit then do an if to decide which form was

RE: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Gene Dymarskiy
I'd check IP address of your workstation. make sure both the WS and the server are on the same subnet. Your WS should have 192.168 address, too. good luck -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 2:00 PM To: [EMAIL PROTECTED]

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
Sorry, you have lost me. I have a hub with my cable modem connected and also my workstation and server. I only connect to the internet from my workstation since I need to allow my IP address to be set by my ISP and they will only allow one IP address per connection. That,s as far as I can go with

RE: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Gene Dymarskiy
I am a bit confused. Your WS is connected to cable modem and gets public IP assigned by your ISP. Your WS is also connected to a hub shared with your web server. does it mean you have two network cards, one connected to cable modem, and the other to the hub? -Original Message-

RE: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Adam Williams
No I think he has his WS with a real IP from his ISP and then his web server plugged into the same hub as his WS but with 192.168.1.1. He'll either need to get a 2nd NIC and give it an ip like 192.168.1.2 or get a cable modem router. Or change his WS to linux and add eth0:0 with 192.168.1.2 :)

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Alex Francis
Adam, You are correct. I had two NICs, set up exactly as you describe, but kept getting problems (I would lose my internet connection and have to reboot to get it back. I think I will try againand if that fails, buy a cable modem router. Adam Williams [EMAIL PROTECTED] wrote in message [EMAIL

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Jim Hunter
Alex, Your setup will not work like you think. To do what you want you are going to need 2 hubs unless you are doing some sort of NAT on the server. I have this exact same setup and have set up many like it. If you write me directly I can help you out on this, there are a few questions I have

Re: [PHP-DB] More Apache Installation problems

2002-12-09 Thread Adam Williams
what you need to do is have 1 nic going directly to your cable modem using a cross over cable, and then with the 2nd NIC in your WS plug it into the hub along with the web server box, or ditch the hub and connect the WS to the web server with a cross over cable. Adam On

Re: [PHP-DB] How do I... (update one table from one page which displays multiple editable tables)?

2002-12-09 Thread R'twick Niceorgaw
rewrite your FORM tags to have a name and a onSubmit() handler like: FORM NAME=f1 METHOD=... ACTION= onSubmit()=return formSubmitted(this); Now inside each of your forms, have a hidden field named form_name like input type=hidden name=form_name Now put the following code within the

[PHP-DB] Re: Delay Confirmation....

2002-12-09 Thread Adam Royle
Use: set_time_limit(0); // let script run forever Have a look at output control functions, particularly: ob_start(); ob_flush(); They might help you Adam --- Original Message --- Hi, I'm still new in PHP..., I have some problem in using sleep() function. Actually, I want to make a script

[PHP-DB] Inserting a number into a list moving all other numbers down

2002-12-09 Thread Gavin Amm
Hi, I'd like your opinion as to whether you think this code is reasonable, or if there is a better way to do this... I'd like to insert data in a particular order, so that i would take this eg: num val 1x 2y 3z and insert a as number 2 (from 2 text boxes), so

[PHP-DB] Metastorage generates Entity-Relationship class diagrams in UML

2002-12-09 Thread Manuel Lemos
Hello, As announced last week, Metastorage is an application that generates customizable APIs made of classes that store and retrieve objects stored in persistent storage containers like for instance relational databases. The generated code uses Metabase API and consequently supports PEAR::MDB

[PHP-DB] How do I change ?

2002-12-09 Thread Chris Payne
Hi there everyone, How do I strip from a string? Actually, I need to change it to a legal char so I can send it via the URL. $url4 = str_replace(/, ., $url4); Tried the above but there's something wrong? Any help would be appreciated :-) Chris -- PHP Database Mailing List

Re: [PHP-DB] How do I change ?

2002-12-09 Thread Joshua Stein
How do I strip from a string? Actually, I need to change it to a legal char so I can send it via the URL. $url4 = str_replace(/, ., $url4); $url4 = str_replace(\, ., $url4); -j. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL: FULLTEXT Index

2002-12-09 Thread John Taylor-Johnston
Does anyone know what the maximum is for a FULTEXT Index in MySQL? John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Call an Image from local Harddisk thru PHP file in Remote Host.

2002-12-09 Thread dufronte
Hello again, I have another few question. Actually, it's a little bit ridiculous so don't laugh at me :D I want to make a webgame with php., there.. I want to put an Image Locally in order to Increase the speed. What I'm going to do is put my Image in my Local Harddisk...(I'm using

RE: [PHP-DB] Call an Image from local Harddisk thru PHP file in Remote Host.

2002-12-09 Thread Beau Lebens
This won't work, because the HOST needs to be able to access the files on your machine, which is a gross security risk, and isn't possible in this manner. The only way I can think of that you would be able to do anything useful like that would be to have an HTML page load an image using img

RE: [PHP-DB] Call an Image from local Harddisk thru PHP file in Remote Host.

2002-12-09 Thread dufronte
But somehow... I'm still curious... Please check this link to make clear what I plan to do... http://binusti2002.host.sk/sf/start_map.php Here, I put my Image in my Host.. It does work... but the Image is so big and it slows down the access... so that's why I want to put it locally... By the

RE: [PHP-DB] Call an Image from local Harddisk thru PHP file in Remote Host.

2002-12-09 Thread Beau Lebens
rather than use a dynamically modified image, you could use floating DIVs to represent the cities (i.e. float a 10x10 image in a DIV over the background map). This way, you would only need the person to load the actual map once (which would then cache it locally), and each of the city images once

RE: [PHP-DB] Call an Image from local Harddisk thru PHP file in Remote Host.

2002-12-09 Thread dufronte
I've tried your way... And it works It's more simple than using pure PHP :D Thank you very much !!! I'll inform you when the game is finished... --www.kapsul.org-- DuFronte -Original Message- From: Beau Lebens [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 2:33