Hi thr,
please provide me some link or tutorial on "How to Setup a SQL server on Fedora Core 2.
I have installed the software and have created some tables too....but then when i wrote a *.php file to get it worked...............nothing happened
my php script for that is :
** where "nk1.sql" is the table which i made through that SQL software..( sorry if i m using some wrong term...i m completely newbie to this things...so please bear with me )


<?
$user="nitin";
$password="";
$database="nk1";
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
mysql_query($query);
mysql_close();
?>

what is the problem.....i cudnt figure it out till now...

ps: my apache server is working okay .
BUT ONE MORE THING..........MY PHPINFO.PHP Script is not showing anything abt MySQL Server..........

You must compile php to work with mysql. The php rpm for fedora comes compiled with support for mysql, I didn't have good luck using the fedora rpms. Try following this tutorial http://www.madpenguin.org/cms/?m=show&id=751. It is written for fedora 1, but it should work for you. Let me know if you need help.

MY PHP thing is working fine..........problem is...i m unable to connect with MySQL database....
created a table but...dont know..how to connect it..
thanx for ur concern
regards
nitin

it doesn't matter if your php is working. THat does not mean that it is working with your mysql. It must show that it was configured with the mysql option. Look at your phpinfo(); output and see if it was e.g --enable-mysql=/path/to/mysql in the configuration switches.