RE: [Fwd: Studying mysql]

2002-06-12 Thread Neville Lewis
seems to be an apache problem Hav u setup Apache-php properly IF yes, are u able to access other php pages? -Original Message- From: Wil van der Krogt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:43 AM To: mysqllist Subject: [Fwd: Studying mysql] Original

RE: mysql not supporting php.

2002-06-03 Thread Neville Lewis
The follow lines will -list DBs -allow to select one -list tables under the selected DB mysql show databases; mysql use databasenamehere mysql show tables; hope this helped! -Original Message- From: David Grant [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 12:21 PM

MySQL startup error

2002-06-03 Thread Neville Lewis
This is the error message that I get Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could ayone please show me how to sort this out I had MySQL running before this. This has happened all

RE: Alternative to decode() in Oracle

2002-05-31 Thread Neville Lewis
Have a look below: -- If expr1 is TRUE (expr1 0 and expr1 NULL) then IF() returns expr2, else it returns expr3. IF() returns a numeric or string value, depending on the context in which it is used: mysql select IF(12,2,3); - 3 mysql select IF(12,'yes','no'); -

RE: Newbie question : Can't connect to database through a web interface

2002-05-31 Thread Neville Lewis
Type this line of code before your line $db = mysql_pconnect(localhost, testdb, test123) or die(mysql_error()); The error u get will be pretty descriptive. If not revert back to me. nev L. -Original Message- From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]] @ $db =

RE: mysql_num_rows

2002-05-30 Thread Neville Lewis
Its got nothing to do with the hardware :) maybe u are not having any records in the table or there is something amiss in the table or feild or database names across both machines. not a valid mysql result resource is 100% an program-db related error. you can try to port the entire databse

RE: Problem starting server

2002-05-28 Thread Neville Lewis
this is the error message I get Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Why is this ? Here is a copy of the my.cnf file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld]

RE: mysql_pconnect doesn/t work in php

2002-05-28 Thread Neville Lewis
Perhaps you are using php as cgi try using it as a module of apache ** -Original Message- i use mysql_pconnect in php, but after call mysql_pconnect every time,i find that connection increase one.it says in php manual,

Re: INSERTING BLOB Fields in a Table

2002-05-20 Thread Neville Lewis
How would u insert thru the SQL prompt an Image file and once inserted what is the process of accessing it. I have a free server space with mysql db as such I cant create subfolders with access privileges. So if I jus store the path in the DB display the path later, any one can just type that

MySQL --failed to install service

2002-05-20 Thread Neville Lewis
I am trying to start up mysql on win2000 machine using the following mysqld-nt --install I get an error saying failed to install service how do I get round this the docs say to use the folowing: mysqld-max-nt --install this turns out to be not recognized as a command how do I start