Scratch

jvvg · 2012-06-19 01:00:58

As good as everyone thinks I am at PHP, I'm not that good as SQL.

Could someone please help me turn the group of SQL queries grouped with PHP into a single query?

Here is the code:

Code:

function check_read_forum($fid) {
    global $db, $forum_user;
    if ($forum_user['is_guest']) {
        return false;
    }
    $result = $db->query('SELECT id FROM ' . $db->prefix . 'topics
    WHERE forum_id=' . $fid) or error_msg('Could not check for unread messages - part 1');
    while ($topic = $db->fetch_assoc($result)) {
        $r2 = $db->query('SELECT 1 FROM ' . $db->prefix . 'read
        WHERE topic_id=' . $topic['id'] . ' AND user_id=' . $forum_user['id']) or error_msg('Could not check unread messages - part 2');
        if (!$db->num_rows($r2)) {
            return true;
        }
    }
}

jvvg · 2012-06-20 01:13:42

Bump sad
I need help!

SJRCS_011 · 2012-06-20 08:25:47

jvvg wrote:
Bump
I need help!

What's wrong with the current one?
it seems like it would work fine
But couldn't you just do

Code:

SELECT * FROM  ' . $db->prefix . 'topics WHERE forum_id = '.$fid

Then just pick and choose which parts you want to use?

rookwood101 · 2012-06-20 10:39:15

So your trying to use OOP and PDO?

jvvg · 2012-06-20 12:01:20

rookwood101 wrote:
So your trying to use OOP and PDO?

The OOP is database abstraction. What's PDO?

@SJRCS_011: That won't work.

SJRCS_011 · 2012-06-20 22:12:31

jvvg wrote:
rookwood101 wrote:
So your trying to use OOP and PDO?
The OOP is database abstraction. What's PDO?

@SJRCS_011: That won't work.

ok, it was just expermiental

GP1 · 2012-06-20 22:21:30

You want multiple querys in a single call, right?
If you are using the mysql functions, then it wont work. Mysqli functions, however, do have a method that allows you to do multiple querys at the same time. I never use mysqli because mysql functions do the job just fine for me. I only do single querys wink

jvvg · 2012-06-21 01:03:17

Let me put it this way:

I am writing a program to check for unread messages in a forum.
What I do is I have a table that shows read topics (user ID and topic ID).

I need code to check if the forum has any unread messages.

Scratch

archived forums

#1 2012-06-19 01:00:58

Help with PHP/SQL?

Code:

#2 2012-06-20 01:13:42

Re: Help with PHP/SQL?

#3 2012-06-20 08:25:47

Re: Help with PHP/SQL?

jvvg wrote:

Code:

#4 2012-06-20 10:39:15

Re: Help with PHP/SQL?

#5 2012-06-20 12:01:20

Re: Help with PHP/SQL?

rookwood101 wrote:

#6 2012-06-20 22:12:31

Re: Help with PHP/SQL?

jvvg wrote:

rookwood101 wrote:

#7 2012-06-20 22:21:30

Re: Help with PHP/SQL?

#8 2012-06-21 01:03:17

Re: Help with PHP/SQL?

Board footer