PHP - Counting Num_rows After Select For Login

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(); 
                } 
            } 
	

Hi,

I have a database with roughly 73k rows (records).  I am using a query string such as:
SELECT DISTINCT Column FROM databasename

I am then using mysql_num_rows($results) to count the number of distinct rows.  This method works, but it is slow.

Is there a faster way of doing this perhaps internal to the mysql without having to send the entire results to the PHP when I only need a count?

Hey there. Not sure how to word this. I've been flying blind as a newbie trying to figure out some pagination for a left joined query. I've got syntax errors trying to set up the SELECT COUNT function that adds up the results of the search on a previous page so it knows how many results matched both tables.

Right now, I've got this mess, and it's giving me a syntax error,
"You have an error in your SQL syntax; .... near 'LEFT JOIN plantae ON (descriptors.plant_id = plantae.pla' at line 12"
Code: [Select]
$data = "Select (SELECT COUNT(*)
                    FROM
                        descriptors
                    ) AS
                        count1,
                (SELECT COUNT(*)
                    FROM
                         plantae
                    ) AS
                        count2

                    LEFT JOIN
                        plantae ON (descriptors.plant_id = plantae.plant_name)
                    WHERE
                        `leaf_shape` LIKE '%$select1%'
                        AND `leaf_venation` LIKE '%$select3%'
                        AND `leaf_margin` LIKE '%$select4%'";
                   
 
$result = mysql_query ($data);
if (!$result) {
    die("Oops, my query failed.  The query is: <br>$data<br>The error is:<br>".mysql_error());
}

ok really simple question.  I'm going blind staring at this code so can someone please help.  All I want to do is echo the number of rows in a table.  Here is the code
<?php

$qCheckFirstLog = "SELECT * FROM logindetails WHERE email = '".$_SESSION['email']."'";
$rCheckFirstLog = mysql_query($qCheckFirstLog);
$num_rows = mysql_num_rows($rCheckFirstLog);

?>
Now there are 15 records with the session emails name in the table.  I know the session email is there as it echos an email if I ask it too so thats not missing but when I put
<?php echo $num_rows; ?>

I get nothing!!!!!!

Can someone please tell me what I'm doing wrong

Thank you

I have a table and the following code. Im not sure if im using rownum in the correct way as im not getting the result expected.

$result = mysql_query("SELECT * FROM totem_ads");
$num_rows = mysql_num_rows($result);
$random_row = rand(1, $num_rows);

$ad_sql = mysql_query("SELECT * FROM totem_ads WHERE rownum='$random_row'");
while($row_advert = mysql_fetch_array($ad_sql))

{

echo "<a href='" . $row_advert['link'] . "'><img src=$img_loc'" . $row_advert['image'] . "' alt='" . $alt_text['image'] . "'></a>";

}

THe ad_sql displays as expected SELECT * FROM totem_ads WHERE rownum='1' however the while loop displays nothing which makes me wonder if im using rownum incorrectly. When i search for information on rownum I find all kinds of confusin statements from people posting in forums with problems and not the correct answer im looking for.