Number Of Rows In MySQL

buddybuddha · 08-24-2005, 05:33 PM

Alright, I have no experience with MySQL, but if someone could guide me with tis one thing I need te do, that would be sweet.

I have a database named buddybud_nugget with a user of the same name. Inside, there is a table plog_blogs with a given number of rows. How can I use PHP to determine the number of rows in the table and then use that number as a a variable?

15 NP$ to whoever can tell me to my satisfaction.

iNod · 08-24-2005, 05:41 PM

PHP Code:

  <?php

????: NamePros.com http://www.namepros.com/programming/118278-number-of-rows-in-mysql.html
//Do all connect stuff up here

 
//Do sqlquery and get variable num

$sqlquery = mysql_query("SELECT * FROM blah");

$num = mysql_num_rows($sqlquery);

 
print "There is $num rows in blah";

?>

There yah go

buddybuddha · 08-24-2005, 05:45 PM

But what code do I need to use for the connections. Ive barely even seen code for a mysql query.

iNod · 08-24-2005, 05:50 PM

Here

PHP Code:

  <?php

/* Set mysql variables */

$db_host = "localhost"; //Leave localhost

$db_user = "inod"; //DB username

$db_name = "inod"; //DB Name

$db_pass = "pass"; //DB User password

 
$connect = mysql_connect("$db_host","$db_user","$db_pass") or die(mysql_error());

$select_db = mysql_select_db("$db_name");

 
//Do sqlquery and get variable num

$sqlquery = mysql_query("SELECT * FROM field_name");

????: NamePros.com http://www.namepros.com/showthread.php?t=118278
$num = mysql_num_rows($sqlquery);

 
print "There is $num rows in blah"; 

 
?>

There..

buddybuddha · 08-24-2005, 05:53 PM

15 NP$ your way!

iNod · 08-24-2005, 05:54 PM

Received.. Thanks dude.. If you need any more help just pm me.. I would love to give you any kind of assistance you may need.

iNod

08-24-2005, 05:33 PM	THREAD STARTER #1 (permalink)
buddybuddha NamePros Regular Join Date: May 2005 Location: PA Posts: 216	Number Of Rows In MySQL Alright, I have no experience with MySQL, but if someone could guide me with tis one thing I need te do, that would be sweet. I have a database named buddybud_nugget with a user of the same name. Inside, there is a table plog_blogs with a given number of rows. How can I use PHP to determine the number of rows in the table and then use that number as a a variable? 15 NP$ to whoever can tell me to my satisfaction. __________________ The Kevin Dolan Design By Dolan Genetic Programming Source EuroToDollar: Forex Basics

08-24-2005, 05:41 PM	#2 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,272	PHP Code: `<?php ????: NamePros.com http://www.namepros.com/programming/118278-number-of-rows-in-mysql.html //Do all connect stuff up here //Do sqlquery and get variable num $sqlquery = mysql_query("SELECT * FROM blah"); $num = mysql_num_rows($sqlquery); print "There is $num rows in blah"; ?>` There yah go __________________ I feel old.

08-24-2005, 05:45 PM	THREAD STARTER #3 (permalink)
buddybuddha NamePros Regular Join Date: May 2005 Location: PA Posts: 216	But what code do I need to use for the connections. Ive barely even seen code for a mysql query. __________________ The Kevin Dolan Design By Dolan Genetic Programming Source EuroToDollar: Forex Basics

08-24-2005, 05:50 PM	#4 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,272	Here PHP Code: <?php /* Set mysql variables / $db_host = "localhost"; //Leave localhost $db_user = "inod"; //DB username $db_name = "inod"; //DB Name $db_pass = "pass"; //DB User password $connect = mysql_connect("$db_host","$db_user","$db_pass") or die(mysql_error()); $select_db = mysql_select_db("$db_name"); //Do sqlquery and get variable num $sqlquery = mysql_query("SELECT FROM field_name"); ????: NamePros.com http://www.namepros.com/showthread.php?t=118278 $num = mysql_num_rows($sqlquery); print "There is $num rows in blah"; ?> There.. __________________ I feel old.

08-24-2005, 05:53 PM	THREAD STARTER #5 (permalink)
buddybuddha NamePros Regular Join Date: May 2005 Location: PA Posts: 216	15 NP$ your way! __________________ The Kevin Dolan Design By Dolan Genetic Programming Source EuroToDollar: Forex Basics

08-24-2005, 05:54 PM	#6 (permalink)
iNod Eating Pie Join Date: Nov 2004 Location: Canada Posts: 2,272	Received.. Thanks dude.. If you need any more help just pm me.. I would love to give you any kind of assistance you may need. iNod __________________ I feel old.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 10:46 PM
updating multiple rows at a time (Mysql)	Outer	Programming	2	02-10-2005 08:26 AM
appraise please	Complete Hostings	Domain Appraisals	2	01-19-2005 04:03 PM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 02:17 PM