PHP - Times 'Shouted' (Explained more)

[zMagenta]

Hello!

As the title may be mis-leading this is what I mean, right. Is there a way to display the amount of times a user has shouted? So the column for the table which holds their username is 'shouted_by', so I'd want to it to be something like this.

"Spoken: <b><times 'shouted_by'></b> times!"

Do you understand? If not, happy to go into more detail. Thanks.

 

[Weasel]

What do you mean with 'shouted'?

 

[JamesFTW]

Shouted means like bold and a code with PHP; TBH you might need to add abit of Java in there for text effects

 

[zMagenta]

What do you mean with 'shouted'?

Whenever someone types a comment, it adds into the table 'shout' with the structure:
'id'
'shouted_by'
'text'
'timestamp'
'ip'.

I want to be able to show the amount of times a user has comment if their ID is above 8. (Is that more help?)

 

[JamesFTW]

<b><times 'shouted_by'></b> times!"

maybe

<b><times 'shouted_by'></b> "times!"

 

[zMagenta]

<b><times 'shouted_by'></b> times!"

maybe

<b><times 'shouted_by'></b> "times!"

What the fuck are you on about..

 

[JamesFTW]

The script
FOUND IT <b><times 'shouted_by'></b><h1> "times!" </h1>

 

[Weasel]

if ($_SESSION['user']['id'] > 8)
{
$query = mysql_query("SELECT id FROM shout WHERE id = '".$_SESSION['user']['id']."' ");
echo "Spoken: <b>".mysql_num_rows($query)."</b> times!";
}

 

[zMagenta]

The script

That was an example of how I want to it to be used? It wouldn't work as it doesn't have the opening PHP tags, nor any PHP getting the data from the tables at the start anyway. How about we leave this thread be?

 

[Sean]

What do you mean if there ID is above 8, the way Wess has written his code, the first 8 users that register will not have a post count, but anyone that registers after that will...

 

[Weasel]

What do you mean if there ID is above 8, the way Wess has written his code, the first 8 users that register will not have a post count, but anyone that registers after that will...

I found it weird to, but if you take it literally thats what he wanted.

 

[zMagenta]

I found it weird to, but if you take it literally thats what he wanted.

That is exactly what I wanted, ignore the reasons behind it.

 

[Sean]

That is exactly what I wanted, ignore the reasons behind it.

Well if that's what you want you may want to use MySQLi :

if ($_SESSION['user']['id'] > 8) {
    $id = $_SESSION['user']['id'];
    $result = $mysqli->query("SELECT `id` FROM `shout` WHERE `id` = '{$id}'");
    $count = $result->num_rows;
    echo "Spoken: <b>" . $count . "</b> times!";
    $result->close();
}

 

[Kaz]

Thread closed, by the looks of things the issue has been resolved