Click here to Skip to main content
15,892,737 members
Home / Discussions / Web Development
   

Web Development

 
QuestionWeb Crawlers and User Agents [modified] Pin
Clickok29-Oct-06 16:39
Clickok29-Oct-06 16:39 
AnswerRe: Web Crawlers and User Agents Pin
Daniel Turini29-Oct-06 23:46
Daniel Turini29-Oct-06 23:46 
GeneralRe: Web Crawlers and User Agents Pin
Clickok30-Oct-06 4:57
Clickok30-Oct-06 4:57 
Question40000 Records only, Make my search page work so slow and page is stuck... Pin
Hy Chanhan29-Oct-06 15:19
professionalHy Chanhan29-Oct-06 15:19 
AnswerRe: 40000 Records only, Make my search page work so slow and page is stuck... Pin
Christian Graus29-Oct-06 15:42
protectorChristian Graus29-Oct-06 15:42 
AnswerRe: 40000 Records only, Make my search page work so slow and page is stuck... Pin
alex.barylski29-Oct-06 16:55
alex.barylski29-Oct-06 16:55 
GeneralRe: 40000 Records only, Make my search page work so slow and page is stuck... Pin
Hy Chanhan29-Oct-06 17:26
professionalHy Chanhan29-Oct-06 17:26 
GeneralRe: 40000 Records only, Make my search page work so slow and page is stuck... Pin
Hy Chanhan29-Oct-06 17:40
professionalHy Chanhan29-Oct-06 17:40 
Statement below make my search so slow:

$sWhere = "c.zipcode =". $searchresultstr;
$sWhere = " WHERE (" . $sWhere . ")";
$sWherePlus="AND (p.isbrand=True) AND (p.category_id=1 OR p.category_id=3 OR p.category_id=5 OR p.category_id=6 OR p.category_id=8 OR p.category_id=9 OR p.category_id=13 OR p.category_id=25 OR p.category_id=36)";


$sql_ads="SELECT DISTINCT t.contact_id as t_contact_id FROM `osb_contacts` AS `t`
Inner Join `osb_companies` AS `c` ON `t`.`company_id` = `c`.`company_id`
Inner Join `osb_products` AS `p` ON `t`.`company_id` = `p`.`company_id` WHERE ((POW((69.1*(c.longitude-\"$lon\")*cos($lat/57.3)),\"2\")+POW((69.1*(c.latitude-\"$lat\")),\"2\"))<($radius*$radius)) $sWherePlus";

$sSQL1="SELECT DISTINCT p.brand_sub_id as p_brand_sub_id FROM (osb_companies c INNER JOIN osb_company_info_details cd ON c.company_id = cd.company_id) INNER JOIN osb_products p ON cd.brand_sub_id = p.brand_sub_id WHERE ((POW((69.1*(c.longitude-\"$lon\")*cos($lat/57.3)),\"2\")+POW((69.1*(c.latitude-\"$lat\")),\"2\"))<($radius*$radius) $sWherePlus)";

------------------------------------------
The idea that i want:

if p.category_id=1 or p.category_id=8 then $radius=50

the other else $radius=1000

Can i use condition if in Where statement of MySQL and Can i set Variable of PHP
in Where Statement of MySQL

Please help me
Questionasynchronous update of web control on mobile phone - NOKIA E61 Pin
AxeLin29-Oct-06 10:56
AxeLin29-Oct-06 10:56 
AnswerRe: asynchronous update of web control on mobile phone - NOKIA E61 Pin
Guffa29-Oct-06 12:46
Guffa29-Oct-06 12:46 
QuestionVirtual Application Pool Crashes Pin
happyheartcs28-Oct-06 23:42
happyheartcs28-Oct-06 23:42 
QuestionHow to get the page event which indicates that a page is shown to the interface? Pin
Lior S28-Oct-06 22:49
Lior S28-Oct-06 22:49 
AnswerRe: How to get the page event which indicates that a page is shown to the interface? Pin
Bradml28-Oct-06 23:45
Bradml28-Oct-06 23:45 
GeneralRe: How to get the page event which indicates that a page is shown to the interface? Pin
Lior S30-Oct-06 1:53
Lior S30-Oct-06 1:53 
Questionmake your home page [modified] Pin
militiaware28-Oct-06 20:36
militiaware28-Oct-06 20:36 
AnswerRe: make your home page Pin
UltraCoder29-Oct-06 10:42
UltraCoder29-Oct-06 10:42 
Questionthreading in ASP .NET with AJAX Pin
mmiesi28-Oct-06 3:42
mmiesi28-Oct-06 3:42 
AnswerRe: threading in ASP .NET with AJAX Pin
Guffa28-Oct-06 4:40
Guffa28-Oct-06 4:40 
GeneralRe: threading in ASP .NET with AJAX Pin
mmiesi30-Oct-06 5:52
mmiesi30-Oct-06 5:52 
GeneralRe: threading in ASP .NET with AJAX Pin
led mike30-Oct-06 6:25
led mike30-Oct-06 6:25 
AnswerRe: threading in ASP .NET with AJAX Pin
Guffa30-Oct-06 6:38
Guffa30-Oct-06 6:38 
QuestionAni_SE Do you have a question ... Pin
User 171649227-Oct-06 1:53
professionalUser 171649227-Oct-06 1:53 
AnswerRe: Ani_SE Do you have a question ... Pin
alex.barylski29-Oct-06 16:58
alex.barylski29-Oct-06 16:58 
QuestionArchitecture issue (IIS and SQL server on same machine?) Pin
harinath26-Oct-06 4:52
professionalharinath26-Oct-06 4:52 
AnswerRe: Architecture issue (IIS and SQL server on same machine?) Pin
Bradml27-Oct-06 0:46
Bradml27-Oct-06 0:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.