[SOLVED] php and mysql

[TheFilmGod]

how do I select a specific row in a mysql table?

[vbnullchar]

select name from table where id='$name_id';

[shaunrigby]

<?php

 

$query = "SELECT * FROM `table` WHERE `column` = $variable";

$result = mysql_query($query);

 

?>

[TheFilmGod]

Awesome! That's exactly what I wanted to do. My next question is, does anybody know how to + 1 to the count to a cell already selected? I'm new to mysql, any help is greatly appreciated.

[richardw]

I am assuming you want to write the data back to the table...

 

Make sure you have a field where you can increment the times accessed, in this example it is called "count". Redefine it or use an existing to match your table structure:

 

<?php

$query = "SELECT * FROM `table` WHERE `column` = $variable";
$result = mysql_query($query);

?>

<?php
$cnt = $row["count"];
$cnt++;


mysql_query( "UPDATE table SET  count = '$cnt' WHERE column= $variable";");

?>

[AndyB]

It'll be useful to read one or more of the tutorials. It'll help you with the terminology as well as how database queries are structured.