FUDforum: FUDforum Installation Issues » obtaining MySQL version: mysql_row

Home » FUDforum » FUDforum Installation Issues » obtaining MySQL version: mysql_row_arr error

Show: Today's Messages :: Polls :: Message Navigator

obtaining MySQL version: mysql_row_arr error [message #11710]

Mon, 14 July 2003 21:46

morganw

Messages: 6
Registered: July 2003

Karma:

Junior Member

http://fud.prohost.org/doc/d/html/installation.html#install.verify.config

says that to get MySQL version, use

<?php
mysql_connect("127.0.0.1", "USER_NAME", "PASSWORD");
$result = mysql_query("SELECT VERSION()");
list($mysql_version) = mysql_row_arr($result);
echo "MySQL Version: ".$mysql_version."<br>\n";
mysql_free_result($result);
?>

I just got next-to-latest stable PHP (4.3.1 'cause 4.3.2 download links were broken) & built it from source. It doesn't have a mysql_row_arr() function. Instead, I used this to get the version:

<?php
mysql_connect("127.0.0.1", "USER_NAME", "PASSWORD");
$ver_result = @mysql_query("SELECT Version() AS version");
$ver_row = @mysql_fetch_array($ver_result);
$mySQLversion = $ver_row["version"];
echo "MySQL Version: ".$mySQLversion."<br>\n";
mysql_free_result($ver_result);
?>

Which gave me this as output:

this is the body
PHP Version: 4.3.1
MySQL Version: 3.23.47-log

(I used the built-in MySQL. Install FUDForum next....)

Report message to a moderator

[Message index]

		obtaining MySQL version: mysql_row_arr error By: morganw on Mon, 14 July 2003 21:46
		Re: obtaining MySQL version: mysql_row_arr error By: Ilia on Mon, 14 July 2003 23:25
		Re: obtaining MySQL version: mysql_row_arr error By: ebyrob on Thu, 09 November 2006 01:03
		Re: obtaining MySQL version: mysql_row_arr error By: Ilia on Thu, 09 November 2006 16:54
		Re: obtaining MySQL version: mysql_row_arr error By: ebyrob on Thu, 09 November 2006 18:40
		Re: obtaining MySQL version: mysql_row_arr error By: Ilia on Fri, 10 November 2006 15:32
		Re: obtaining MySQL version: mysql_row_arr error By: ebyrob on Fri, 10 November 2006 17:55
		Re: obtaining MySQL version: mysql_row_arr error By: Ilia on Sun, 12 November 2006 16:19
		Re: obtaining MySQL version: mysql_row_arr error By: ebyrob on Mon, 13 November 2006 18:48
		Re: obtaining MySQL version: mysql_row_arr error By: Ilia on Tue, 14 November 2006 14:38
		Re: obtaining MySQL version: mysql_row_arr error By: ebyrob on Tue, 14 November 2006 18:15

Previous Topic:	Restoring FUDforum Fails
Next Topic:	Unlocking files cause Server Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 20:57:38 GMT 2024

Total time taken to generate the page: 0.04938 seconds