.josh

did you try separating your query string from your mysql_query and echoing it out to see if it's holding what you expect? And running it directly in phpmyadmin or w/e?

I'm not a sql expert but you can do something like this (I think...): SELECT * FROM table WHERE datecol < DATE_SUB(CURDATE(),INTERVAL 2 DAY)

- where is $action being set? - is the pw encrypted in the db? because i see no kind of encryption of the pw being checked.

Select all files from db with date older than 2 days, use unlink() on each one, with a loop. Now setup a cron job to run the script however often you want.

sorry I totally missed the first part where you mentioned the mysql table.

Tell you what man... couple months ago I was messin' around with this sort of thing, and my research yielded the conclusion that "unknown carriers" are people with pay as you go type phones, and it's "unknown" because it pretty much depends on the area the phone was bought in and is being used, as to which known carrier the phone is going through. As far as I could tell, the way programs like that get around it, is they just spam every known carrier with the same sms message, and hey, it'll get through to the one it actually is, and just give a fail on the other ones. Message goes through, ignore the fails, unless you get 100% fail. I don't really feel it's a matter of re-inventing the wheel. If you wanna adopt that philosophy, you may as well stop coding altogether. It's a matter of saving yourself money on something that's pretty easy to code. All you have to do is make a simple form to input a to, from, subject, message, carrier (dropdown). The list of "known" sms addresses is pretty easy to find; just google 'sms email addresses.' When info is posted, simply mail() with that info. If user chooses unknown, simply loop through and mail() to all. I'm not really sure about the whole sending sms messages to other country's carriers. Never really looked into that because it wasn't really relevant to my curiosities. I guess it really depends on what your overall goals and needs are. There are a lot of places you can have your script post the info to (using curl or w/e) and they will send it off for you, even to other countries.

I'm sure you have a reason for wanting to find this thing, but why not just google for a list of sms email addresses and make your own?

date() good luck.

You have now donated 500 grains of rice. FF's Wikilook = LOTS OF HAPPY KIDS

btw if you're getting that array from a db query just do it in the query: SELECT blah FROM table ORDER BY blah LIMIT 5

a) you don't have a closing } for your confirm_query function, you just go right into get_all_subjects function b) you had single quotes around your 2nd function name c) you don't have a ; at the end of global $connect

use sort() or rsort() ... or am I not understanding you?

No not really, because there isn't really anything else that's "shorthand" syntax.

ah okay so just in your links, throw the article's id onto the url target like so... <a href='new_page.php?id=$id'>$title</a> and then on new_page.php just retrieve the id and select the content based on the id $id = $_GET['id']; $sql = "select stuff from table where id = $id";

Start with basic database handling, go from there.

Honestly I don't really see anybody writing a tutorial like that on a technical level (actual code). Maybe on some kind of abstract level, like conveying general principles and program flow and good design, advice and pitfalls, etc.. but most tutorials that involve actual code are for teaching how to make building blocks. Things like forums and blogs and cms' are more like actual buildings, not building blocks. If you sit down and break down for instance all the things in a forum, you will quite easily find tutorials for just about all of those 'building blocks.' I suggest you either do that, or maybe find an open source version of one of those things and jump into it, instead.

So I will assume it's solved then.

http://www.phpfreaks.com/forums/index.php/topic,95426.0.html

so are you saying you aren't getting any errors from your die(mysql_error) ? Did you echo the $sql to see if the query is what you are expecting; all the values there, etc..?

hmm...only thing i can think of is...are you using the same var as the input value in your form? That is, maybe the 'top' one and 'bottom' one are somehow holding the same id...

html-kit does have a good community that offers up a ton of mods and addons that do many things, including auto-completion. But anyways, zanus is right, we have a sticky for this stuff.

well...Zend does have the advantage of having some of the core php developers (the people who actually made php) on their staff...

html-kit ftw. And it's free.

After forcing myself to go through all 10 pages of this thread, it's painfully obvious that you aren't trying to work it out for yourself, but just to have people spoonfeed it to you one line at a time. That is not what we're here for. Post in the freelance forum. Thread closed.

actually sorry, it needs to be if($query123['confirmed'] == 0) {