Re: [PHP-DB] What is the most efficient way to store SELECT results

2007-10-08 Thread [EMAIL PROTECTED]
Robert wrote: I want to store the results of a SELECT query in order to be able to page through those results and allow the user to select one, see it in more details and then return to the original list of results. What's the usual technique for doing this? place a get variable after the que

[PHP-DB] What is the most efficient way to store SELECT results

2007-10-08 Thread Robert
I want to store the results of a SELECT query in order to be able to page through those results and allow the user to select one, see it in more details and then return to the original list of results. What's the usual technique for doing this? -- PHP Database Mailing List (http://www.php.net/

Re: [PHP-DB] Prevention for multiple submissions from the same form

2007-10-08 Thread OKi98
TG napsal(a): But what if the data being inserted isn't unique? What if it's a voting form that says "Do you like pie? Yes/No"? True, it could record the response and the userid or IP address so that would be a unique pairing but what if the vote was anonymous and you allowed multiple peop

Re: [PHP-DB] basic form entry

2007-10-08 Thread OKi98
most likely you have a problem in your query but you dont understand how to use mysql_error. from http://www.php.net/manual/en/function.mysql-error.php : string *mysql_error* ( [resource $link_identifier] ) Returns the error text from the last MySQL function echo mysql_error(mysql_connect($ho