MySQL Short Help!

[FlyingSpoon]

 function pump_rem ( p, cmd ) 
   if ( exports.global:isPlayerAdvancedSupervisor(p) ) then 
   if not cmd then 
      outputChatBox("SYNTAX: /"..cmd.." [id]", p) 
   else 
       local query_two = mysql:query ( "DELETE FROM fuelpumps WHERE id='"..id.."'") 
       if query_two then  
       outputChatBox("Fuel pump successfully deleted.", p, 0, 255, 0) 
       end 
     end 
  end 
end 
addCommandHandler("delpump", pump_rem) 

Well Idk what I have done, but people createPump, and then it inserts to MySQL with certain ID's.

But I want to now make a command so people can delete them certain ID's.. how would I do it?

e.g. If person create's pump with ID 1 in MySQL Database, but after want to delete it they do -

./delpump 1

How would I do this please, help!

[t3wz]

cmd always will be delpump, you've to add id to the parameters of the pump_ren function (after cmd).

function pump_rem ( p, cmd, id ) 

also you've to check if id is different than nil, if it's a number etc

wiki have a well made explanation about parameters, check it.

[FlyingSpoon]

Didnt work... It just keeps outputting

Fuel pump successfully deleted even if I just write ./delpump it just keeps outputting that message

[FlyingSpoon]

Nvm.. works <3 ty