I like cake

[cluelessPHP]

Can I post I like cake and if I like cake, why is my user id N/A hmm yes cake is good will this post work, should I have cake for breakfast...probably

[cluelessPHP]

(22,
(
SELECT stat_id
FROM status
WHERE EXISTS
(
SELECT stat_id
FROM status
WHERE stat_id = 6
)
AND NOT EXISTS
(
SELECT stat_id
FROM user_interaction
WHERE stat_id = 6
)
),
1)

[cluelessPHP]

INSERT into user_interaction(user_id, stat_id, likeStat) VALUES
(22,
(
SELECT stat_id
FROM status
WHERE EXISTS
(
SELECT stat_id
FROM status
WHERE stat_id = 6
)
AND NOT EXISTS
(
SELECT stat_id
FROM user_interaction
WHERE stat_id = 6
)
),
1)

[cluelessPHP]

INSERT into user_interaction(user_id, stat_id, likeStat) VALUES
(22,
(
SELECT stat_id
FROM status
WHERE EXISTS
(
SELECT stat_id
FROM status
WHERE stat_id = 6
)
AND NOT EXISTS
(
SELECT stat_id
FROM user_interaction
WHERE stat_id = 6
)
),
1)

[cluelessPHP]

well for whatever reason that code brakes the forum when posting a new thread

[laserlight]

What if you use [noparse]

[/noparse] bbcode tags?

[cluelessPHP]

INSERT into user_interaction(user_id, stat_id, likeStat) VALUES
(22, 
(
SELECT stat_id
FROM status 
WHERE EXISTS 
(
SELECT stat_id
FROM status 
WHERE stat_id = 6
)
AND NOT EXISTS
(
SELECT stat_id
FROM user_interaction
WHERE stat_id = 6
)
),
1)

[cluelessPHP]

INSERT into user_interaction(user_id, stat_id, likeStat) VALUES
			(22, 
			(
				SELECT stat_id
				FROM status 
				WHERE EXISTS 
				(
					SELECT stat_id
					FROM status 
					WHERE stat_id = 6
				)
				AND NOT EXISTS
				(
					SELECT stat_id
					FROM user_interaction
					WHERE stat_id = 6
				)
			),
			1)

[cluelessPHP]

You can't specify target table 'user_interaction' for update in FROM clause

[cluelessPHP]

You can't specify target table 'user_interaction' for update in FROM clause

[cluelessPHP]

If #10 and #8 are in the same post in advanced posting it won't post it

[SerenityPantone]

cluelessPHP;11056795 wrote:

well for whatever reason that code brakes the forum when posting a new thread

Yes, I think , it could be , there could be a standard rules for codes in the forum that one needs to follow.

[dalecosp]

SerenityPantone;11057101 wrote:

Yes, I think , it could be , there could be a standard rules for codes in the forum that one needs to follow.

Actually, I think it's taken a little while for some "security plugins" to be configured appropriately by the $site_powers_that_be. We had [thread=10394981]trouble posting JavaScript in the "ClientSide" forum recently[/thread], for example.