Re: Please help

As I said this is a code generator (dbqwiksite). So, describing the process for creating the code is different. The $sql is fine, as far as typos or incorrect characterrs. I've gone through those statement very carefully. I've also tried to run a debug with no luck. But I do know that there is something wrong with the statement, since I can get a complete display of all records, but can't search using criteria. Below is the $sql, one I know works , though I've tried others. VendorJobs is the table I'm querying , and since it's made up of values from other static type tables I have all the joins in place. I've also taken the tick marks out, thinking maybe it was a style issue. I'm not sure where to go with it. Getting a response from the company is like pretty difficult. VendorJobs.JobID, VendorSignUp.CompanyName, StaIndTypes.CareerCategories, StaUSCities.City, USStates.States, VendorJobs.AreaCode, staTaxTerm.TaxTerm, VendorJobs.PayRate, staTravelReq.TravelReq, VendorJobDetails.Details, VendorJobs.PostStart, VendorJobs.JobTitle FROM VendorJobs INNER JOIN VendorSignUp ON (VendorJobs.VendorID = VendorSignUp.VendorID) INNER JOIN StaIndTypes ON (VendorJobs.Industry = StaIndTypes.CareerIDs) LEFT OUTER JOIN StaUSCities ON (VendorJobs.LocationCity = StaUSCities.CityID) LEFT OUTER JOIN USStates ON (VendorJobs.LocationState = USStates.StateID) LEFT OUTER JOIN staTaxTerm ON (VendorJobs.TaxTerm = staTaxTerm.TaxTermID) INNER JOIN staTravelReq ON (VendorJobs.TravelReq = staTravelReq.TravelReqID) INNER JOIN VendorJobDetails ON (VendorJobs.JobID = VendorJobDetails.JobID) Stuart --- Philip Thompson <prthomp@uark.edu> wrote: > I think everyone knows that $sql is a statement. But > what people are > asking is: what is that statement?! Because if there > are "incorrect" > characters or 's in that statement, then that can > break your > code/statement. > > ~Philip > > On Sep 9, 2004, at 5:49 PM, Stuart Felenstein wrote: > > > Just getting back to this thing. There are 3 > files > > involved, search.php, connections.php and > > functions.php. > > > > I searched through all and couldn't find the > meaning > > of the $sql_ext. $sql is just the sql statement > I > > inserted into the code. > > > > Great that I can't get a response from the > company. > > If anyone thinks it would be useful to post the > code I > > will. That is if anyone would want to see and look > at > > it. > > > > The weird thing is searching on one table is > great. > > The list (all records) works great. The problem > > starts when I insert all my joins. Now I've > tested > > and retested the query and I know it's fine. > > > > Thank you , > > Stuart > > > > > > --- Steve Davies <steve@sdconsulting.co.uk> wrote: > > > >> What's contained in $sql and $sql_ext ??? > >> > >> > >> Stuart Felenstein wrote: > >> > >>> I'm using a product called dbqwiksite pro. PHP > >>> generator for PHP - MySQL > >>> > >>> The code seems to be working fine except in my > >> search > >>> page where I receive an "invalid query" > >>> > >>> $result = mysql_query($sql . " " . $sql_ext . " > >> limit > >>> 0,1") > >>> or die("Invalid query"); > >>> > >>> This is the place I where the code is taking the > >> die > >>> path. > >>> I'm guessing something belongs between the > >> quotation > >>> marks , just not sure. > >>> > >>> Anyone ? > >>> > >>> Thank you > >>> Stuart > >>> > >>> > >>> > >> > >> -- > >> PHP Database Mailing List (http://www.php.net/) > >> To unsubscribe, visit: > http://www.php.net/unsub.php > >> > >> > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: > http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >