Okay I want to store the result of a videos views using MYSQL and PHP.
Like a view counter on a webpage except each video needs it's own counter, but how do I get the script to update the video views and such, so when the page is viewed it will add +1 to the number of total views for that given video.

You will have to have a table or something in your MySQL database keeping track of all of your videos somehow obviously, and with a field saving the number of views...

So you would have to grab the value out of the MySQL database increase it by 1 and then save it back to the database.

ok i'll give a quick stab at an example...

Assuming you have a MySQL table named videos which has a field named views.
mysql table videos :
id | name | link | views
1 | Cool Vid | www.cool.com | 6

<?php
mysql_connect('localhost','root','r0x');
mysql_select_db('mycooldb');

$sql = mysql_query("SELECT * FROM `videos` WHERE `id`='1' ");
$getCount = mysql_fetch_row($sql);
$getCount = $getCount[3]; // fetch_row returns a numeric array
$getCount = $getCount++; // add one to the fetched number

mysql_query("UPDATE `videos` SET `views`='" . $getCount . "' WHERE `id`='1'");
// update the record with the new number of views

?>

There might be a syntax error or two in there, but thats the just of it.

or "SET views = views + 1"

Originally Posted by accesstimes

or "SET views = views + 1"

yeah that would be much easier... i'm a dope.

Also is it possible to execute to mysql queries with different user names and tables on the same page?.(If so how do I do this, I have yet to find a way.)

Surely tables aren't the problem? THe table name is in the mysql query. I don't know about re-connecting though.