WHERE columname LIKE condition ^^^ example. On Friday 10 September 2004 10:22 am, Stuart Felenstein wrote: > Okay, I was under the impression that "where" is > implied inthe joins xx.xx = xx.xx . Is that not the > case ? > As a matter of fact, there isn't even a where or like > in my query. Then again myabe that's why I can see > *all* records but not run a search. > > Can you please provide an exmample of the column name > bteween where and like ? > > Thank you. > Stuart > > --- Micah Stevens <micah@xxxxxxxxxxxxxxxxxx> wrote: > > If you look at the query, there's no column name > > between 'WHERE' and 'LIKE' > > which is a syntax error. That's the problem. > > > > > > Looks like your sql generator has some issues, or > > you didn't specify the WHERE > > column properly. I'm not familiar with the system > > you're using, but keep in > > mind, that mysql_error will usually not steer you > > wrong. > > > > -Micah > > > > On Friday 10 September 2004 10:03 am, Stuart > > > > Felenstein wrote: > > > I had not, my apologies. I think your post > > > > slipped > > > > > by. Anyway, yes I have now inserted mysql_error() > > > > and > > > > > got my return. Though I'm not entirely sure how > > > > to > > > > > fix it. > > > Here is the error. > > > > > > You have an error in your SQL syntax. Check the > > > > manual > > > > > that corresponds to your MySQL server version for > > > > the > > > > > right syntax to use near 'Like 'ACCFIN'' at line 1 > > > SELECT `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`) where Like 'ACCFIN' > > > > limit > > > > > 0,1 > > > > > > -------------------------------------------------- > > > > > > --- Micah Stevens <micah@xxxxxxxxxxxxxxxxxx> > > > > wrote: > > > > did you make the change to the code I suggested? > > > > What does MySQL say the error > > > > is? > > > > > > > > -Micah > > > > > > > > > > > > On Friday 10 September 2004 07:49 am, Stuart > > > > > > > > Felenstein wrote: > > > > > 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@xxxxxxxx> 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 > > === message truncated === -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
