upgrade hiccups
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I upgraded MySQL as a part of the latest RedHat up2date and now I get an error when I try to connect to the database. Any help appreciated. [root@jeff root]# mysqlshow mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root@powell /]# cat /etc/my.cnf [mysqld] skip-innodb datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid - -- Jeff Powell [EMAIL PROTECTED] http://www.yonezawa-english-school.com http://www.yonezawa-english-school.com/powell -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+K/eybJk3zHBW5lARAsFPAJ9xy7dNWHcSpki2fr7MWNMJ7JQtEACfbPwG KYReteQZJNlZc1XwbHAn9Yo= =u93H -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need the PHP gurus for this one...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Here's the syntax I use.
$db=mysql_connect( "$host", "$db_user","$db_password")
or die ("".mysql_error()."");
mysql_select_db("$db_name", $db);
$rs = mysql_query($qu, $db)
or die ("".mysql_error()."");
- ---Original Message---
From:Lane Johnston
Sent: Wednesday 22 January 2003 01:31 pm
> Ok php gurus,
> Little info on system: XP, localhost, port 3306
> i am tring to connect to a db in mysql and i looks like that I am doing
> something wrong?
> Here is the code...
>
> @ $db = mysql_pconnect("localhost:3306", "omegaweb", "jesus316");
>
> if( $db ) { echo "Connected"; }
> if( !$db )
> {
>echo "Error: Could not connect to database. Please try again later.";
>exit;
> }
>
> mysql_select_db("books");
> $query = "SELECT * FROM books WHERE ".$searchType." LIKE
> '%".$searchTerm."%'";
> $result = mysql_query($query);
>
> $num_results = mysql_num_rows($result); //This is where I am getting the
> error actually: "Warning: mysql_num_rows(): supplied argument is not a
valid
> MySQL result resource in c:\inetpub\wwwroot\php testing\results.php on line
> 33"
>
> I figured that if $result is NULL then of course there would be an error.
>
> Could someone shed some light on this newbie?
> Thanx
>
>
> _
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
- --
Jeff Powell
[EMAIL PROTECTED]
http://www.yonezawa-english-school.com
http://www.yonezawa-english-school.com/powell
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE+Lj6mbJk3zHBW5lARAt80AJ98zx7t7oxs9pP6Is30J6OvnL2RIQCfQJiX
1zDjRnKkBr9Mo3VknCAXsDE=
=v6rJ
-END PGP SIGNATURE-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC Driver?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am preparing to migrate a client from using a large MS-ACCESS database to using a linux hosted MySql as the datasource. Or at least I'd like to be able to export tables as a backup. Please tell me where I can get a driver. Thanks, - -- Jeff Powell [EMAIL PROTECTED] http://www.yonezawa-english-school.com http://www.yonezawa-english-school.com/powell -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+MHrobJk3zHBW5lARAhyFAKDQ/bsoPm04VQVsq43+EpZNKb/DrwCeMmjO B8Sf38yWG3Lb+ex3Rdoy1Rs= =DajP -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Entering Japanese characters into mySQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Darren, I can input Japanese text using Netscape 7.01 on a Linux PC I use a PHP script to write the submitted information to the database. Here is a dump from the "select *" query. 3 Eiji Goto 0 D 0 米沢 The Netscape->PHP->MySQL->PHP->Netscape path is OK. I hope this helps you isolate the trouble. Netscape 7.01 Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.2) Gecko/20021120 Netscape/7.01 Jeff - ---Original Message--- From:Darren Luckett Sent: Thursday 23 January 2003 09:58 pm > hello, > > I'm new to this mailing list and am having trouble with mySQL and > japanese characters. > > I have a web form in Netscape that the user enters japanese text > (hiraghani). the data is posted to a dbinsert.jsp page. the problem is > that somewhere along the line the character set transforms into > half-width katakana (usually a language used for non-japanese origin > words - i.e English or Computer). > > I am using JSP and Tomcat with Apache on Mac OSX. I've tried setting the > charset to Shift-JIS, JIS, ujis, AutoDetect & EUC but with no results. > JIS is the most stable. > > Can anybody help > > Thanks > > Darren Luckett > E: [EMAIL PROTECTED] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - -- Jeff Powell [EMAIL PROTECTED] http://www.yonezawa-english-school.com http://www.yonezawa-english-school.com/powell -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+MH95bJk3zHBW5lARApgxAJ4+0Gzknm7C34MobxA0pniWVizXagCglz2W WJ+crra93Z96f35nNFsO6fI= =zXls -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
