mysql help

I have a set of mysql lines that fetches data from a table, here's the code.
PHP Code:



$sql = "select ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t1.*,ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t2.Name as estate_type,ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t3.Name as estate_status,ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t4.Name as estate_township,ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t5.Name as estate_roomtype,ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t6.Currency as estate_rent_currency,ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t7.Images as estate_images,ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t8.Name as estate_cityÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t9.Name as LocationÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*from t_advert t1ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*inner join t_properties t2 on t2.PageType='EstateType'ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*inner join t_properties t3 on t3.PageType='EstateStatus'ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*inner join t_properties t4 on t4.PageType='TownShip'ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*inner join t_properties t5 on t5.PageType='RoomType'ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*inner join t_exchange t6 on t6.Currency=t1.RentCurrencyÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*inner join t_advert_images t7 on t7.ParentID=t1.IDÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*inner join t_properties t8 on t8.PageType='City'ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*inner join t_properties t9 on t9.PageType='Location'ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*where ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t2.ItemIDÂÂ*ÂÂ*ÂÂ*= t1.EstateType and t2.PageLang='".$_SESSION['Lang']."' and ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t3.ItemIDÂÂ*ÂÂ*ÂÂ*= t1.EstateStatus and t3.PageLang='".$_SESSION['Lang']."' and ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t4.IDÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*= t1.TownShipID andÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t5.ItemIDÂÂ*ÂÂ*ÂÂ*= t1.RoomType and t5.PageLang='".$_SESSION['Lang']."' and ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t6.Currency = t1.RentCurrency and ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t7.ParentID = t1.ID and t7.Seq = (select min(Seq) from t_advert_images where Visible='1' and ParentID=t1.ID group by Seq LIMIT 0,1) and ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t8.IDÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*= t1.CityID andÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t9.IDÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*= t1.Location andÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*t1.Visible='1' and t1.PrivateAdvert='1' order by t1.RentPrice ascÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*ÂÂ*";$qrPrivateAdvert = mysql_query($sql); while($rsPrivateAdvert = mysql_fetch_array($qrPrivateAdvert)) {




What I did was add the "t9.Name as Location" which is an existing field in the table and that method is working fine on other pages, I just don't know what I'm doing wrong in here. This code is not functioning at all, can anyone help me please.
Thanks,
George





__________________http://drugart.deviantart.com

Hi George,
if you output the result of mysql_error(); , that will help you see what the server is saying, and that should help you track it down a little. However i also notice that
Code:
t7.Images as estate_images,
t8.Name as estate_city
t9.Name as Location
should be this
Code:
t7.Images as estate_images,
t8.Name as estate_city,
t9.Name as Location
missing a comma





__________________
WebCertain - SEO, PPC, PR - The services you need to increase your site traffic. Specialists in over 35 languages and country-specific SEO! www.webcertain.com

Could Location be a reserved word? Have you tried `Location` instead of Location? Also, have you tried your query in phpmyadmin? Good place to validate if a query works.





__________________
Custom PHP Designhttp://www.customphpdesign.com
PHP * HTML * Javascript

Thanks webcertain, looks like I've been missing a comma hehe but that didn't solve the problem, still not working.
And yes the Location field is valid.





__________________http://drugart.deviantart.com






Last edited by Snitz : 10-31-2008 at 09:44 AM.

Quote:



Originally Posted by Snitz


Thanks webcertain, looks like I've been missing a comma hehe but that didn't solve the problem, still not working.
And yes the Location field is valid.


How about you just dissect PHP from the actual query and just writ your query
from starting small and than progressing while having successive runs?
mysql -h yourhost.com -u your_username db_name < file.sql -p
will let you funnel your sql query to the server to see progressively if you're
erring somewhere.
Thanks.





__________________Erald T -- Client Service EngineerNavisite Dedicated Hostinghttp://dedicatedhosting.navisite.com24/7/365" Myth or Reality

PHP Code:



$qrPrivateAdvert = mysql_query($sql);echo myslq_error();exit(); while($rsPrivateAdvert = mysql_fetch_array($qrPrivateAdvert)) {




what's the output?





__________________
PHP Code Repository | Worst Wide Web, now PR2