Query not working

[Cool]

Code Select Expand

else if ( cmd == "spawnwepdel")
    {

    if ( CheckTableSpawnwep( player ) )
    {
        mysql_query( sDB, "DELETE FROM SpawnWep WHERE lower(Nick)='" + player.Name.tolower() + "'" );
print(mysql_error(sDB));
        ClientMessage( "-> Your Spawnwep have been deleted.",player,255,0,102); SpawnwepPlayer[ player.ID ] = null;
    }
    else ClientMessage( "-> Error: You not have spawnwep.",player,255,0,102);
    }error: Table 'database.SpawnWep' Does not exists

[Thijn]

And what do you think that error means?

[KAKAN]

Steps to correct:
1. Open your MySQL database using phpMyAdmin
2. Check whether the table is 'Spawnwep' or 'Spawnweps'

[Cool]

Steps to correct:
1. Open your MySQL database using phpMyAdmin
2. Check whether the table is 'Spawnwep' or 'Spawnweps'

Spawnwep

[Cool]

And what do you think that error means?

The error mean is table not exists but table is exists

[Xmair]

Steps to correct:
1. Open your MySQL database using phpMyAdmin
2. Check whether the table is 'Spawnwep' or 'Spawnweps'

Spawnwep

Then try changing SpawnWep to Spawnwep. (If you're running the server in windows)

[Cool]

I did not notice this small mistake Thanks for pointing out