Curious about "include_once" versus "include". All my connection stuff is in "conn.php3". I am planning on including it at the top of the page like this: include_once "conn.php3"; Now will that speed things up compared to just using a plain "include". I call $connectionSDWIS(which is in the include) 5 different times? $data = odbc_do($connectionSDWIS,"EXEC sp_SanitarySurveyLatest '$pwsno'"); $data = odbc_do($connectionSDWIS, "Select Distinct CASE ActivityStatus WHEN 'A' THEN 'ACTIVE' WHEN 'I' THEN 'INACTIVE' END + ' ' + CASE Convert(varchar,ActDate,107) WHEN 'May 05, 1955' THEN '' ELSE Convert(varchar,ActDate,107) END As 'ActivityStatus' FROM Inventory Where PWSID='$pwsno'"); $data2 = odbc_do($connectionSDWIS,"Exec sp_EntryPointsWithSourcesAndPWS '$pwsno'"); $data=odbc_do($connectionSDWIS,"SELECT StateID, WSFName, TreatmentProcess, TreatmentObjective FROM Treatments WHERE PWS= '$pwsno' ORDER BY StateID"); $data = odbc_do($connectionSDWIS, "SELECT CalendarYear, convert(varchar(12),ReceivedDate, 107), convert(varchar(12),CertifiedDate, 107) FROM CCRS WHERE PWS='$pwsno' ORDER BY CalendarYear Desc"); --------------------------------- Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway - Enter today
