creating forums using php & mysql

• • Reply

  11 years ago

  by Teelan

  Tolani Hassan

  Glasgow, United Kingdom

  Joined 11 years ago

  Kindly help on using php & mysql database for creating forums. I have been able to insert different topics in the database. I have also created a link on each topic so that a user reviewing a topic can post a reply.When the link is clicked on to view an issue, no details are brought up from the sql query and the form to post a reply doesn't come out too,all i have been getting are errors please help. thanks. how do i go about writing the code.

  Report abuse
• • Reply

  11 years ago

  by narendra.bokaro

  narendra kr

  Bangalore, India

  Joined 11 years ago

  Hi Hassan,

  Give me a detail about requirement, and also tell me whether you are using any CMS or tool for creating forum or just simplying writing code after designing the database. Please provide the error detail so that i can help you in a better way.

  Narendra

  Report abuse
• • Reply

  11 years ago

  by Teelan

  Tolani Hassan

  Glasgow, United Kingdom

  Joined 11 years ago

  Hi Narendra,

  thanks for your reply.I have sorted out the error but I'm having an insert sql error message below:

  problem with INSERT INTO Issue (dateT,clientUsername,subject,followUpOn,clientPriority,clientRemarks) VALUES ('2009-08-11 16:43:27','teegirl','shopping','yes','high','awaiting my response please. can't wait forever'):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 't wait forever')' at line 2

  whenever a user enters an apostrophe like I'm in a text box for clientRemarks. please help.

  Thanks

  Report abuse
• • Reply

  11 years ago

  by narendra.bokaro

  narendra kr

  Bangalore, India

  Joined 11 years ago

  Hi Hassan,

  Error is coming due to special character in your sql insert query (apostrophe )...... use \ before your sql query. Mean before executing insert query just check the sql query for a special character and if its there then prefix it with .

  insert into forumtable (id, name, remark, subject) values (2, 'kumar', 'can\'t wait forever', 'check this')

  you can read more (http://dev.mysql.com/doc/refman/5.1/en/string-syntax.html)

  With Regard Narendra

  Report abuse
• • Reply

  11 years ago

  by enersen

  enersen tech

  Delhi, India

  Joined 11 years ago

  Hi,

  We would like to inform you that, we have good technical resources in PHP 4 & 5, MySQL, AJAX, JQuery, JavaScript and Other open source technologies.

  we can do your work with a reasonable price.

  Here are some of our previous work links for your reference, http://www.jukezoo.com/ http://www.ami-partners.com http://www.cbloomers.com/ http://emitest.emiratesflorist.com/ http://www.designosoft.com/ http://www.advanceecomsolutions.com/ http://www.lollipopsandletters.com

  Provide us your contact details. We will be looking forward form you.

  Thanks, Enersen

  Report abuse
• • Reply

  11 years ago

  by jai02

  chris fernandes

  london, United Kingdom

  Joined 11 years ago

  Need some help regarding website designing: For London Airport Taxi Transfer service company

  Hi,

  i am working in a London Taxi Cab Airport transfer company named hummingbird cars http://www.hummingbirdcars.com/. and justed wanted to enquire about website designing? any good suggestion which comp-any will provide me with best solution (design)

  Thanks Jai

  Report abuse
• • Reply

  11 years ago

  by Teelan

  Tolani Hassan

  Glasgow, United Kingdom

  Joined 11 years ago

  Hi Narendra,

  I don't know what the user will enter so it's difficult to be slashes when I'm using post variables. any other suggestion. i have used mysqlrealescape_string. It was still giving errors.

  Thanks

  Report abuse
• • Reply

  11 years ago

  by Teelan

  Tolani Hassan

  Glasgow, United Kingdom

  Joined 11 years ago

  Hi Narendra,

  I don't know what the user will enter so it's difficult to be slashes when I'm using post variables. any other suggestion. i have used mysqlrealescape_string. It was still giving errors.

  Thanks

  Report abuse