SQL commands request from a novice

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL commands request from a novice

Author

Topic

Alan Glynne Jones
Starting Member

1 Post

Posted - 2007-10-02 : 18:59:06

Hello,

I'm running a (phpBB) forum which uses a MYSQL data base - I can access the database via a webpage through my ISP and it lets me run short scripts (through a web interface). I need to do the following (shown in psuedo code below). I would be eternally grateful if someone could translate it into pure SQL commands for me to paste into my SQL quiery input field on the web page I'm using to access my database. (I'm a complete SQL novice)

=====================
/* I need to be sure these commands will do nothing if 'jeff' does not exist in the user table */

/* extract the id value for the user called 'jeff' from the users table */
user = GET id FROM users WHERE username = "jeff"

/* remove all entries from the forums_watch and topics_watch tables that contain Jeff's userID */
REMOVE ALL ENTRIES WHERE userID = user

notify = 0;

/* insert many entries into the topics_watch table, one for each topic that exists in the topic table */
arrayOfTopicIDs = GET ALL id FROM topics
FOR EACH current_Topic IN arrayOfTopicIDs {
INSERT INTO topics_watch
(topic_id, user_id, notify_status)
values (current_Topic, user, notify)
}

/* insert many entries for jeff into the forums_watch table, one entry for each forum that exists in the forum table */
arrayOfForumIDs = GET ALL id FROM forums
FOR each current_Forum in arrayOfTopicIDs {
INSERT INTO forums_watch
(topic_id, user_id, notify_status)
values (current_Forum, user, notify)
}

=====================

I'm going to implement this with php and MYSQL as a mod for my forum application (phpBB) - but I could really do with a way of doing this immediately with pure SQL commands as a quick and dirty one shot paste into the input field of the MYSQL database web interface until I get the php mod going.

Can this be done using only SQL commands without tedious repetition?

Best Regards,

Alan

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-02 : 19:03:05

You have posted on a Microsoft SQL Server forum. You'd have better luck if you posted on a forum that dealt with mysql, such as the forum over at dbforums.com.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-10-02 : 19:05:13

First - This is not a MySQL forum, it is a SQL Server forum, syntactically they are different so any queries provided may not work for you.
Second - You will need to provide table structures (column names and relationships) in any case.

Future guru in the making.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources