How Database from .htaccess to My SQL

Hello Friends

i have database file in .htaccess format i want the convert this file in my sql how is possible please clear to me.

thanks

 

I don't understand.

You have a .sql file? and you wish to insert it into your database?

 

I'm a bit confused as what the .htaccess is doing too here...

can you post up your file so maybe we can understand more?

cheers,

 

What’s connection between .htaccess & sql?
Can you clarify what you want exactly?

 

I think I understand what he means:

Lets assume that he wants http://website.com/php/to entries.php?cat=php

Now, lets assume that the ID of the category PHP is 3, then instead of directing to entries.php?cat=php, he wants to redirect them to entries.php?cat_id=3.

So basically, he may be keen on SQL because thats the only way he can get the ID of that category.

If I am correct in my understanding, I will suggest an workaround to knisar:
Let the PHP script that receives the redirected user do that task.

<?php
$category_slug=mysql_real_escape_string($_GET['cat']);
$sql="SELECT category_id FROM categories_table WHERE category_slug='category_slug'";
$resource=mysql_query($sql);
$category_id=mysql_result($resource,0,'category_id');
//of course you could do it easier using subqueries or joins, but this long-route is just for your understanding!
?>

PHP: