Open it in excel and save it in csv format. In csv format, fields will be enclosed by double qoutes and separated by commas.
So there wont be any problem in importing the file
Search found 4 matches
- Fri May 16, 2008 1:14 am
- Forum: Databases
- Topic: Having trouble importing a tab delimited file
- Replies: 1
- Views: 489
- Fri May 16, 2008 12:25 am
- Forum: Databases
- Topic: Selecting from 2 MySQL database tables
- Replies: 2
- Views: 550
Re: Selecting from 2 MySQL database tables
In your query, instead of join use left join, as the query listed below $listings_query = mysql_query("SELECT * FROM listings_items AS l [b]LEFT JOIN[/b] listings_customfields AS c ON l.id = c.listingid WHERE l.title rlike '".make_safe($search_keywords)."' or l.code rlike '&qu...
Re: sory by
You can use an if condition in the order by clause, give the largest number in the order by clause
Code: Select all
SELECT *
FROM `events`
WHERE 1
ORDER BY if( `parent_id` =0, 200000 , `parent_id` ) asc
- Tue May 13, 2008 4:32 am
- Forum: Regex
- Topic: Probs with mod_rewrite regex in htaccess file
- Replies: 2
- Views: 813
Re: Probs with mod_rewrite regex in htaccess file
You have given a space in square bracket, I have removed it and added th rewritebase in the code. you also added a slash before actual_url.php. I have removed it RewriteEngine On RewriteBase /myurl-to-display # Rewrite URLs RewriteRule ^([a-z0-9]+)-range\.html$ actual_url.php?var=$1 [NC,L] http:www...