How to make your register page work!

[Krov]

so do you know how to take it out? because i do not want to mess it up...Can you show me a way to take it out and leave whats suppose to be in there?

[Tyfix]

Uhm where is this table?

Anyways change your select statement to check for name instead of id.

[Krov]

$check_code_query = "select adm_check from MEMB_INFO WHERE memb___id='$adm_uss' ";
$check_query_result = mssql_query( $check_code_query );
$code_check = mssql_fetch_row( $check_query_result );

$sql_security_check = mssql_query("SELECT security_code FROM MEMB_INFO WHERE security_code='$security' and memb___id='$adm_uss' ");

$security_check = mssql_num_rows($sql_security_check);

Thats the part i'm having problems with...do you know how to fix it? thats my table.. and here what it came out on the website of my MU.

Warning: mssql_query() [function.mssql-query]: message: Syntax error converting the varchar value 'Krov' to a column of data type int. (severity 16) in c:\AppServ\www\modules\loginin.php on line 156

Warning: mssql_query() [function.mssql-query]: Query failed in c:\AppServ\www\modules\loginin.php on line 156

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in c:\AppServ\www\modules\loginin.php on line 157
Error: Only Administrator can do this!

[Tyfix]

Well the thing is i don't recognize any of these databases/tables you are writing about.. Maybe im out of the loop hehe

[Krov]

its from the modules/loginin.php foulder in the apacheserv folder.

[Tyfix]

ohh i see.. I never used it, im using a normal apache version with php but i'll download it and check.

[Krov]

ahh, well if u know anyone that knows how to make it work..let me know please.

[ken8864]

beside, you need to change your default path for extension under php.ini
from "./" to ".\ext"
actually you got to edit the config.php file, 2nd, you need to download a file call
libmssql.dll and put it under your php default folder (e.g c:\php\) inorder to run.

forgive me, i also dont know where can i get the file naamed "libmssql.dll", coz it is not provided by php due to mssql licensing issue.

[john_d]

beside, you need to change your default path for extension under php.ini
from "./" to ".\ext"
actually you got to edit the config.php file, 2nd, you need to download a file call
libmssql.dll and put it under your php default folder (e.g c:\php\) inorder to run.

forgive me, i also dont know where can i get the file naamed "libmssql.dll", coz it is not provided by php due to mssql licensing issue.

that is not a problem...
his problem is SQL based

he is trying to do a

select * from table where INT = 'hello'

well that will never work

[Krov]

I Have no clue what are you talking about, so please can u explain more clearly for me to understand.

[ken8864]

ERROR:
Unable to load dynamic library '.\php_mssql.dll' - The specified procedure could not be found. in Unknown on line 0
may be some one can tell how to solve this problem...

[Krov]

so like nobody would know anything or how to fix that problem?

Warning: mssql_query() [function.mssql-query]: message: Syntax error converting the varchar value 'krov' to a column of data type int. (severity 16) in c:\AppServ\www\modules\loginin.php on line 156

Warning: mssql_query() [function.mssql-query]: Query failed in c:\AppServ\www\modules\loginin.php on line 156

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in c:\AppServ\www\modules\loginin.php on line 157
Error: Only Administrator can do this

Here is the code for that part...

$sql_security_check = mssql_query("SELECT security_code FROM MEMB_INFO WHERE security_code='$security' and memb___id='$adm_uss' ");
$security_check = mssql_num_rows($sql_security_check);

[rzryl2]

Open %windir%\PHP.ini (in most cases C:\WINDOWS\PHP.ini) and Ctrl+F to

;extension=php_mssql.dll

Remove the ; at the start and save the file, then restart Apache.. If you dont know how just reboot ur PC...

[boydverbeek]

yea already found that out and it works now but thnx for reply

[[GR]SiLvER]

PFFFT, if you read the guide carefully you wouldn't get Fatal error: Call to undefined function: mssql_connect() in xxxx, posts like that will be deleted..