creating forums using php & mysql

asap , for website design , mysql forum creation , php Glasgow, United Kingdom
  • 8 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.

  • 8 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

  • 8 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

  • 8 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

  • 8 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

  • 8 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

  • 8 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

  • 8 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

Post a reply

Enter your message below

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

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Every language has an optimization operator. In C++ that operator is ‘//’”