Help with deleting data from a table

AndyEarley

Hi, I can't delete data from one of my tables. I get this error message..

Connected successfully
Could not delete table: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM vehicle' at line 1

<html>
<head>
<title></title>
</head>
<body>
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$conn = mysql_connect($dbhost, $dbuser);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully<br />';
$sql = "DELETE * FROM vehicle";
mysql_select_db( 'carhire_website' );
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not delete table: ' . mysql_error());
}
echo "Table deleted successfully\n";
mysql_close($conn);
?>
</body>
</html>

Help again please!! Thanking you

halojoy

DELETE is for rows.
Try:
"DROP TABLE vehicle" .. this will delete the table and all rows in it, of course.
You will need to CREATE a new table, to use it again.

If you want to keep the table, but make it empty = delete all rows.
use
"DELETE FROM vehicle"
.. and table is still there, but no rows

david8787

...

AndyEarley

i've done it!

pretty straightforward really. doh.

<?php
$db = mysql_connect('localhost', 'root') or 
    die ('Unable to connect. Check your connection parameters.');
mysql_select_db('carhire_website', $db) or die(mysql_error($db));

$query = 'DELETE FROM vehicle
        WHERE
            make = "Ford"';
    mysql_query($query, $db) or die (mysql_error($db));
    echo "Vehicle deleted successfully\n";
    ?>

AndyEarley

i've done it!

pretty straightforward really. doh.

<?php
$db = mysql_connect('localhost', 'root') or
die ('Unable to connect. Check your connection parameters.');
mysql_select_db('carhire_website', $db) or die(mysql_error($db));

$query = 'DELETE FROM vehicle
WHERE
make = "Ford"';
mysql_query($query, $db) or die (mysql_error($db));
echo "Vehicle deleted successfully\n";
?>

halojoy

Congratulations!
Now you will know it for the rest of your life 🙂
'Keep On Deleting' ..... the new song
( The old one is called: "Keep On Running" )

AndyEarley

another thing. if i were to show you this little bit of code, could you tell me where i am going wrong in the where clause...

$query = 'SELECT
       vehicle_id, make, price, model
    FROM
        vehicle
    WHERE
    model = "X5", "Focus"

ORDER BY
    vehicle_id ASC';
$result = mysql_query($query, $db)or die(mysql_error($db));

I want all the X5 and Focus vehicles to show up but it's giving me an error on the where clause..?

bradgrafelman

Well of course it's giving you an error.. you can't just make up your own syntax without errors popping up!

Just do a simple OR:

WHERE model = 'X5' OR model = 'Focus'