edit wordpress website

You need properties listing using specific layouts for those 2 categories of properties and with the defined searching function with some extra added parameters than the theme already has To do that why do you need to edit MySQL database fields? Here, the theme is using default "wp_post" table to record property data and also using custom meta fields to store additional data so to add extra fields or parameters you need for searching: those can also be added using "custom meta fields" either by the plugin you installed or by coding then to search: you just need to create that search form or edit the one in the theme and collect data from the submitted form and and make a "WP query" for post checking on those custom meta data and then to list the found properties To edit the listing layout: we need to add/edit theme listing template file to get the required layout To have 2 different categories of properties: you can just create two different "categories" already avilable in the theme "Properties" menu in WP admin dashboard Lastly I see from you requirements no need to alter database fields And a simple kind of PHP-MySQL code to add a new WP database fields global $wpdb; $wpdb->query("ALTER TABLE {$table_name} ADD COLUMN {$new_field} TEXT NOT NULL"); and then you can add data by "INSERT" mysql command and then again can fetch back that data while searching using "SELECT" command. But I think that won't be required here in your case.