mysql_row_seek()

[jpeg]

Can someone please tell me why I'm getting "Call to undefined function" when using mysql_store_results() and mysql_row_seek()?

mysql doesn't seem to understand these functions exist?

Thanks::confused:

[raf]

This tells you all about it.

http://www.mysql.com/doc/en/mysql_store_result.html
http://www.mysql.com/doc/en/mysql_row_seek.html

or just let us kb-now what other info you need.

[jpeg]

Thank you RAF for the links, but it seems that the problem goes a little beyond that. It seems that when I use the code below, mysql returns an error message stating "Call to undefined function".

Also, the editor I am using (Homesite) doesn't seem to understand this function either. I am kind of new to sql, but I do have a programming background and I can't understand why this function is not identified in mysql. The mysql version I am using is 3.23.54, which I would think is sufficient.

What could I be doing wrong? It also doesn't understand the function mysql_row_seek().

$Results=mysql_query("SELECT Name, City, State FROM Remember") or die ("Cannot access table");

mysql_store_result($Results);

Any help you can give would be greatly appreciated.

(Bet it's something really simple :)

Thanks

[raf]

Now, this is not a MySQL problem. It's a PHP 'problem', so there will probably better help in that forum. (you call these as PHP functions, but they are not)

I'll have a shot at it anyway:

mysql_store_result
as far as i know, this is not a function. Its a mode on the mysql_query() function This is the defaultmode and means that results are buffered. so it should be inside the mysql_query function and not as a separate statament. If you just drop that line, you'll probably get what you want. (if you use defaultsettings) I guess you're right: it's something really simple.

mysql_row_seek
info from link is quite straightforward.

But it's probably not what you need. My best geuss is you're trying to using PHP to select a record from a recordset.
If so, check out the msql_data_seek() and msql_fetch_row() or msql_fetch_array() functions.

If you need more info, search for these function( or others that deliver what you need) on the php site
http://www.php.net/