Re: [PHP-DB] Include File Syntax

2001-04-26 Thread Vlad
Hi Format of included files is the same as original .php file.:) When you include .php file it is the same as you copy that file in your main .php file in that place. > This is my first time programming with PHP. I have seen include files in > the beginning of a php block and wonder is there a s

RE: [PHP-DB] How can this be done?

2001-04-26 Thread Beau Lebens
you need to use the addslashes() command which will escape the quote mark for you, so something like $query="insert into trivia (trivia) values ('" . addslashes($line) . "')"; however, you will find that on a machine which is configured with magic_quotes_gpc turned on, you will end up with somet

[PHP-DB] Re: [PHP] How can this be done?

2001-04-26 Thread Jack Dempsey
http://www.php.net/addslashes -jack Subodh Gupta wrote: > > Hi All, > > I created a table using the create command. > > create table trivia > ( > entry_id integer not null auto_increment, > trivia text null > ); > > Now I have a fle tvia.txt, the content of which are as follows:

[PHP-DB] How can this be done?

2001-04-26 Thread Subodh Gupta
Hi All, I created a table using the create command. create table trivia ( entry_id integer not null auto_increment, trivia text null ); Now I have a fle tvia.txt, the content of which are as follows: The average person's left hand does 56% of the typing. The longest one-syllable wo

Re: [PHP-DB] Really embarassing newbie question...

2001-04-26 Thread ~BD~
Doh! Sorry about that - yes, it's MySQL. And I complete blew by mysql_list_tables - I mis-read what I thought it did, then didn't look at it any further... I told you it was embarrasing... Thanks! http://www.bustdustr.net Home of Radio Free Bd > You didn't mention what DBMS you are running...

RE: [PHP-DB] Really embarassing newbie question...

2001-04-26 Thread Tyrone Mills
You didn't mention what DBMS you are running... Assuming it is MySQL, check page 686 in the PHP Manual, you're looking for mysql_list_tables() Enjoy... -Original Message- From: ~BD~ [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 26, 2001 9:33 PM To: [EMAIL PROTECTED] Subject: [PHP-DB]

[PHP-DB] Really embarassing newbie question...

2001-04-26 Thread ~BD~
Sorry to do this to ya... I"ve been involved with PHP for a total of two days now, and I'm kinda stumped. I've been looking in docs for about 4 hours now for this, and I'm sure I'm slipping right by the obvious answer somewhere, but What's the best (recommended) way to determine if a table ex

RE: [PHP-DB] Can't connect to local MySQL server through socket '/tmp/mysql.sock'

2001-04-26 Thread Andreas D. Landmark
At 26.04.2001 20:53, you wrote: > > > I have this error > > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' > > > (111) > >sounds like MySQL is not running on your server.. ensure it's installed >properly and has actually started, i think typing > mysqladmin -p version >

RE: [PHP-DB] Can't connect to local MySQL server through socket '/tmp/mysql.sock'

2001-04-26 Thread Simon R Jones
> > I have this error > > Can't connect to local MySQL server through socket '/tmp/mysql.sock' > > (111) sounds like MySQL is not running on your server.. ensure it's installed properly and has actually started, i think typing mysqladmin -p version at the command line will tell you if it's ru

Re: [PHP-DB] Can't connect to local MySQL server through socket '/tmp/mysql.sock'

2001-04-26 Thread Larry Hotchkiss
Providing additional information such as the OS your useing as well as your mysql version can be a big help as well. franky wrote: > > I have this error > Can't connect to local MySQL server through socket '/tmp/mysql.sock' > (111) > > what appening? > > AND I CANT connect to mysql fo

Re: [PHP-DB] update problems

2001-04-26 Thread Paul Burney
on 4/26/01 11:16 AM, ns ([EMAIL PROTECTED]) wrote: > hi > i got to have data from mysql database to drop down menues in html how do i > do that? > I can´t get any data to my drop down menues... You need to run a query, something like: SELECT DISTINCT from TABLE where SOMETHING and they run a w

[PHP-DB] update problems

2001-04-26 Thread ns
hi i got to have data from mysql database to drop down menues in html how do i do that? I can´t get any data to my drop down menues... thanks to anyone who can do this... ns -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands

Re: [PHP-DB] file and mail

2001-04-26 Thread kancha
That is not the problem. @ and . need not be escaped. It's got to do with the array that stores the file. Just need to dump the array and try to debug. Any idea on how I can dump an array regards, kancha On Thu, 26 Apr 2001 00:30:40 +0530, Subodh Gupta wrote: > Hi Kancha, > > Since you a

Re: [PHP-DB] mail system

2001-04-26 Thread Andreas D. Landmark
At 26.04.2001 16:20, you wrote: >I was wondering if anyone had any ideas on how I can setup a email system , >internal using php and mysql only .. No Imap Server, or POP. Can someone >please guide me in the right direction ,, this is email sysetm would be only >for registered members. I am setting

RE: [PHP-DB] Sending the user their forgotten password via emal??

2001-04-26 Thread SOHH.com Webmaster
What I've done is I set up an INPUT box on the site, where you type in your e-mail address. Upon hitting submit, I query the database looking for the persons e-mail address. If it's there, I send it to them, if not I inform them that they aren't in the database. This is the code I use for http:

[PHP-DB] mail system

2001-04-26 Thread Greg K
I was wondering if anyone had any ideas on how I can setup a email system , internal using php and mysql only .. No Imap Server, or POP. Can someone please guide me in the right direction ,, this is email sysetm would be only for registered members. I am setting up a dating site.. Any help would b

[PHP-DB] Registering Pages on the web

2001-04-26 Thread Hector M Banda
Hi all, I need to register some pages on the web like altavista, yahoo, etc. Is any procedure to do this? I have done some research and I found that is kind of difficult to register under some search engines like yahoo. Besides setting the meta tag information, do I need to submit any other ki

Re: [PHP-DB] Sending the user their forgotten password via emal??

2001-04-26 Thread Johannes Janson
Hi, well for the first question I have to admit that I was not able to figure out what you mean. But I can give you some thoughts on the second question. the actual sending part could be done with a mail-class. e.g. at http://phpclasses.upperdesign.com the more tricky thing is about the password

RE: [PHP-DB] Query problem cont'd..

2001-04-26 Thread Steve Brett
ok. try this. ahven't tested it though ... ?".$months[$x-1]."\n"; } echo ' '; ?> then something like (pref before the dump of months) will be populated when the form refreshes and then isset() will say it has a value and drop inside to create the query. that way you avoid an expe

[PHP-DB] Query problem cont'd..

2001-04-26 Thread Russ Michell
Hi there: I'm stil having problems with this query in that it doesn't bring up any results! Here is the menu that refreshes the page and deposites the var: 'sortedBy' into play: --select one-- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec The SQL qery: if( ($sortedBy == 'Jan') || ($sor

[PHP-DB] Parse error: parser stack overflow in...

2001-04-26 Thread Christoph Hunscher
... perm.inc on line 56 Hi all, this message some ppl get when they try to connect to a mysql database. i use php3 with phplib. the problem is, when i try it over lan and with dialin over isdn, there are no probs with win95, win98, winme and nt4.0 clients. neither with ms-ie nor with netscape.

Re: [PHP-DB] I'm using mysql. How can i resolv this error?.

2001-04-26 Thread B. van Ouwerkerk
At 17:29 27-4-01 +0900, hansol wrote: >This is Sample: > >$conn= mysql_connect("localhost","login","passwd") or die ("ERREUR de >connexion au Serveur"); >$result = mysql($conn, "SELECT id, name, salary FROM employees"); take a look at some of the online tutorials.. www.devshed.com www.phpbeginne

[PHP-DB] I'm using mysql. How can i resolv this error?.

2001-04-26 Thread hansol
This is Sample: $conn= mysql_connect("localhost","login","passwd") or die ("ERREUR de connexion au Serveur"); $result = mysql($conn, "SELECT id, name, salary FROM employees"); But,Error appear. supplied argument is not a valid mysql/Link resource in line xx -- PHP Database Mailing List (h

RE: [PHP-DB] Include File Syntax

2001-04-26 Thread Steve Brett
hi kat, the include files are simply a way for repetitive code (like a connection to a db) to be inserted into your pages. the syntax for the files is the same as any php script and it is added to the page at the point that you include it. the format is include ("page_name.php"); the pages t

RE: [PHP-DB] WML vs PHP and MYSQL

2001-04-26 Thread Steve Brett
do you have XML support installed ? i don't realy know if you need it but you might ... Steve > -Original Message- > From: Kelvin [mailto:[EMAIL PROTECTED]] > Sent: 25 April 2001 18:38 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] WML vs PHP and MYSQL > > > Hi, > >I am trying t

[PHP-DB] Sending the user their forgotten password via emal??

2001-04-26 Thread DC
Hi all I would like to offer my users the chance to have their username and password sent to them via the email address stored. As i see it i have two issues (1) how do i do the verify email thing where the script send a click here to confirm email address on registration application (2) how d

[PHP-DB] Include File Syntax

2001-04-26 Thread James McLaughlin
This is my first time programming with PHP. I have seen include files in the beginning of a php block and wonder is there a specific syntax used in these files and how secure this is vs code in my .php page? Can someone show me a small example of what the include file might look like that would