Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

Help me with the Mailing

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

Moderators: macek, egami, gesf

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);
swee
New php-forum User
New php-forum User
 
Posts: 9
Joined: Tue Sep 21, 2004 9:42 pm

Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron