Ask a Question related to Macromedia Exchange Dreamweaver Extensions, Design and Development.
-
phpStumped #1
DATAASSIST extension help needed
I am using the Data Assist extension and need some help.
I am trying to do a search that looks at 2 columns.
Can anyone tell me why this script returns all records?
<?php
$maxRows_WADAALFL = 20;
$pageNum_WADAALFL = 0;
if (isset($_GET['pageNum_WADAALFL'])) {
$pageNum_WADAALFL = $_GET['pageNum_WADAALFL'];
}
$startRow_WADAALFL = $pageNum_WADAALFL * $maxRows_WADAALFL;
$ParamvisitorTeam_WADAALFL = "-1";
if (isset($_GET['S_homeTeam'])) {
$ParamvisitorTeam_WADAALFL = (get_magic_quotes_gpc()) ? $_GET['S_homeTeam']
: addslashes($_GET['S_homeTeam']);
}
$ParamhomeTeam_WADAALFL = "-1";
if (isset($_GET['S_homeTeam'])) {
$ParamhomeTeam_WADAALFL = (get_magic_quotes_gpc()) ? $_GET['S_homeTeam'] :
addslashes($_GET['S_homeTeam']);
}
$Paramrainout_WADAALFL = "0";
if (isset($_GET['S_rainout'])) {
$Paramrainout_WADAALFL = (get_magic_quotes_gpc()) ? $_GET['S_rainout'] :
addslashes($_GET['S_rainout']);
}
mysql_select_db($database_schedule, $schedule);
$query_WADAALFL = sprintf("SELECT * FROM ALFL WHERE (visitorTeam LIKE '%%%s%%'
OR '-1' = '%s') OR (homeTeam LIKE '%%%s%%' OR '-1' = '%s') OR (rainout = %s OR
'0' = '%s') ORDER BY ID ASC",
$ParamvisitorTeam_WADAALFL,$ParamvisitorTeam_WADAA LFL,$ParamhomeTeam_WADAALFL,$P
aramhomeTeam_WADAALFL,$Paramrainout_WADAALFL,$Para mrainout_WADAALFL);
$query_limit_WADAALFL = sprintf("%s LIMIT %d, %d", $query_WADAALFL,
$startRow_WADAALFL, $maxRows_WADAALFL);
$WADAALFL = mysql_query($query_limit_WADAALFL, $schedule) or
die(mysql_error());
$row_WADAALFL = mysql_fetch_assoc($WADAALFL);
if (isset($_GET['totalRows_WADAALFL'])) {
$totalRows_WADAALFL = $_GET['totalRows_WADAALFL'];
} else {
$all_WADAALFL = mysql_query($query_WADAALFL);
$totalRows_WADAALFL = mysql_num_rows($all_WADAALFL);
}
$totalPages_WADAALFL = ceil($totalRows_WADAALFL/$maxRows_WADAALFL)-1;
?>
phpStumped Guest
-
Hi-Lite Data Extension Needed
I am creating a web site that has a page which list an event, the person speaking at the event, the date of the event and a link to a PDF of the... -
What type o Extension is needed?
Hi Everyone - was wondering if someone can point me in the right direction. I am a coder but am trying to make a 'easy front end' for designers and... -
dreamweaver mx to 8 extension help needed
I recently went from dreamweaver mx to dreamweaver 8 and I'm having some trouble with an extension I use to use. The extension I'm talking about is... -
Drop Down Menu Extension Needed for DW8/Mac
I am looking for an extension that does a nice job of a number of drop down menus for DW 8. Being originally a CyberStudio user (now GoLive), I... -
Extension Help needed
Hey all, I am moving forward in my dreamweaver arsenal and attempting to build a E-Commerce site useing an extension. I am looking at 3 different... -
WebAssist #2
Re: DATAASSIST extension help needed
This is a question for the WebAssist forum. Go here:
[url]http://www.webassist.com:8119/[/url] and see if anyone else has had a similar
question.
If not, post your question there and you are very likely to get a helpful
response.
WebAssist Guest
-
twocans #3
Re: DATAASSIST extension help needed
haha
"WebAssist" <webforumsuser@macromedia.com> wrote in message
news:fpfal5$5d0$1@forums.macromedia.com...> This is a question for the WebAssist forum. Go here:
> [url]http://www.webassist.com:8119/[/url] and see if anyone else has had a similar
> question.
> If not, post your question there and you are very likely to get a helpful
> response.
>
twocans Guest



Reply With Quote

