Now that I'm not getting an invalid error message any
longer, how can I get it to echo the sql statement ?
Stuart
--- Micah Stevens <[EMAIL PROTECTED]> wrote:
>
> I understand your intent, but that is not really
> what is happening. The code
> changes I suggested did two things:
>
> 1) Echo's the error statement that mysql produces
>
> 2) Echo's the actual SQL statement that is sent to
> the DB
>
> you should be looking at #2 for answers, not your
> intended query. This
> 'actual' query is what I'm referring to.
>
> -Micah
>
> On Friday 10 September 2004 10:46 am, Stuart
> Felenstein wrote:
> > I think maybe there is an implied where in the
> > generated code, but not in my statement. I'm
> saying
> > when I chose "ACCFIN" (as in the referred error
> > message), the join should be looking at the
> referred
> > table , value ACCFIN . e.g. Code_Table.CodeID
> > (ACCFIN) = MAIN_Table.CodeID (ACCFIN) return
> label.
> >
> > Here is the code, and I honestly am not trying to
> > argue , just understand. Apologies if I'm
> belabouring
> > the point.
> >
> > <?php
> > require('LFW3_connection.php');
> > require('qs_functions.php');
> > @session_start();
> > $err_string = "";
> > $strkeyword = "";
> > $sql = "";
> > $sql_ext = "";
> > $fields = array();
> > $fields[0] = "JobID";
> > $fields[1] = "CompanyName";
> > $fields[2] = "CareerCategories";
> > $fields[3] = "City";
> > $fields[4] = "States";
> > $fields[5] = "AreaCode";
> > $fields[6] = "TaxTerm";
> > $fields[7] = "PayRate";
> > $fields[8] = "TravelReq";
> > $fields[9] = "Details";
> > $fields[10] = "PostStart";
> > $fields[11] = "JobTitle";
> > $arryitemvalue = array();
> > $arryitemvalue[0] = "";
> > $arryitemvalue[1] = "";
> > $arryitemvalue[2] = "";
> > $arryitemvalue[3] = "";
> > $arryitemvalue[4] = "";
> > $arryitemvalue[5] = "";
> > $arryitemvalue[6] = "";
> > $arryitemvalue[7] = "";
> > $arryitemvalue[8] = "";
> > $arryitemvalue[9] = "";
> > $arryitemvalue[10] = "";
> > $arryitemvalue[11] = "";
> > $arryopt = array();
> > $arryopt[0] = "";
> > $arryopt[1] = "";
> > $arryopt[2] = "";
> > $arryopt[3] = "";
> > $arryopt[4] = "";
> > $arryopt[5] = "";
> > $arryopt[6] = "";
> > $arryopt[7] = "";
> > $arryopt[8] = "";
> > $arryopt[9] = "";
> > $arryopt[10] = "";
> > $arryopt[11] = "";
> > $sql .= " SELECT ";
> > $sql .= " VendorJobs.JobID,";
> > $sql .= " VendorSignUp.CompanyName,";
> > $sql .= " StaIndTypes.CareerCategories,";
> > $sql .= " StaUSCities.City,";
> > $sql .= " USStates.States,";
> > $sql .= " VendorJobs.AreaCode,";
> > $sql .= " staTaxTerm.TaxTerm,";
> > $sql .= " VendorJobs.PayRate,";
> > $sql .= " staTravelReq.TravelReq,";
> > $sql .= " VendorJobDetails.Details,";
> > $sql .= " VendorJobs.PostStart,";
> > $sql .= " VendorJobs.JobTitle";
> > $sql .= " FROM";
> > $sql .= " VendorJobs";
> > $sql .= " INNER JOIN VendorSignUp ON
> > (VendorJobs.VendorID = VendorSignUp.VendorID)";
> > $sql .= " INNER JOIN StaIndTypes ON
> > (VendorJobs.Industry = StaIndTypes.CareerIDs)";
> > $sql .= " LEFT OUTER JOIN StaUSCities ON
> > (VendorJobs.LocationCity = StaUSCities.CityID)";
> > $sql .= " LEFT OUTER JOIN USStates ON
> > (VendorJobs.LocationState = USStates.StateID)";
> > $sql .= " LEFT OUTER JOIN staTaxTerm ON
> > (VendorJobs.TaxTerm = staTaxTerm.TaxTermID)";
> > $sql .= " INNER JOIN staTravelReq ON
> > (VendorJobs.TravelReq =
> staTravelReq.TravelReqID)";
> > $sql .= " INNER JOIN VendorJobDetails ON
> > (VendorJobs.JobID = VendorJobDetails.JobID)";
> >
> >
> > $result = mysql_query($sql . " " . $sql_ext . "
> limit
> > 0,1") or
> > die(mysql_error()."<br>".$sql." ".$sql_ext . "
> limit
> > 0,1<br>");
> > if (isset($_POST["QS_Submit"])) {
> > $filter_string = "";
> > $qry_string = "";
> > $i = 0;
> > while ($i < mysql_num_fields($result)) {
> > $meta = mysql_fetch_field($result);
> > $field_name = $meta->name;
> > $field_type = $meta->type;
> > if ((qsrequest("search_fd" . $i) != "") &&
> > (qsrequest("search_fd" . $i) != "*")) {
> > $idata = qsrequest("search_fd" . $i);
> > if (strlen($idata) > 1) {
> > if ($idata[strlen($idata) - 1] ==
> "*")
> > {
> > $idata = substr($idata, 0,
> > strlen($idata) - 1);
> > }
> > }
> > $idata = str_replace("*", "%",
> $idata);
> > $irealdata = $idata;
> > if (qsrequest("search_optfd".$i) !=
> "") {
> > $idata = qsrequest("search_optfd".
> $i) .
> > $idata ;
> > }
> > $iopt = substr($idata, 0, 2);
> > if (($iopt == "<=") || ($iopt ==
> "=<")) {
> > $iopt = "<=";
> > $irealdata = substr($idata, 2);
> > } elseif (($iopt == ">=") || ($iopt ==
> > "=>")) {
> > $iopt = ">=";
> > $irealdata = substr($idata, 2);
> > } elseif ($iopt == "==") {
> > $iopt = "=";
> > $irealdata = substr($idata, 2);
> > } elseif ($iopt == "<>") {
> > $irealdata = substr($idata, 2);
> > } elseif ($iopt == "^^") {
> > $iopt = "*";
> > $idata = $iopt . $irealdata . $iopt;
> //
> > Contain
> > } elseif ($iopt == "^*") {
> > $iopt = "*";
> > $idata = $irealdata . $iopt; //
> Start
> > With
> > } elseif ($iopt == "*^") {
> > $iopt = "*";
> > $idata = $iopt . $irealdata ; // End
> > With
> > } else {
> > $iopt = substr($idata, 0, 1);
> > if (($iopt == "<") || ($iopt ==
> ">")
> >
> > || ($iopt == "=")) {
> >
> > $irealdata = substr($idata,1);
> > } else {
> > $iopt = "=";
> > }
> > }
> > if (!strcasecmp($idata,"{current date and
> > time}")) {
> > $idata = time();
> > } elseif (!strcasecmp($idata,"{current
> > date}")) {
> > $idata = time();
> > } elseif (!strcasecmp($idata,"{current
> > time}")) {
> > $idata = time();
> > }
> > if ($meta) {
> > if ((strtolower($field_type) ==
> > "timestamp")
> >
> > ||(strtolower($field_type) ==
>
=== message truncated ===
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
