Search Results

Search found 2 results on 1 pages for 'praveenmon'.

Page 1/1 | 1 

• finding missing values, mysql??

  - by praveenmon

  i am using mysql database i have a table called sales its primary key is sales_id ------------------------------------- sales_id | invoice_id | ------------------------------------- 1 | 147 2 | 148 3 | 150 for sales-id 3 the invoice is supposed to be 149. i want to know which numbers are missing from invoice_id (i start invoice_id is 147 and end invoice_id is 4497). The invoice_id had no relation with sales_id is it possible to know which numbers are missing from invoice_id, using some queries??

  Read the article

• htaccess querystring based urls

  - by praveenmon

  hi guys, Suppose my website is www.example.com Earlier the urls of my website was like this www.example.com/php/bookdetails.php?bid=33 Last week i changed the urls of my site to this www.example.com/bookdetails/33 and wrote an htacces like this RewriteRule ^bookdetails/(.*)$ php/bookSearchResult.php?bid=$1 The problem is that there are some external site using my earlier URL structure (www.example.com/php/bookdetails.php?bid=33) and what i want is to redirect it to my new URL structure (www.example.com/bookdetails/33). I know it can be possible in htaccess, but i have no idea how to do it

  Read the article

1