Mysql problem

[GlassFish]

Hi
I have problem in my mysql database. I have posted my code below. Please check below

global $mys;
$st = $mys->prepare('SELECT user_name from `user_details` where user_email = ?');
$st->bind_param('s', $var);
$st->execute() or $this->myerror[] = $st->error;
echo $st->affected_rows;

$st->affected_rows returns '-1' which would indicate a error but i dont see why it would error.

[Reegan]

Hi
Surely there is any error in your code. I am not sure how you script works, but I think you should try to print out the $this->myerror array and see if there are any errors in your script and verify what the error was. Besides this I think that sql look fine, that is rest of the program look fine to me. Try the above command and then post back if you have any more problems.

[Zecho]

Hello
you can try the above, optionally even you can try the following part of code

mysqli_stmt->affected_rows does this -

This will return you the number of rows which are affected by insert, delete and update query.
If you like to use the select query, you can use the following

$st->num_rows

Hope this may help you.

[Reegan]

Hi
I think i should start to learn mysql thoroughly now. Even i do not have much experience in mysql. I have decided to start learning mysql thoroughly. Some time you know most of the things, but one simple wrong function spoils the whole code. If you do not learn mysql thoroughly, no use to use the mysql as a database.

[GlassFish]

Hi
This is my modified code, please check. I am not sure this is the way of correct programming. Please check and advice me for the same.

<?php
$mys = new mys("localhost","",,"");
if(mys_connect_errno() > 0)
{
printf("detail: %s.\n", mys_connect_error());
exit();
}
$mys->autocommit(0);
global $mys;
?>

Please help.

[Zecho]

Hi
I think you are using the prepared statements, it would be better if you use

mysqli->affected_rows 
mysqli->affected_rows 
$stmt->affected_rows

Hope this will help you. For any more query do post back.