PHP - Mysql Number Of Rows Returned

Say I do a query from a database that only asks for one field in return (which always has a number in it).  How do you write the PHP to take the first number returned and add it to the next number returned  (NOTE:  There may be more than two numbers returned, but for now, I'm always dealing with two)

For example, say I do a query that returns the number 27 first and then the number 10 second.  FYI, these numbers will be available in the variable $diff['result'].  So the code after the query would look something like this, but obviously i'm struggling with the part in comments...

Code: [Select]
if (!$numbers) {
die("Database query failed: " . mysql_error());
} else {
while ($diff = mysql_fetch_array($numbers)) {
//this would bring back 27 first, in the variable $diff['result'] and then on the 2nd loop through, it would bring back 10 in the $diff['result'] variable
                                                                //ultimately, i just want the difference between the numbers (which in the case would be 17).  It's just a simple addition, so Im obviously an idiot because I can't figure out the syntax for adding the first returned number to the next returned number:)



}

}

Hi I wanted to know how once I have selected and echoed the rows from mysql table how can I get it to number those rows that echo?
etc

1.   echo $variable
2.   echo $variable
3.   echo $variable
4.   echo $variable
5.   echo $variable

Any help is appreciated

Hi,

I have a problem regarding counting rows in a mysql table. Here is the code:

Code: [Select]
<?php
require_once('includes/connection.inc.php');
$conn = dbConnect('read');
$check = 'SELECT COUNT(*) FROM images';
$checkRes = $conn->query($check) or die(mysqli_error());
if($checkRes <= 0) { header('Location: empty_blog.php'); // redirect to another page
} else { // do something else... }
?>

The error I'm getting: "Notice: Object of class mysqli_result could not be converted to int in C:\xampp\htdocs\photoblog\index.php on line 6"

Any help is greatly appreciated!

Hey guys was wondering if anyone could modify the code below to have $output = 'yes' if the number of rows equal 10, 20, 30, 40, 50, 60, 70, 80......... etc

$dbhost = '******';
$dbuser = ''******';';
$dbpass = ''******';';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('MYSQL N/A - Please Contact Admin');

$dbname = ''******';';
mysql_select_db($dbname);

$query="SELECT * FROM documentaryinfo";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close($conn);
?>

Thanks
--------------------------------------------------------------------------------------------------------
Watch Free Documentaries Online - The Documentary Database
www.free-documentaries-online.com
--------------------------------------------------------------------------------------------------------

Hi Guys!

Trying to display data in 3 rows horizontally and 25 vertiacally

Code: [Select]
// Print out result
while($row = mysql_fetch_array($result)){
echo "There are ". $row['COUNT(biddersId)'] ." bidders logged.";
echo "<br />";
}



$query = "SELECT * FROM bidders ORDER BY biddersId";

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

echo "<table border='1'>";
echo "<tr> <th>Bidders</th>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
        echo"<font face= \"calibri\" size=\"3\">";
echo $row['biddersId'];
echo "</br>";
        echo "</td><td>";
       

}

echo "</table>";


?>

Folks,

Having trouble here. Forgot how you use the COUNT. Not interested in the num_rows due to it being slow compared to COUNT.

I have users table like this:

id|username|sponsor_username

0|barand|requinix

1|phpsane|alison

2|mickey_mouse|requinix

Now, I want to check if a sponsor username exists or not. Such as does the entry "requinix" exists or not in one of the rows in the "sponsor_username" column.

In our example it does twice and so the variable $sponsor_username_count should hold the value "2". Else hold "0".

I get error:

Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1 

 

My code:

	$stmt_1 = mysqli_prepare($conn,"SELECT COUNT(sponsor_username) from users = ?"); 
            mysqli_stmt_bind_param($stmt_1,'s',$sponsor_username_count); 
            mysqli_stmt_execute($stmt_1); 
            
            //Show error if 'users' tbl was not successfully queried". 
            if (!$stmt_1) 
            { 
                echo "ERROR 1: Sorry! Our system is currently experiencing a problem loading this page!"; 
                exit(); 
            } 
            else 
            { 
                mysqli_stmt_bind_result($stmt_1,$sponsor_username_count);     
                mysqli_stmt_fetch($stmt_1); 
                mysqli_stmt_close($stmt_1); 
                
                //Check if Sponsor Username in Url ($_GET) is already registered or not. If not then show "Invalid Url" or Link message. 
                if ($sponsor_username_count < 1) 
                { 
                    echo "<b>Invalid Url or Link!<br> Invalid Sponsor: \"$sponsor_username\"!</b><?php "; 
                    exit(); 
                } 
            } 
	

I have a html table displaying data from mysql database. I can count rows properly with mysql_num_rows but is there a way to echo which row number it is. What I want to do is count the rows ordered by cities and echo row number. Thanks for any help.

hello, all:

I'm a newbie, and been trying to work out a way so that the results from an array (or mysql recordset for that matter), are nicely aranged in a table. I want them to show in a grid-like manner, with rows and columns added according to number of "items".

I worked out this small code snippet, with a sample array, and for the life of me, cant figure out how to make it so it automatically "breaks" columns at 5 and start new row. I got it to show me right number of rows, but then it repeats all 10 names within them, as opposed to just showing 5 names in each row...

Appreciate the help...

Code: [Select]
<?php
$names = array('Charles','Henry','Manny','Philip','Rose','Evelyn','Peter','Julia','Cary','Sophia');
$numberColumns = 5;
$numberNames = count($names);
$numberRows = ceil($numberNames / $numberColumns);

echo "<table border='1' width='400' cellspacing='0' cellpadding='0'>";

for ($i=1; $i<=$numberRows; $i++)
{ 
echo "<tr>";
foreach ($names as $name)
{
echo "<td>" . $name . "</td>";
}
echo "</tr>"; 
}

echo "</table>";
?>

im wondering how to get php to read the latest row (instead of show them all) and when another one comes it replaces it once the page refreshes

Now he sayes other fold:



Wrong parameter count for mysql_num_rows() in /home/a5078111/public_html/registerpage.html on line 146

How would I make a script that would delete any row in a MySQL table that was more than 7 days old?

Here's the error: Code: [Select]
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/stayway1/public_html/www.one-mafia.com/eng/inboxread.php on line 99
Here's lines 90-110: (99 in bold)

Code: [Select]
if (strip_tags($_POST['Accept_OC'])){
$oc_id=strip_tags($_POST['oc_id']);
if (strip_tags($_POST['place']) == "we"){
$use="we_inv";
$a="we";
$query= "SELECT * FROM oc WHERE we_inv='$username' AND id='$oc_id'";
}elseif (strip_tags($_POST['place']) == "ee"){
$use="ee_inv";
$a="ee";
$query= "SELECT * FROM oc WHERE ee_inv='$username' AND id='$oc_id'";

}elseif (strip_tags($_POST['place']) == "driver"){
$use="driver_inv";
$a="driver";
$query= "SELECT * FROM oc WHERE driver_inv='$username' AND id='$oc_id'";
}

$round=mysql_query($query);
[b]$check=mysql_num_rows($round);[/b]
if ($check != "0"){
echo "You are now in that OC";
mysql_query("UPDATE `oc` SET `$a`='$username' WHERE `id`='$oc_id'");
mysql_query("UPDATE `users` SET `oc`='1' WHERE `username`='$username'");
}
}
if (strip_tags($_POST['Yes_street'])){
$race_id=strip_tags($_POST['race_id']);
if ($fetch->street != "0"){ echo "Your in a race."; }elseif ($fetch->street == "0"){

if ($fetch->last_race >= time()){ echo "You cant do anouther race yet."; }elseif ($fetch->last_race < time()){

I have a HTML dropdown list which is populated from a MySQL table. I use an auto-incremend ID field. I have also got a sort_order field.
 
I would like to be able to specify the exact order that entries should appear in the dropdown list. Specifically I need some functionality that does the following two things:
 
1) If I change the sort order of a record to for example "4" then the existing record with sort_order 4 becomes 5, sort_order 5 becomes 6 and so on.
 
2) If I change the sort order of a record to for example "4" and there is currently no record with sort_order 4, then no other records will be updated.

Ok I am trying to delete some rows from a database. I have done this before with success so I thought I could use the same method just modify it a little and it would work. Man was I wrong. Any help on this is much appreciated below is my code.

Code for the Query to get the data from the database and for displaying the results in a table:
Code: [Select]

//GET DATA
$sql = "SELECT * FROM `".$tblname."` ORDER BY $orderby $sort LIMIT $startrow,$limit";
$result = mysql_query($sql) or die(mysql_error());
$result2 = mysql_query($sql);

//START TABLE AND TABLE HEADER
echo "<form name='form1' method='post' action=''><table style='font-size:9.5px;'>\n<tr><th>Delete</th>";
$array = mysql_fetch_assoc($result);
foreach ($array as $key=>$value) {
if($config['nicefields']){
$field = str_replace("_"," ",$key);
$field = ucwords($field);
}

$field = columnSortArrows($key,$field,$orderby,$sort);
echo "<th>" . $field . "</th>\n";
}
echo "</tr>\n";

//reset result pointer
mysql_data_seek($result,0);

//start first row style
$tr_class = "class='odd'";

//LOOP TABLE ROWS
while($row = mysql_fetch_assoc($result)){


echo "<tr ".$tr_class.">\n<td><a
 href='remove_rec.php?id=". $rows['ID'] . "'><p>Delete</p></a>";
echo "</td>";
foreach ($row as $field=>$value) {
echo "<td>" . $value . "</td>\n";
}
echo "</tr>\n";
//switch row style
if($tr_class == "class='odd'"){
$tr_class = "class='even'";
}else{
$tr_class = "class='odd'";
}

}

//END TABLE
echo "</table>\n</form>";

Here is the code that should delete the row:
Code: [Select]
$tblname = 'tablename';
// get value of id that sent from address bar
$id=$_GET['ID'];

// Delete data in mysql from row that has this id
$sql="DELETE FROM $tblname WHERE ID='$id'";
$result=mysql_query($sql);

// if successfully deleted
if($result){
echo "Deleted Successfully";
echo "<BR>";
echo "<a href='leads3.php'>Back to Results</a>";
}

else {
echo "ERROR";
}

When I click on the link to delete a record it redirects me to the appropriate page with the "Deleted Successfully" message but when I go to view the results the row was not deleted. Any help on this would, again, be greatly appreciated.