Ad:

PHP Discussion Thread
Unsolved
Views: 788

Oct 13th, 2008

PHP Statement ?

Expand Post »

I have a db query, which show datas from mysql database.
I want to do : ıf number of rows from query is bigger than x do something if small do another thing. Namely;

php Syntax (Toggle Plain Text)
$qry = mysql_query("SELECT * FROM data_table WHERE page='$page'",$dbh);
$total = mysql_num_rows($qry);
 
if($total>7)
{
  something...
}
 
else{
  another thing;
}
$qry = mysql_query("SELECT * FROM data_table WHERE page='$page'",$dbh);
$total = mysql_num_rows($qry);

if($total>7)
{
  something...
}

else{
  another thing;
}

but it always going to first statement whatever $total is. I echo the $total. It gives 8.
What is wrong?

Similar Threads

Update entire Mysql DataBase with PhP in PHP
PHP Select Statement in PHP
PHP-Nuke Tutorial #1: Altering the Header Tags in PHP
PHP Beginner Here in PHP
PHP vs. Pearl in PHP

gandil

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jul 2006

Permalink

Oct 13th, 2008

Re: PHP Statement ?

The is equates to

php Syntax (Toggle Plain Text)
if ($total is greater than 7) {
  something...
} else {
  another thing
}
if ($total is greater than 7) {
  something...
} else {
  another thing
}

So when total=8 it will select the first one.

Will Gresham

Reputation Points: 96

Solved Threads: 124

Master Poster

Offline

728 posts
since May 2008

Permalink

Oct 13th, 2008

Re: PHP Statement ?

PHP Syntax (Toggle Plain Text)
if ($total is greater than 7) 
{  
       something...
} 
else 
{  
       another thing
}
if ($total is greater than 7) 
{  
       something...
} 
else 
{  
       another thing
}

I am when total is 1 or 8 whatever is; it is going to same statement. Why?

gandil

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Jul 2006

Permalink

Oct 13th, 2008

Re: PHP Statement ?

Try:

php Syntax (Toggle Plain Text)
if (mysql_num_rows($qry) > 7 ) {
  something...
} else {
 another thing
}
if (mysql_num_rows($qry) > 7 ) {
  something...
} else {
 another thing
}

Will Gresham

Reputation Points: 96

Solved Threads: 124

Master Poster

Offline

728 posts
since May 2008

Permalink

Oct 13th, 2008

Re: PHP Statement ?

Why don't you use COUNT in sql statement instead?

php Syntax (Toggle Plain Text)
$qry = mysql_query("SELECT COUNT(*) FROM data_table WHERE page='$page'",$dbh);
$qry = mysql_query("SELECT COUNT(*) FROM data_table WHERE page='$page'",$dbh);

PoA

Reputation Points: 19

Solved Threads: 9

Posting Whiz in Training

Offline

234 posts
since Jul 2004

Permalink

Oct 14th, 2008

Re: PHP Statement ?

yes , try PoA way like:

php Syntax (Toggle Plain Text)
$seq="select count(*) as cnt fromdata_table WHERE page='$page'";
	$sres=mysql_query($seq);
$srow=mysql_fetch_assoc($sres);	
 
	if($srow['cnt']>7) {
 
		//do something}
else if($srow['cnt']<=7)
	{
//do another thing	
	}
$seq="select count(*) as cnt fromdata_table WHERE page='$page'";
	$sres=mysql_query($seq);
$srow=mysql_fetch_assoc($sres);	
	
	if($srow['cnt']>7) {
	
		//do something}
else if($srow['cnt']<=7)
	{
//do another thing	
	}

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Oct 22nd, 2008

Re: PHP Statement ?

php Syntax (Toggle Plain Text)
$qry = mysql_query("SELECT * FROM data_table WHERE page='$page'",$dbh);
[COLOR="Red"]while($info = mysql_fetch_array( $qry )) {
   $total++;
}[/COLOR]
 
if($total>7)
{
  something...
}
 
else{
  another thing;
}
$qry = mysql_query("SELECT * FROM data_table WHERE page='$page'",$dbh);
[COLOR="Red"]while($info = mysql_fetch_array( $qry )) {
   $total++;
}[/COLOR]

if($total>7)
{
  something...
}

else{
  another thing;
}

Try this.
i think mysql_num_rows(); will counting all the rows in the table.

but it always going to first statement whatever $total is. I echo the $total. It gives 8.
What is wrong?[/QUOTE]

danishbacker

Reputation Points: 10

Solved Threads: 7

Junior Poster in Training

Offline

97 posts
since Apr 2008

Permalink

Oct 22nd, 2008

Re: PHP Statement ?

Using the COUNT(*) query by PoA or mysql_num_rows on your query will return the same value.

jt1

Reputation Points: 13

Solved Threads: 3

Newbie Poster

Offline

19 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Parse error: parse error, unexpected '['

Next Thread in PHP Forum Timeline: PHP Snippets

DaniWeb Message

Cancel Changes

User Name
Password