Re: [PHP] MySQL Newbie

2002-01-28 Thread bvr
Hi, You can do the exact same thing but instead of connecting to localhost, you connect to the remote server. To do this with the mysql monitor tool, use the -h command line option, followed by the hostname or IP of the server. If you cannot access the online database directly (possibly for

Re: [PHP] MySQL Newbie

2002-01-28 Thread Girish Nath
To: <[EMAIL PROTECTED]> Sent: Monday, January 28, 2002 10:49 PM Subject: [PHP] MySQL Newbie How do I use MySQL through the web. I currently have MySQL running on my personal PC on WinXP. I use a command prompt to add tables, add records, and so forth. How do I create tables and records whe

Re: [PHP] MySQL Newbie

2002-01-28 Thread hugh danaher
uldn't open $db ".mysql_error()); $results=mysql_query("$request"); // purpose statement if (! $results) { die ("cannot Modify $db ".mysql_error()); } else { print "Database Action: ".$request; } mysql_close($link); unset($db); } ?>

[PHP] MySQL Newbie

2002-01-28 Thread Ben Clumeck
How do I use MySQL through the web. I currently have MySQL running on my personal PC on WinXP. I use a command prompt to add tables, add records, and so forth. How do I create tables and records when my database is on the web? Thanks, Ben -- PHP General Mailing List (http://www.php.net/) T

RE: [PHP] MySQL Newbie ? -Help!

2001-01-09 Thread Matt Stone
Stone; PHP List Subject: Re: [PHP] MySQL Newbie ? -Help! one simple way would be to make a duplicate, empty table and then do: insert into newtable select distinct * from oldtable then try adding a uniqueness constraint if you don't want duplicates in the future jason > Hi, > Is t

Re: [PHP] MySQL Newbie ? -Help!

2001-01-09 Thread Jason Brooke
one simple way would be to make a duplicate, empty table and then do: insert into newtable select distinct * from oldtable then try adding a uniqueness constraint if you don't want duplicates in the future jason > Hi, > Is there a way to go through a table and remove all duplicate entries s

[PHP] MySQL Newbie ? -Help!

2001-01-09 Thread Matt Stone
Hi, Is there a way to go through a table and remove all duplicate entries so that there is only one? The way I am doing it now is taking FOREVER. Thanks, Matt Stone ___ This email may contain confidential and/or privileged information for the sole use of the intended