[Jerome]

hi,

i need some help on the PHP scripting ...

I need to excute the mysql command by just typing the url of the PHP.file so that i can easily add the mysql query .

WHY -- my script is always giving problem , so i got to reload the query ...

here the mysql command , can any one help me to make a installer script ? thks

DROP TABLE IF EXISTS nuke_whos_online;
CREATE TABLE nuke_whos_online (
user_id int(11) NOT NULL default '0',
uname varchar(25) NOT NULL default '',
user_from varchar(20) NOT NULL default '',
time varchar(14) NOT NULL default '',
ip varchar(48) NOT NULL default '',
guest int(1) NOT NULL default '0',
module varchar(30) NOT NULL default '',
url varchar(255) NOT NULL default ''
) TYPE=MyISAM;

thks

[Stefan]

there is a seperate forum for this, just a bit down. You;d probably get a faster answer (and maybe also a better one) if you post this there.

[Ryan]

Moved to appropriate forum.

[Man Down]

Try this:

PHP Code:

<?

$server = 'localhost'; //MySQL Server

$username = 'root'; //MySQL Username

$password = 'root'; //MySQL Password

$database = 'database'; //MySQL Database Name



mysql_connect($server, $username, $password);

mysql_select_db($database);

mysql_query('DROP TABLE IF EXISTS nuke_whos_online');

mysql_query("CREATE TABLE nuke_whos_online (

user_id int(11) NOT NULL default '0',

uname varchar(25) NOT NULL default '',

user_from varchar(20) NOT NULL default '',

time varchar(14) NOT NULL default '',

ip varchar(48) NOT NULL default '',

guest int(1) NOT NULL default '0',

module varchar(30) NOT NULL default '',

url varchar(255) NOT NULL default '')");



?>

[Chris Boulton]

Or install phpMyAdmin (http://phpmyadmin.sourceforge.net) and you can run these queries via a point and click interface in your browser.

[Jerome]

the point is by running the phpmyadmin , i will take quite sometime for me to upload the query , by using the script , i just need to point the url and that's all .. thanks Man Down

and thanks to Chirst for your attemp

and sorry to Ryan for the misposting of the article

[rangasamyajith]

how to store the image in database pls reply and how to store and reterive the data in php

[End User]

It would be best if you created a new topic for this, instead of reopening a 2-year old thread that's unrelated.

Originally Posted by rangasamyajith

how to store the image in database pls reply and how to store and reterive the data in php