Help me with the Mailing

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

swee
New php-forum User
New php-forum User
Posts: 9
Joined: Tue Sep 21, 2004 9:42 pm

Help me with the Mailing

Postby swee » Thu Sep 23, 2004 3:04 am

Hi all,

1) I've created a TESTIMONIAL page for the customers. so after filling up the details, the customers will submit the info and it wll be directed and insterted into the phpMyadmin table. However, the problem is taht, the value inserted is to the wrong column. Why will this happen?

2) Then, There is one column where we can view the comments given by the customer but it was cut off half way. Then i found out that it was becuae the variable type is VARCHAR 255, then i changed it to TEXT and BLOB..but nothing can help. Why is it so too?

Hope someone will guide me wiht this new application on hand. Thanks alot.

Take care,
With Regards,
Swee :-?

Ps. Below is the Code for the Testimonial.

Code: Select all

if(isset($_POST['mailing2'])){
   $query="SELECT * from Customer WHERE CustEmail='".$_POST['email']."';";
   $result=safe_query($query);
   if(!(mysql_num_rows($result))){
      $query="INSERT INTO Customer(eid,CustName,CustCountry,CustTailor,CustEmail,regDate,Custrecomm,Custcomment)

VALUES('','".$_POST['name']."','".$_POST['country']."','".$_POST['field3']."','".$_POST['email']."',now(),'".$_POST['recommendation']."','".$_POST['commentbox']."');";
      safe_query($query);

Return to “phpMyAdmin”

Who is online

Users browsing this forum: No registered users and 0 guests