Last post Sep 15, 2009 05:22 AM by po10cy
Sep 11, 2009 04:38 AM|po10cy|LINK
on my live site, www.classifieds4u.co.za, on the home page listing the categories, it doesnt update the number, next to each category, with how many ads there are in that category.
and when i click on the category, it doesnt display the ads for that category, it just says no search term specified and shows a blank page as if there are no ads under that category.
EDIT: i also notice that the date created is wrong on the live version of the site, it puts random numbers in for the month and day?? But when i view the table in the database for the ad it displays the date just fine, as year/month/day
what could be the issue?
Sep 15, 2009 05:22 AM|po10cy|LINK
fixed the issue, when i created the script with the tables and store procedures it didnt carry over the triggers, so had to query the triggers afterwards seperately.