ILMV

You're very welcome. ILMV

Your SQL statement is not formed correctly. $sql = "SELECT * FROM pictures WHERE username = '".$username."' AND parent_album = '".$album['album_id']."'"; If you're string starts with a ", you should open and close it at all times with ". Edit: This might not be the main problem, come back to us if it isn't ILMV

Ah yes I got it working now A really good service, I would concur with premiso, having the option to select different types of referencing would be very good (I use the harvard style, whatever that is). ILMV

Hello kenrbnsn! Thanks for your suggestion, it works a whole lot better than count, also it looks neater. Many Thanks!

Oh hang on... http://uk2.php.net/count Maybe I will have not initialise it, and check if it has been set... seems slightly backwards to me

Hey Marcus No, I have print_r'd it, and it returns an empty array, not keys or values... Array ( )

I cannot figure this one out, I have an array: $errors=array(); When I go to check the count of the array: if(count($errors>0)) { echo(count($errors)); // output is 0 } ...the condition executes! Even when I echo the count it says 0, how on earth is that happening? I didn't put >=, how is 0 > 0? Cheers, Ben

Fantastic idea, but: "Service Temporarily Unavailable The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later."

Well Hello All! I don't know if I am the only one, but I keep forgetting to check the comments I get through my site (I know I should have an email confirmation). Needless to say I logged into my CMS the other day and found two from February, both from the same person, I assume the name was fake so I won't bother you with that. Both messages slagged off me, my site design and the open source WordPress template I use, and this was all because I gave my thoughts about someones website in the website critique forum. Needless to say, if you're the slimy bastard who left those comments, have the decency to leave a real email address, so I can reply in a similar manner Have a great day

Yes, it called cyber-squating, which I protest sounds disgusting!

I am all for open source... but can you make is OS and secure?

Both please

You're welcome

It looks very good! I think the length of nrg_alpha critique demonstrates how much effort you guys have put into it, I don't think I would critique that indepth on a concept that I knew wasn't of the standard you have demonstrated. Very well done! ILMV

Simple... effective... MrAdam is right, slap the user name in there as well, perhaps the ability to change the background pictures as well... Edit: One other thing you might want to consider is to link to their twitter page instead of you... I know this sounds backwards, but I don't see the point is advertising my twitter feed, but drive no traffic to it. ILMV

You learn 90% of what you teach, helping others is the perfect way to increasing your knowledge.

Have you considered using joins? As this would be a far better way of achieving your desired result. If like me you are new to joins, take a look at this fantastic example... http://www.codinghorror.com/blog/archives/000976.html Regards, ILMV

Yes I believe so, we can create a unique identifier by concatinating several fields, but this looks ugly, and takes up a lot of code.

Yes it is off topic, please start your own thread. Here's the deal... I am creating a query within postgreSQL (call it a query, view, overview, whatever)... It is ripping information from two tables, there are no fields that, when combined in the query are unique. I could make a unique field by concatenating lots of other fields together, but that looks crap, and uses a lot of code. I need to generate in this query, a unique number, auto incremented would be good, the number could be for example the row number, this is a feature used within Oracle and I believe is defined as rownum. I need to have a unique ID on the query because without it the framework we are using pukes up, it will not allow us to order or page the results of the query.

Nothing... but I need to generate a unique ID field to satisfy the PHP framework we are using.

I am creating an overview (query) in pgAdmin on PostgreSQL. I need to generate a unique ID, it can be totally random but really I want something simple like the row number. Does anyone know any way of implementing this? ILMV

I know, I wanted it to be basic, I don't want the design to draw too much attention away form the content. Is there anything you would suggest to make it better?

Hello All I have been tasked with creating a website for a local painter and decorator. It is currently not yet constructed in HTML etc, but I would love some good old fashion feedback on the design prototype. Many Thanks, ILMV

You're missing a trick here, what about Google Charts? http://code.google.com/apis/chart/ Only problem is that it sometimes requires complex URLs to be constructed / sent, but there are classes online that will construct that for you, I in fact am creating one ILMV

Nice try, but that won't work. As it check to see if $query is empty (if it's the first where clause)... but you have already started to construct your $query variable it will look like this... SELECT * FROM table AND name = 'jim'