|
|
Posted by Jerry Stuckle on 11/13/07 19:34
John S. wrote:
> I'm relatively new at this. I can use php to create a 'products'
> table in the SQL 'ximport' database using similar code as shown below
> but with the create rather than the drop command line. However, I
> cannot use the drop command to delete the table 'products'. What is
> wrong with the following code saved in a file called drop.php
> downloaded to my host Globat and run from the Explorer 6 browser with
> the url -- drop.php:
>
> <html>
> <head>
> <title>Dropping a Database Table</title>
> </head>
> <body>
> <br>***** BEGIN OF HTML PROGRAM *****<br>
> <?php
> $conn = mysql_connect('localhost','nameximport','pwsdximport');
> echo $conn;
> mysql_select_db('ximport',$conn);
> $sql = "DROP TABLE IF EXISTS 'products'";
> $result = mysql_query($sql,$conn);
> echo $result;
> ?>
> <br>***** END OF HTML PROGRAM *****<br>
> </body>
> </html>
>
>
> Note the drop line ends with single quote, double qoute, semicolon.
> There is always a secret. I can't seen to figure it out. Maybe
> Globat has not implemented this feature?! Thanks for any help. It
> would be much appreciated.
>
>
OK, what's the return value in $result? If it's false, what's the
response from mysql_error()?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
[Back to original message]
|