0

I have this code for the select and printing values. mysql_numn_rows returns null :/

<?php
mysql_connect('localhost','root','');
mysql_select_db("db2517");



$username = "Cristoforo";
$query = mysql_query("SELECT * users WHERE username='$username' ");

$numberOfRows = mysql_num_rows($query);
echo "num: $numberOfRows";


?>
Cristoforo
  • 17
  • 3

2 Answers2

1

First I would like to suggest you user PDO or MYQLI

In your query you have missed the from so replace your query:

From

$query = mysql_query("SELECT * users WHERE username='$username' ");

To

$query = mysql_query("SELECT * from users WHERE username='$username' ");
mageDev0688
  • 566
  • 4
  • 27
0

Better use mysqli or pdo instead of mysql.here you missed from in your query so your Query should be

$query = mysql_query("SELECT * from users WHERE username='$username' ");
Shanu k k
  • 1,235
  • 2
  • 18
  • 43