[PHP] PHP 4.0.6 Mysql 4.0

2001-10-18 Thread Jeroen Geusebroek
Hi there, Does the current stable PHP (4.06) support the use of the newly released Mysql 4? Thanks, Jeroen -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e

[PHP] PHP and MySQL

2001-09-07 Thread Pieter Philippaerts
Hello, we're using our MySQL database quite extensively from our PHP scripts, but sometimes everything stops working and it says Too many connections. Is there a problem with MySQL support from within PHP? Doesn't it close its connections with the database when the script stops executing

[PHP] PHP and Mysql

2001-09-05 Thread aloysius
my mysql database just won't work .. i think i have configured it correctly cause i can see a page but the codes are messed up .. i can confirm that the servers supports php . both php and php3 extension because i've tried uploading simple codes and it appears correctly ... can anyone help ?

[PHP] PHP and MySQL auth?

2001-08-28 Thread Alex Sofronie
Hello, all. What is the difference between: Case 1: I auth with header('WWW-Auth...') and validate the user from a plain file. Next, i do something like mysql_connect($the_db_host,$the_db_username,$the_db_pass); mysql_select_db($the_db_name); mysql_query(select * from table);

Re: [PHP] PHP and MySQL auth?

2001-08-28 Thread B. van Ouwerkerk
Case 2. Without any form of auth, I read the text file and do mysql_connect($the_db_host,$the_db_username,$the_db_pass); mysql_select_db($the_db_name); mysql_query(select * from table); and the server response is: Error 2002: Can't connect to local MySQL server through socket

[PHP] PHP 2 MySQL over the network

2001-08-24 Thread Boaz Yahav
/ MySQL / PHP side? Issues like packet sizes, connect vs. pconect etc... Sincerely berber -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] PHP and MySQL Insert ID

2001-08-01 Thread John Monfort
Hello everyone ! Question: I'm building an online membership registration system, for a 'membership section' of a website. As it stands, I have a registration form that insert the data into MySQL, then generate a confirmation page--with member ID number, username, and password. I

Re: [PHP] PHP and MySQL Insert ID

2001-08-01 Thread Daniel Rezny
Hello John, Wednesday, August 01, 2001, 11:06:06 AM, you wrote: JM In an environment where it's possible to have multiple JM users register at the same time (relatively speaking), how can I be sure JM that the 'last ID' is indeed the 'intended' last user's ID? JM Ex. JMSay that

Re: [PHP] PHP and MySQL Insert ID

2001-08-01 Thread John Monfort
Many thanks, Daniel! I trully appreciate it. -john __John Monfort_ _+---+_ P E P I E D E S I G N S www.pepiedesigns.com The world is waiting, are you ready? -+___+- On Wed, 1 Aug 2001,

[PHP] php w/ mysql support compiled in -- can't connect to mysql

2001-07-14 Thread Kurt Lieber
() shows me the configure command which includes: '--with-mysql=shared,/usr' So, I'm assuming that I really have mysql support compiled in. mysql lives in /usr/bin/mysql (and is also the debian potato package) I'm used to windows -- this is the first time I've tried to set up php/mysql on linux

[PHP] PHP installed - MySql Server can't connect

2001-07-12 Thread Gaylen Fraley
PHP install went perfectly. phpinfo shows MySql installed. But, when I try to start Mysql, I get: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) What and why? Please reply to my e-mail address if you can help. Thanks! -- Gaylen [EMAIL

Re: [PHP] PHP installed - MySql Server can't connect

2001-07-12 Thread Rasmus Lerdorf
This happens when the mysql server you are running is different from the version of the mysql library php was linked against. If you compiled php using --with-mysql you get the mysql client library that comes bundled with PHP which may not match your mysql server and thus may look

RE: [PHP] PHP installed - MySql Server can't connect

2001-07-12 Thread Matthew Loff
Maybe his mysql.sock file isn't in /var/lib/mysql/mysql.sock? Mine is /tmp/mysql.sock -Original Message- From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 1:31 AM To: Gaylen Fraley Cc: [EMAIL PROTECTED] Subject: Re: [PHP] PHP installed - MySql Server can't

[PHP] php, apache, mysql

2001-05-21 Thread Gregory Hernandez
hello everyone. ok, here's a question. i'm running MacOS X. i had previously installed php and apache with no problem. this past weekend, i installed the unofficial latest version of mysql, MySQL 3.23.38, the version packaged for of course MacOS X. I noticed that mysql was installed on a

[PHP] PHP and MySQL insert problem

2001-03-25 Thread Pinwang Chao
/usr/local/apache/htdocs/tt.php on line 9 But even with this message, the values are still inserted into tt. When I change $sql to sql="select * from tt"; There were no such error message. It puzzled me? Why? My system: PHP 4.0.4pl1, MySQL 3.23.32 Thanks in advance. -- PHP Genera

Re: [PHP] php or Mysql for DATE?

2001-03-15 Thread Tiki
You can also use the curdate() function in the MYSQL syntax. e.g. insert into table (datefield) values (curdate()); Cheers Kee Yong -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the

[PHP] php or Mysql for DATE?

2001-03-14 Thread Dhaval Desai
I want to have a posting column wherein people can post their messages and when a new message is posted the Curent date has to be added in the mysql database. Do u think I should use Php to generate the date or should I have mysql to generate the date. I am also going to allow people to search

RE: [PHP] php or Mysql for DATE?

2001-03-14 Thread David Smith
Try using ? $date = date ("Y-m-d H:i:s"); ? which formats the same as MySQL... -Original Message- From: Dhaval Desai [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 15, 2001 2:19 AM To: [EMAIL PROTECTED] Subject: [PHP] php or Mysql for DATE? I want to have a posting colu

Re: [PHP] php or Mysql for DATE?

2001-03-14 Thread David Robley
On Thu, 15 Mar 2001 17:49, Dhaval Desai wrote: I want to have a posting column wherein people can post their messages and when a new message is posted the Curent date has to be added in the mysql database. Do u think I should use Php to generate the date or should I have mysql to generate

Re: [PHP] PHP and MySQL ....dynamic query?

2001-03-09 Thread Richard Lynch
You can see my problem here. I want to be able to write parts of my sql statement based upon user input, and then execute it all at once. How do I tie all of my $qual variables in so that this will read/execute it properly? $where = ' where 1=1 '; if ($dig == '1'){ $where .= " and track =

[PHP] PHP and MySQL query

2001-03-09 Thread Jim Ray
I have a simpe query that I can not seem to get to work. Here is the HTML side: td width="27%" align="center"form action="luquery.php?DB=csjoaamp;TA=associatesamp;SortField=company" method="post"input type="text" name="search"brinput type="submit"/form/td Here is the PHP side: The fields are

Re: [PHP] PHP and MySQL query

2001-03-09 Thread Yasuo Ohgaki
m Ray" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 10, 2001 1:11 PM Subject: [PHP] PHP and MySQL query I have a simpe query that I can not seem to get to work. Here is the HTML side: td width="27%" align="center"form action="luquery.php?DB=

[PHP] PHP and MySQL ....dynamic query?

2001-03-05 Thread Blueriver Networking Services
Hello everyone. :) I am attempting to construct a query with PHP and MySQL based on user input from a referring form page. Here is an example of what I need this to do: This will involve multiple variables, but I will just use 2 here: if ($dig== "1") { $qual1 = "W

[PHP] Php, Apache, mysql - make error

2001-03-04 Thread S Jha
HI Gurus, I am getting this error. I saw few posting for this error and found someone suggesting "-lz" option in Makefile in LIBS option. However, I didn't found this line in apache Makefile. Also I tried other methods including reloading zlib, reconf mysql ..but in vain. Please help. I did -

[PHP] PHP with MySQL doubt

2001-03-02 Thread Pablo Pasqualino
with my Apache/php? I generally compile my PHP with the --with-mysql=/path/to/mysql But now I am using normally the preinstalled PHP on the server without any problem... Should I recompile my php and tell to the ./configure script the path where my own MySQL is? or it isn't necesary? Thanks

Re: [PHP] PHP Parse MySQL Field???

2001-01-20 Thread Richard Lynch
I have a BLOB field in a MySQL database that I want to parse into my page using PHP. For instance, in this field might be the following: ? echo "test"; ? So when I access this field in PHP I want it to display "test". Is this possible? Yeah. That's called "eval" (short for 'evaluate')

<    1   2   3