RE: [Fwd: Studying mysql]

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 Mes

MySQL startup error

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: mysql not supporting php.

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

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

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 = mysql_

RE: Alternative to decode() in Oracle

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(1>2,2,3); -> 3 mysql> select IF(1<2,'yes','no');

RE: mysql_num_rows

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 f

RE: mysql_pconnect doesn/t work in php

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, mysql_pco

RE: Problem starting server

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] err-

MySQL --"failed to install service"

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 sta

Re: INSERTING BLOB Fields in a Table

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 tha