|
|
Posted by Jerry Stuckle on 11/13/07 22:19
John S. wrote:
> Jerry,
>
> I am now using the following code in drop.php,
>
> <html>
> <head>
> <title>Dropping a Database Table</title>
> </head>
> <body>
> ***** BEGIN OF HTML PROGRAM *****<br><br>
> <?php
> print "BEGINNING OF PHP<br>";
> $conn = mysql_connect('localhost','ximport','ximport');
> echo $conn;
> mysql_select_db('ximport',$conn);
> $sql = "DROP TABLE 'products'";
> $result = mysql_query($sql,$conn) or die(mysql_error());
> print "RESULT = ";
> echo $result;
> print "<br>END OF PHP";
> ?>
> <br><br>***** END OF HTML PROGRAM *****
> </body>
> </html>
>
>
> If I put products in single quotes as 'products' in the DROP command,
> I get the following output:
>
> ***** BEGIN OF HTML PROGRAM *****
>
> BEGINNING OF PHP
> Resource id #2You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to
> use near ''products'' at line 1
>
> If I put products in back ticks as `products` in the DROP command, I
> get the following output:
>
> ***** BEGIN OF HTML PROGRAM *****
>
> BEGINNING OF PHP
> Resource id #2RESULT = 1
> END OF PHP
>
> ***** END OF HTML PROGRAM *****
>
> OMG, it's gone. I am sure I tried that several times before. But I
> can reproduce the operation, so something must have been hung up
> somewhere.
>
> If I put products with no quotes or ticks in the DROP command, I get
> the following output:
>
> ***** BEGIN OF HTML PROGRAM *****
>
> BEGINNING OF PHP
> Resource id #2RESULT = 1
> END OF PHP
>
> ***** END OF HTML PROGRAM *****
>
>
> Seems to be better now. Can't figure it why it did not work
> previously. Use single quote in the $conn command, back ticks
> somewhere else, no quotes sometimes. Is there a definite rule for
> using regular single quote, back tick (single opening quote), or no
> quote for different commands or do some work and other don't? ` for
> variable names, ' for real data, maybe?
>
> Been testing for about 30 minutes now, and there must be some time
> delay at my host because it doesn't always drop right away on 1st or
> 2nd refresh of drop.php (or create fast either), at least when I look
> at the database via phpMyAdmin. Odd I think. But I think that that
> might have been my problem, looking for instant verification and
> instant gratification.
>
> What's the difference between resource id #2 and id #21?
>
> Thanks for your help. I think I am right track now, but this is new
> stuff for a guy who understands the general concepts and who grew up
> with Fortran, dbase and WordStar and doesn't appreciate Windows, etc.,
> but loves the internet.
>
> Regards.
>
>
That is correct. Table and column names should not be within single
quotes. In fact, there is no reason to use backtickies either, unless
you're using a reserved word for a table or column name. And that's not
a good idea.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|