[SOLVED] Mysql error

[ngreenwood6]

I have the following page:

 

<?php
//include the variables
include("includes/variables.php");

//define the variable from the form
$username = strtolower($_POST['username']);

//connect to the database
$connect = mysql_connect($host,$user,$pass) or die("could not connect");

//select the database
$select_db = mysql_select_db($db);

//query for the database
$query = "SELECT * FROM $table WHERE username = '$username'";

//get the results
$results = mysql_query($query);

//number the rows
$num_rows = mysql_num_rows($results);

if ($num_rows == 1)
{
//put it into an array
$row = mysql_fetch_array($results);
}

//give the username a variable
$row_username = $row['username'];

//if the username is not in the database
if($num_rows < 1)
{
echo "That username is not in the database!";
}


?>

 

Whenever I submit the form I get this error:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\check_user.php on line 21

 

Any ideas why?

[Andy-H]

Is the $table variable defined in variables.php? And is it a valid table name?

[Chicken Little]

Try changing your query from $table to table.

[ngreenwood6]

yeah it is. It looks like:

 

$table = "table";

 

I also tried just putting the table name in there.

[Andy-H]

does variables.php initialise a session?

 

session_start(); ??

[Andy-H]

nvm just saw $username is POST data

[ngreenwood6]

does anyone know what the actual error means?

[AndyB]

Change:

$results = mysql_query($query);

 

to:

$results = mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query;)

 

That should explain what's going on/going wrong.

[Andy-H]

[quote author=AndyB link=topic=219574.msg1006417#msg1006417 date=1223166510]
Change:
[code]$results = mysql_query($query);

 

to:

$results = mysql_query($query) or die("Error: ". mysql_error(). " with query ". $query);

 

That should explain what's going on/going wrong.[/code]

[ngreenwood6]

It is giving me this error now:

 

Error: No database selected with query SELECT * FROM users WHERE username='test'

 

I even tried changing the:

 

$select_db = mysql_select_db($db);

 

to:

 

mysql_select_db("database");

 

Any ideas?

[AndyB]

You need to use the complete/correct name you gave your database. I doubt it's named 'database'

[ngreenwood6]

I am not that dumb I used the database name. I was just using database for the example so you would know that i put the database name in there. Anyways i got it working.