connect to database and count tables

[saltedm8]

Hi, I am in urgent need of some urgent help

 

I need to connect to my database and count the amount of posts by user id 1155 then display the number of posts

 

SELECT * FROM `vbpost` WHERE `userid` =1155 ;

 

I am really sorry to ask such an easy one but I am not confident with php and I need this quite quickly

 

also if anyone knows vbulletin 4, maybe you could include a query to put that number into a users post count ( saltedm8 )

 

table name webproca_vb

 

thank you

[The Little Guy]

SELECT count(*) as total FROM `vbpost` WHERE `userid` =1155 ;

[fRAiLtY-]

SELECT COUNT(*) FROM 'vbpost' WHERE 'userid'=1155;

 

That should display the number of occurences.

[mikosiko]

SELECT COUNT(*) FROM 'vbpost' WHERE 'userid'=1155;

 

That should display the number of occurences.

 

no is not... ' are not the same as `

[saltedm8]

thanks tried

 

<?php
$con = mysql_connect("localhost","xxxxxxxx","xxxxxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$go = 'SELECT count( webproca_vb ) as total FROM `vbpost` WHERE `userid` =1155' ;

$result = mysql_query($go);

echo $result ;

mysql_close($con);
?>

 

just getting a blank page, how can I see the result in number form ? thanks

[The Little Guy]

You need to convert the result to a php array,

 

<?php
$con = mysql_connect("localhost","xxxxxxxx","xxxxxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$go = 'SELECT count( webproca_vb ) as total FROM `vbpost` WHERE `userid` =1155' ;

$result = mysql_query($go);
// Note this line:
$row = mysql_fetch_assoc($result);

echo $row['total'];

mysql_close($con);
?>

[saltedm8]

thank you very much.. why would I get this ?

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/webproca/public_html/aaaaa.php on line 14

 

no results

[The Little Guy]

Change this line:

$result = mysql_query($go);

 

to this:

$result = mysql_query($go)or die(mysql_error());

 

This will tell us what the mysql error is.

[saltedm8]

ahh, no database selected ?

 

how could that be I thought this did that

 

$go = 'SELECT count( webproca_vb ) as total FROM `vbpost` WHERE `userid` =1155' ;

[xyph]

mysql_select_db( 'dbname', $con );

[The Little Guy]

you connected but didn't choose a database to use, like this:

 

$con = mysql_connect("localhost","xxxxxxxx","xxxxxxxx");
mysql_select_db("my_cool_database");

[saltedm8]

I am in debt to everyone who replied, thank you very much,, worked

[xyph]

Debt can be solved by donating to PHPFreaks

[The Little Guy]

Debt can be solved by donating to PHPFreaks

 

You mean to me.