No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
9 Posted Topics
you can add 2 columns `subscription_start_date` and `subscription_end_date` to your table. Then use `SELECT CASE WHEN DATEDIFF(subscription_start_date, subscription_end_date) > 0 THEN 0 ELSE 1 END AS expired FROM ...` If expired is 0 then you know it's still active, and inactive if expired is 1
The problem might be that you are not running any mail server software like Mercury. I use Xampp and it comes with Mercury so it works for me.
I want to add rss to my site that checks information about the url the user has posted then returns the image from the site, and brief describtion of what the site does.....just like the way facebook does it when user posts a url. Any ideas how it's done or …
How are we supposed to help you if we don't even know what the error is? Please tell us the error u r recieving and the line number
mysql_query("INSERT INTO tbusers (username, email, password, firstname, surname, category, gender, birthday) VALUES('$username','$email','$password','$firstname','$surname','$category','$gender','$birthday')"); add this to it(just to see where the error is coming from): mysql_query("INSERT INTO tbusers (username, email, password, firstname, surname, category, gender, birthday) VALUES('$username','$email','$password','$firstname','$surname','$category','$gender','$birthday')") or die("Could not add to database beacuse: ".mysql_error());
[CODE]SELECT * FROM cities_stores WHERE cities_stores.city = cities.city AND cities_stores.store_type = stores.store_type[/CODE] This one is starightforward and m sure you do undestand it right? The value returned in the query above becomes a condition for this one: [CODE]SELECT * FROM cities WHERE NOT EXISTS[/CODE] (Selects all the rows where the …
on duplicate key update evnt_title`= '".$this_event_title[$a]."'") the error is on that character before evnt_title, what's this character "`"? delete it and put ' this one cuz it seems like you copied that code so that's y it doesn't read that character.
Can I email you how you can write your own code cuz it's a bit long. I have done it a couple of times for data specified by users and it works fine. Calculates number of rows in a database for each field and then returns percentage for height or …
The End.