Search found 4 matches

by rvijay_eee
Fri May 16, 2008 1:14 am
Forum: Databases
Topic: Having trouble importing a tab delimited file
Replies: 1
Views: 489

Re: Having trouble importing a tab delimited file

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
by rvijay_eee
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...
by rvijay_eee
Fri May 16, 2008 12:04 am
Forum: Databases
Topic: sory by
Replies: 3
Views: 590

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
 
by rvijay_eee
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...