调用未定义的函数fetch_row（）

Question

Im connecting to database:

$con=mysql_connect("localhost","root","");
mysql_set_charset('utf8',$con);
mysql_select_db("mydb");

And when I try to get a row using within a for each with this code:

$question = fetch_row("SELECT * FROM `mytable` WHERE PyetjaNr = $i ORDER BY RAND() LIMIT 1 "); 

Im getting this error:

Fatal error: Call to undefined function fetch_row() 

Same code is working in my hosting server (mysql 5.5), but not working in my localhost mysql (5.6),

Is problem to mysql version? can I do anything except upgrading to mysqli?

Answer 1

You may have missed this in the PHP manual (in which case, you should read the manual for functions you use), but the mysql_... functions are deprecated, and will almost certainly not even be in 5.7 when it comes out. They were replaced with the mysqli_... set of functions, so use those instead.

The PHP manual for mysqli::set_charset covers the initial setup you need, and getting data out of your db is then simply a matter of querying it the normal way.

Which usually means making use of prepared statements instead of just building your SQL as a string (because you want to be secure, you don't want to be Bobby Tables)

Wipe what you have now, redo it with mysqli functions. If your problem still exists, at least now you'll have modern code that people can comment on for putting in your question.