Community discussion forum

Back to discussion

creating forums using php & mysql

Last post was 20 Aug 2009 at 22:40
Tags: asap, for website design, mysql forum creation, php Glasgow, United Kingdom
  • 3 months 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.

    Post was edited on 31/07/2009 21:53:50 Report abuse
  • 3 months 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
  • 3 months 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
  • 3 months 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
  • 3 months 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
  • 3 months 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
  • 3 months 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
  • 3 months 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

Post a reply

Enter your message below

Sign in or Join us (it's free).

Quick links

Recent activity

Languages

Web Development

Frameworks & Architecture

Other major sections

Cancel
We'd love to hear what you think! Submit ideas or give us feedback