BetterPHP

I just realised the rating system was only appearing on one post, I fixed this now, should be a lil more obvious!

Hey guys, I believe everything is working now.

Please visit my website: http://www.budgie.richardcmpage.com/

And answer the questionnaire

http://www.surveymonkey.com/s/MWXTXPW

Thank you for your time and feedback.

EDIT - I should mention I entirely self taught myself the languages and this is my first website

Sweet, think i got it working!!

Cheers dude, was really smart thinking there

jacek wrote:There must be something that contains the name of the current page ? Maybe $_GET['page'] ? However your template system is set up

Yeah I just through of that, I want to know as well...if you go to my site the index.php is not actually in the URL, if i use the get method will it pick it up?

I'm confused as to how/what I'd be setting the $page variable as?

So I have my navbar: What I want to do is... if the user is on index.php then 'latest post's in the navbar turns red, if the user is on ideas.php then 'ideas' in the navbar turns orange, if the user is on facts.php then 'facts' in the navbar turns yellow. When one of these navbar words changes the c...

i'm just guessing here… in the `users` table have a column like "time last visited", so every time a user signs out or whatever it gets updated. then when the user logs back in and checks out the newest posts, have it display every post that was entered from the time in the database and t...

I have a feed showing the latest posts ordered by Time but i want to integrate some function that just displays a yellow star or something showing the newest posts since the user last visited. Also if 2 posts have the exact same time how does php decide which one goes first? Is this hard to implemen...

Temor wrote:the function mysql_insert_id() returns the last inserted ID. Maybe that's what you're looking for?

http://php.net/manual/en/function.mysql-insert-id.php

YESYYESYSEYSEYSESEYES THAT'S IT, IT WORKS!!!

OMG THANKS!!!

Feel like this so bloody easy but I can't figure it out :-S So I have a submit button which gives a couple of columns some data but then the ID column is left alone as it is auto incremented. However I then need a statement after taking that automatic incremented ID column value and put it in anothe...

jacek wrote:I guess I never got around to it

Get on it Jacek! You the man

PHP Tutorial: Simple Rating / Voting System

The end of this tutorial series you say there will be a bit integrating a user system so users an only vote once? This is really crucial and would love to know how to do it as I can't quite figure it out?

Peace

Ed

thank you thank you

Example - http://www.budgie.richardcmpage.com/Images/IDEA2.png

Like the rectangle with another tab type bit? Or can another language do it?

I would like to try and avoid using an image-bg.

jacek wrote:You have a space before the opening <?php

I solved it, I had a random generic SPAN tag in my css already with a margin-left lol

The span seems to be adding a few spaces in front of the text. This is an example of one of my lines [syntax=php]<p class='article_title'> <?php echo str_replace($keyword,'<span class="highlight">'.$keyword.'</span>',$headline); ?> </p>[/syntax] and if yo see in the image below.. http://im...

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\budgie\Organised2\functions\functions.php on line 486 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`idea` `quot...

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\budgie\Organised2\functions\functions.php on line 486 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`idea` `quote...

jacek wrote:[syntax=php]implode("%' OR `idea LIKE '%", $keywords)[/syntax]
You missed a ` after idea.

Hard to spot !

Wow nice one, sorry for that.

It's still not working Getting same error.

Screen shot of my table:

http://img15.imageshack.us/img15/1024/13286720.png

You should be able to OR, OR, OR, OR, OR ye[ try adding [syntax=php]echo mysql_error();[/syntax] after the failed query and see if it tells you what is wrong. I'm getting the "Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given" error. I can assure you each colu...

Hey guys

In the tutorial there is (using my column/table names):

[syntax=php]FROM threads
WHERE {$fact_where}
OR {$quote_where}
[/syntax]

But I have about 8+ columns, so how do I do the OR bit? I tried WHERE, OR, OR, OR but it doesn't work so what is the correct syntax?

Thanks

Ed