Problem trying insert data in to Mysql Datebase [solved]

[andrewvideo]

Hi I am having problems to work out this only half works,


I got working is inserting data in to module_MediaCenter_category, that fine. I want to uplate the id in module_MediaCenter_category.sql and not working. am I missing out something or have I got some code worry.

Can any help and I am new to php and mysql.


Cheers

Andrew

Code: Select all

new_cat_id = $db->GenID(cms_db_prefix() . "MediaCenter_category_seq");
$catview = '0';
$catname = 'Main Videos';
$catalias = 'mainvideos';
$catactive = '1';
$query = "INSERT INTO " . cms_db_prefix() ."module_MediaCenter_category (id, viewed, modified, created, name, alias, active )
VALUES (?, ?, ?, ?, ?, ?, ?)";
# add the Data
$result = $db->Execute($query, array($new_cat_id, $catview , $db->DBTimeStamp(time()), $db->DBTimeStamp(time()),$catname,$catalias,$catactive));

[calguy1000]

After a query you can echo:
$db->sql --- to get the exact query that was given to mysql
$db->ErrorMsg() -- to get the error message that mysql returned.

[andrewvideo]

I dint get in any errors

echo $db->sql; gave me

Code: Select all

INSERT INTO cms_module_MediaCenter_category (id, viewed, modified, created, name, alias, active ) VALUES (24, '0', '\'2011-05-21 01:48:04\'', '\'2011-05-21 01:48:04\'', 'Main Videos', 'mainvideos', '1')

and $db->ErrorMsg() return noting. I am really lost now.

The data is going in 'cms_module_MediaCenter_category' fine, just not cms_module_MediaCenter_category.sql. should be adding a id number there and not.

I hope I make sence.

Cheers

Andrew

[Jos]

The line

Code: Select all

new_cat_id = $db->GenID(cms_db_prefix() . "MediaCenter_category_seq");

should update your sequence table and give you a new ID at the same time.

Could it be you miss something in the tablename? Should that not be like this?

Code: Select all

new_cat_id = $db->GenID(cms_db_prefix() . "module_MediaCenter_category_seq");

[andrewvideo]

OMG! I can't believe it. I spent hours on the is problem and it so simple to fix. I could not find the mistake.

Thank you very much Jos for help. Sometimes I find it hard to spot things like that, I have Dyslexia.

Cheers


Andrew

[Jos]

no problem... I guess we all have these kind of mistakes we never are able to notice ourselves