Author Topic: SQL Query - add keyword for cat_id=XX  (Read 4204 times)

0 Members and 1 Guest are viewing this topic.

Offline RoadDogg

  • Sr. Member
  • ****
  • Posts: 488
    • View Profile
    • Düsipixel
SQL Query - add keyword for cat_id=XX
« on: May 17, 2005, 10:14:50 AM »
I want to add to each picture in category 39 a further keyword ? Is this query right ?  :| I don´t know it unfortunately

Code: [Select]
INSERT INTO '4images_images' ('image_keywords') VALUES ('mynewsearchword') WHERE 'cat_id' = '39' ;
??

For support requests please don´t forget link to your Gallery/to phpinfo.php
Code: [Select]
<?
phpinfo()
?>
safe_mode must turned OFF
Please check Error Messages

Offline martrix

  • Hero Member
  • *****
  • Posts: 755
    • View Profile
    • overlord.cz
MAяTRIX


Offline bibabobu

  • Sr. Member
  • ****
  • Posts: 311
  • Technische und künstlerische Gravuren
    • View Profile
    • Technische und künstlerische Gravuren für die gesamte Metall-, Kunststoff- und Papierindustrie
Re: SQL Query - add keyword for cat_id=XX
« Reply #2 on: June 02, 2005, 11:49:32 AM »
What is the correct sql code now for inserting keywords to an specific category table :?:

I don not understand the sql syntax help.

Where do i have to write in the code in the phpmyadmin panel :?: