some small sql help

Gandhi · 01-07-2007, 09:34 PM

Well just started www.templatesurge.com and as you will notice at top right under the big banner you will see

Quote:

Total Templates: 31 Total Downloads: 18 Total Tutorials: 17 Users Online: 1 user online

What I want is for the Total Templates, Downloads, to update by it self, by getting the info from the sql db. Anyone know how to do this, I was told that it was easy, but I dont know how to do it.
????: NamePros.com http://www.namepros.com/programming/278437-some-small-sql-help.html

So please if anyone can help it would be appreciated.

**Eric** · 01-07-2007, 10:57 PM

Yes, would be fairly easy.

Would need to know your database structure to give you the exact code for it...

But, let's say your template table was for example:

Code:

CREATE TABLE templates (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
title VARCHAR(255) NOT NULL,
author VARCHAR(255) NOT NULL,
PRIMARY KEY (id)
);

Total templates:
????: NamePros.com http://www.namepros.com/showthread.php?t=278437

PHP Code:

  <?php

 
$query = mysql_query("SELECT COUNT(id) AS tpl_count FROM templates") or die(mysql_error());

$numtemplates = mysql_fetch_assoc($query);

$numtemplates = $numtemplates['tpl_count'];

 
echo $numtemplates;

 
?>

and could be something similar for the others..

Gandhi · 01-07-2007, 11:16 PM

Thanks for the code, really appreciate it

When I enterted the code I got this error

PHP Code:

  Warning: mysql_query() [function.mysql-query]: Access denied for user 'wwwtemp'@'localhost' (using password: NO) in /home2/wwwtemp/public_html/index.php on line 78

????: NamePros.com http://www.namepros.com/showthread.php?t=278437
 
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home2/wwwtemp/public_html/index.php on line 78

Access denied for user 'wwwtemp'@'localhost' (using password: NO)

Peter · 01-08-2007, 03:42 AM

looking at those errors it looks like you are not actually connected to the database yet.

-PS- · 01-08-2007, 04:47 AM

Originally Posted by 2007

Thanks for the code, really appreciate it

????: NamePros.com http://www.namepros.com/showthread.php?t=278437

When I enterted the code I got this error

PHP Code:

  Warning: mysql_query() [function.mysql-query]: Access denied for user 'wwwtemp'@'localhost' (using password: NO) in /home2/wwwtemp/public_html/index.php on line 78

 
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home2/wwwtemp/public_html/index.php on line 78

Access denied for user 'wwwtemp'@'localhost' (using password: NO)

Those errors are saying your trying to connect to the database with out a password, i would suggestion you check the mysql_connect/ mysql_pconnection function to make sure there's a password in there, and if your storing the password in a varible, that the varible is spelt the same in all places (it's a common problem even out experinced dev team at work suffer from .. =) )

chicker · 01-08-2007, 09:33 AM

At this to the top if you do not have a config page,
<?

$dbhost = "localhost"; // database host, most of the time localhost
$dbuser = "username"; // database user
$dbpass = "pass"; // database password
$dbname = "dbname"; // database name

// DO NOT EDIT
mysql_connect("$dbhost","$dbuser","$dbpass");
mysql_select_db("$dbname");

?>

That will connect for you, else do an include once with your php config file

01-07-2007, 10:57 PM	#2 (permalink)
Eric Tech Support Join Date: Mar 2005 Posts: 4,944	Yes, would be fairly easy. Would need to know your database structure to give you the exact code for it... But, let's say your template table was for example: Code: CREATE TABLE templates ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL, author VARCHAR(255) NOT NULL, PRIMARY KEY (id) ); Total templates: ????: NamePros.com http://www.namepros.com/showthread.php?t=278437 PHP Code: `<?php $query = mysql_query("SELECT COUNT(id) AS tpl_count FROM templates") or die(mysql_error()); $numtemplates = mysql_fetch_assoc($query); $numtemplates = $numtemplates['tpl_count']; echo $numtemplates; ?>` and could be something similar for the others..

01-07-2007, 11:16 PM	THREAD STARTER #3 (permalink)
Gandhi Account Suspended Join Date: Jun 2006 Posts: 472	Thanks for the code, really appreciate it When I enterted the code I got this error PHP Code: `Warning: mysql_query() [function.mysql-query]: Access denied for user 'wwwtemp'@'localhost' (using password: NO) in /home2/wwwtemp/public_html/index.php on line 78 ????: NamePros.com http://www.namepros.com/showthread.php?t=278437 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home2/wwwtemp/public_html/index.php on line 78 Access denied for user 'wwwtemp'@'localhost' (using password: NO)`

01-08-2007, 09:33 AM	#6 (permalink)
chicker NamePros Regular Join Date: Jul 2006 Location: England Posts: 721	At this to the top if you do not have a config page, <? $dbhost = "localhost"; // database host, most of the time localhost $dbuser = "username"; // database user $dbpass = "pass"; // database password $dbname = "dbname"; // database name // DO NOT EDIT mysql_connect("$dbhost","$dbuser","$dbpass"); mysql_select_db("$dbname"); ?> That will connect for you, else do an include once with your php config file __________________ ReallyPay.com - Free online resource site for making money online. Ask About Stuff- Find your questions answer

01-08-2007, 03:42 AM	#4 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,074	looking at those errors it looks like you are not actually connected to the database yet.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)