I am trying to insert some data using sql query in mysql. GHowever something is going wrong and data is not being inserted.
I tried a lot, but i am unable to find the mistake.Please help.Following is the code-
<?php
$server = 'localhost';
$login='event';
$pass='A1B1';
$db='eventcar';
$conndb=mysqli_connect($server,$login,$pass,$db) or die ("DB connection failed because:" . mysqli_error($conndb));
mysqli_query($conndb,"INSERT INTO `tbl_event` (`event_id`, `paypal_charges`, `tax`, `convences_charges`, `mem_id`, `category_id`, `category_links`, `event_name`, `event_friendly_url`, `event_date_start`, `event_time_start`, `event_date_end`, `event_time_end`, `event_type`, `country`, `city`, `address`, `url`, `event_listing`, `email_ids`, `event_ticketed`, `doing_ticket_through_us`, `ticket_type`, `ticket_url`, `total_tickets`, `min_tickets`, `maxt_tickets`, `ticket_price`, `name_of_account`, `account_number`, `account_type`, `bank_name`, `bank_address`, `ifsc_code`, `event_logo`, `event_details`, `organizer_name`, `organizer_logo`, `organizer_details`, `event_viewed`, `zipcode`, `event_url`, `facebook_url`, `youtube_url`, `twitter_url`, `status`, `post_date`, `most_popular`, `event_approval_status`) VALUES (NULL, '0', '0', '0', '0', '16', '16', 'Suraj Jagan live in Concert', 'suraj-jagan-live-in-concert', '2014-06-08', '7:30 PM', '2014-06-08', '9:30 PM', 'Offline', 'India', 'Ahmedabad', 'At B J Medical college, Civil Hospital, Ahmedabad, Gujarat, India.', '', 'Public', NULL, 'Yes', 'No', NULL, NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'description', '', NULL, NULL, '0', NULL, '
http://abc/xyz';, '', '', '', '1', '2014-05-30', '0', '1');");
echo mysqli_insert_id();
?>