mysql num rows

[only one]

heres my code

$checkuser = mysql_query("SELECT username FROM clanapps WHERE username = '$username'");
$username_exist = mysql_num_rows($checkuser);

 

heres the error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/d-pures.freehostia.com/pages/Apply.php on line 9

 

 

[papaface]

How are you connecting to mysql and how are you selecting the db?

[only one]

<?php

if (isset($_POST["clan"])) {

$username = $_POST["user"];

if($clan==NULL) {

echo "A field was left blank.";

}else{

$checkuser = mysql_query("SELECT username FROM clanapps WHERE username='$username'");

$username_exist = mysql_num_rows($checkuser);

 

if ($username_exist>0) {

echo "You have already applied";

}else{

$query = "INSERT INTO clanapps (`username`, `clan`) VALUES('$username','$clan)";

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

echo "you succefully applied for $clan";

}}}

?>

[only one]

it connects further up the page

[papaface]

hmm.

Try:

<?php
if (isset($_POST["clan"])) {
$username = $_POST['user'];
if($clan==NULL) {
echo "A field was left blank.";
}else{
$checkuser = mysql_query("SELECT `username` FROM `clanapps` WHERE `username`='".$username."'");
$username_exist = mysql_num_rows($checkuser);

if ($username_exist>0) {
echo "You have already applied";
}else{
$query = "INSERT INTO clanapps (`username`, `clan`) VALUES('$username','$clan)";
mysql_query($query) or die(mysql_error());
echo "you succefully applied for $clan";
}}}
?>

[jcbarr]

First make sure that you are actually connected to the database, then you might want to make sure that your table and column names match what is actually in the database.

 

Start there and you will soon find the problem I am guessing.

[jcbarr]

You are missing a ' in this line;

 

$query = "INSERT INTO clanapps (`username`, `clan`) VALUES('$username','$clan)";

 

It should look like this;

 

$query = "INSERT INTO clanapps (`username`, `clan`) VALUES('$username','$clan')";

 

It might not be actually inserting the info because of the error in that syntax.

[only one]

its obviously connecting to the database if all the other coides are working, everytime i use the mysql_num_rows() function i always get an error, it seems to work alright on my register page

[only one]

no different

[jcbarr]

What does your table structure look like for the clanapps table?

[only one]

CREATE TABLE `clanapps` (

  `id` int(11) NOT NULL auto_increment,

  `clan` varchar(25) NOT NULL default '',

  `username` varchar(25) NOT NULL default '',

  PRIMARY KEY  (`id`)

 

[only one]

oops just realised, i didnt coppy the full error, if it makes much difference

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/d-pures.freehostia.com/pages/Apply.php on line 9

Unknown column 'username' in 'field list'

[only one]

anyone figure it yet?  ???

[13th_Star]

try this instead:

 

$checkuser = mysql_query("SELECT * FROM `clanapps` WHERE `username` = '$username'");

$username_exist = mysql_num_rows($checkuser);