RE: [PHP-DB] Starting to hate MySql... thinking about using MS Sql Server instead...... :-(((((((((

2003-03-30 Thread Joe Keenan
Hi; You could try mysqlimport with the following syntax: mysqlimport -h localhost -u username -p -L dbname pathtofile where' file' is tab delimited text held on local machine. All the best, Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] result set in php pagination

2010-01-23 Thread Joe Keenan
doing to ensure that the result set from the query persists though the change in pagination from the first page of results to the second page. In both cases the search scripts are includes in other php pages. I think I need to understand how the result set is carried through or reacquired in

Re: [PHP-DB] result set in php pagination

2010-01-23 Thread Joe Keenan
in this context is beyond me. Thanks Joe. On 23 Jan 2010, at 19:46, Bastien Koert wrote: The easiest thing to do is either A) store the author name in a session for the duration of the searches B) add the name to the pagination url so that its passed along withe the page number On 1/23/10, Joe Ke

Re: [PHP-DB] result set in php pagination

2010-01-23 Thread Joe Keenan
;; } else { $next = ' [Next] '; // we're on the last page, don't enable 'next' link $last = ' [Last Page] '; // nor 'last page' link } echo $first . $prev . " Showing page $pageNum of $maxPage pages " . $next . $last; ec

Re: [PHP-DB] result set in php pagination

2010-01-23 Thread Joe Keenan
k it up and use it. also, in our link example in an earlier message: http://...results_1.php?currentpage=2&&author_name=Editorial you show two ampersands before "author_name". there should only be one. also, if your author's name includes a space, you'll need to deal with that.

Re: [PHP-DB] result set in php pagination

2010-01-23 Thread Joe Keenan
= $_REQUEST["author_name"];' Should fix that issue Bastien Sent from my iPod On Jan 23, 2010, at 4:26 PM, Joe Keenan wrote: This is all that results from the included script on the 2nd display page: Articles by (There are 0 articles in the database.) Nexta> >>