[Resolved] access certain rows from mysql

[fr8]

How would i pull rows from mysql with a certain ID? more than one row will have this same id.

the variable would be a _GET from the url.

i know it would be something like

if ( $cid = ID of row )
then
display ided rows
else
display all or none

[TruckStuff]

umm... how about:

mysql_query ("select * from Table where ID=".$_GET['id']);

[sarahk]

the basics are:

// CONNECT TO DATABASE // 
    $db_con = mysql_connect($DBHOST, $DBLOGIN, $DBPASS)  

                OR warnadmin( 'DB Connect: ' . mysql_error()); 
    $db_select = mysql_select_db($DBNAME)  

                OR warnadmin( "DB Select: {$DBNAME}: ". mysql_error()); 
// END OF DATABASE CONNECTION // 

//Run the query
  $sql = 'select id, name from mytablename where id = ' . $cid;
  $result = @mysql_query($sql);

  while($row = mysql_fetch_array($result)) 
  { 
     echo $row['id'] . ' - ' . $row['name'];
  }
   mysql_free_result($result);

but I'd check some of the tutorials and have a play before doing any real life stuff.

[fr8]

thanks TruckStuff. That got me on the right track and sarahk you put everything in perspective.

this is what i did which solved my problem.
$result = mysql_query("SELECT * FROM js_content WHERE cid=$cid",$db);

thank you guys again.