T_variable, improve my syntax!

Dench · #1 28-Feb-2008, 11:09

Ok so here is my code in question:

PHP Code:


/* Check Username */   $result = mysql_query("SELECT * FROM login_table WHERE Username = '$_POST['Username']'");   $num_rows = mysql_num_rows($result);   if ($num_rows = 1)   {     echo "There is already a username with this name"   }   else   {     echo "This username is valid"   }

and im gettin the dreaded unexpected T_variable, im 99% sure this is something to do with my syntax like a bracket of quote mark or something, the error occurs on the $result, any thoughts?

Dench · #2 28-Feb-2008, 11:31

missed some semi-colons nvm!!

TreyAU21 · #3 28-Feb-2008, 11:45

There is another problem that I saw in your code too.

Code:

/* Check Username */   
$result = mysql_query("SELECT * FROM login_table WHERE Username = '$_POST['Username']'");   
$num_rows = mysql_num_rows($result);   

if ($num_rows = 1)   {     
  echo "There is already a username with this name"   
}   
else   {     
  echo "This username is valid"   
}

Besides the missing semicolons, you are also doing an assignment (NOT A COMPARISON) in your if statement. Every time that you run this code, you will enter that if statement because you aren't checking to see if $num_rows is equal to 1... you are SETTING $num_rows equal to 1.

Code:

// This is what you need
if($num_rows == 1)

Dench · #4 28-Feb-2008, 12:25

aye, i made a few mistakes, musn't have had my brain on!! its going ok now!!

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linked Lists advice request	promsan	C Programming Language	74	23-May-2007 08:29
syntax errors in document	coder	MS Visual C++ / MFC Forum	0	11-Mar-2006 04:12
Winsock error when compiling FLTK 2.0 Projects	mauriciorossi	FLTK Forum	3	16-Aug-2005 10:18
Help with syntax errors	PeteGallo	C Programming Language	7	08-Aug-2005 20:30
C++ PhoneBook	marita	CPP / C++ Forum	46	12-Jun-2005 12:10

T_variable, improve my syntax!

Re: T_variable, improve my syntax!!

Re: T_variable, improve my syntax!!

Re: T_variable, improve my syntax!!