[Weird MySQL problem]

Thanks Enthusiast.

 

It actually does work as a standalone script so I guess there is something strange going on within my actual page and yet the echoed $sql value looks fine!

 

I'll have another look. Thanks again.

[Weird MySQL problem]

Thanks for replying. 

 

No, I only have the one Db for this project.  I could kind of understand if a record was not being written due to coding error/data problems but not being written with the variables not recorded, the sql statement is valid syntax and it works within phpmyadmin.  I just cannot understand this.

 

(to answer the other question... I used $sql to make it simple to echo it).

[Automatically Putting a Noindex to Pages With No Content]

Just a suggestion and assuming you have control over the page creation in your cms.

 

Create two files  meta.htm and meta_noindex.htm

Put the relevant meta tag value into each

If page content is blank then include meta_noindex.htm else include meta.htm

 

Hope this is helpful?

[Weird MySQL problem]

Hi,

 

My first post so I hope I can explain this correctly...

 

I have a table that looks like this ...

 

CREATE TABLE IF NOT EXISTS `kb_services` (

  `serv_id` mediumint(7) NOT NULL AUTO_INCREMENT,

  `serv_text` varchar(100) NOT NULL,

  `serv_cost` decimal(5,2) NOT NULL,

  `serv_freq` char(1) NOT NULL,

  `serv_desc` longtext NOT NULL,

  `serv_type` char(1) NOT NULL,

  PRIMARY KEY (`serv_id`)

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

 

I am updating/inserting to this table from the results of a form.

 

My insert code looks like this ..

$db = @mysql_connect("localhost","xxxxx","xxxxx") or header("Location: xxxt.php");
mysql_select_db("xxxx",$db) or header("Location: xxx.php");

$a = addslashes(trim($_POST['serv_text']));
$b = addslashes(trim($_POST['serv_freq']));
$c = addslashes(trim($_POST['serv_cost']));
$d = addslashes(trim($_POST['serv_desc']));

mysql_query($sql = "INSERT INTO kb_services (serv_text,serv_freq,serv_cost,serv_desc,serv_type) VALUES ('$a','$b','$c','$d','D')"); 

 

this inserts a record but all the variables are blank except for serv_type.  I echoed the $sql immediately after the insert and it looks like this

INSERT INTO kb_services (serv_text,serv_freq,serv_cost,serv_desc,serv_type) VALUES ('Test Text','O','19.99','Test Description','D') 

 

If I go directly into the Db (using phpmyadmin) and paste the echoed code into a sql statement then the record is inserted with all values recorded correctly.

 

Any ideas please?

 

Many thanks

John G