Maq

Have you taken a look at the MySQL manual for the JOIN sytax? http://dev.mysql.com/doc/refman/5.0/en/join.html

Hi Randy, welcome to PHPFreaks. 1.5 Millions hits a month is very impressive! I'm sure we can help you with your dive into PHP. Good luck with everything.

That function takes a single parameter, a resource. You're giving it a string and $arg. Read more here: http://us.php.net/mysql_fetch_assoc Try to fix it, if you need more help post back.

Thanks Marcos. It's always nice to see posts like this. Welcome to PHPFreaks and I'm confident we can help you along the way.

I'd recommend making an attempt for yourself. You're fortunate SA has given you an example. You can lookup syntax and definitions here: http://www.mysql.com/ We don't mind helping, but we don't like giving you direct answers, to what seems to be, a HW assignment.

This relates more so to MySQL than PHP. Moving there.

I understand you're encountering the same problems as the OP, but this thread is more than 1 1/2 years old. No biggie, it's just better to start a fresh thread for the best responses.

What about Terminator? Terminator 1 and 2 came out years before Titanic. He didn't really have anything to do with the last two Terminator movies. I see. 12 years is a long time.

What about Terminator?

I know this is solved but you need to relax a little bit. You asked for a critique and that's what you're getting. If you think people are posting insulting replies just ignore them. I'll be looking forward to the revamped site.

Where is $title defined? Do me a favor and echo $insert (which is actually a DELETE statement, confusing variable name) before you execute the query: $insert = "DELETE FROM pages where title = '{$title}'"; echo $insert; die(); $result = mysql_query($insert); You also don't need curly braces around $title, it will interpolate just fine.

Hi Taz, cool name BTW. Welcome to PHPFreaks! Good luck with all of your goals and learning endeavors. This is a great community and I'm sure you will learn a lot here.

Another blabbering idiot... You did nothing right and blatantly didn't read any guidelines for posting questions on this board. You're lucky you even got a decent response. Go back under the bridge you came from, we don't have time for trolls like you, LOOSER!!

It's all in the manual.

You should be invoking mysql_real_escape_string on the input. That will escape the quotes. EDIT: KP beat me to it.

No. Change: $info = ldap_get_attributes($ad,$entry); to this: $info = ldap_get_attributes($ad,$result);

The second parameter you're giving ldap_get_attributes() is $entry. Now $entry is obviously an array returned by the method ldap_get_entries(). You need to change $entry to $result which is a resource returned by ldap_search().

Hi and welcome.

Nope, that's not what I'm looking for. I'm looking for the highest Placement of EACH series ordered by date. This will get you the highest placement for each series from the most recent date of each series. SELECT MAX(placement) FROM links GROUP BY series ORDER BY `date` DESC;

That, and what happens? What isn't working? Ya know, information we need in order to help you.

Can you dump the entire table structure for each one and post it?

Hi WarKirby, welcome to the forums.

Not to mention this is in the wrong section.

Hi Mindaugas, welcome to phpfreaks. I'm sure you'll learn a lot here, good luck with your game.

You're on xbox, yes? Yes.