Modify "SELECT * FROM

[datoshway]

I need to modify this code i'm working with so im pulling a certain row and not the whole table.  Can anyone help?

 

<?php

define("STR_RELATIVE_PATH", "");

require STR_RELATIVE_PATH . "_includes/_database.php";

db_connect();
db_select();

$strQuery				= "SELECT * FROM tblServices ORDER BY intID ASC";
$queryGetServices		= db_query($strQuery);

?>

[Maq]

Where is this 'certain row' coming from...?  Regardless, you're going to most need to use a WHERE clause.

[greatstar00]

add where cause after "tableServices"

[jcbones]

<?php



define("STR_RELATIVE_PATH", "");






require STR_RELATIVE_PATH . "_includes/_database.php";



db_connect();



db_select();



$strQuery








//Rename column to the column you are searching, and the value is self explanatory.
= "SELECT * FROM `tblServices` WHERE `column` = 'value'"; //You don't need an ORDER BY if you are only pulling one row.



$queryGetServices





= db_query($strQuery);




?>

[datoshway]

 

You rock man, thank you for the help, worked perfectly!

 

<?php



define("STR_RELATIVE_PATH", "");






require STR_RELATIVE_PATH . "_includes/_database.php";



db_connect();



db_select();



$strQuery








//Rename column to the column you are searching, and the value is self explanatory.
= "SELECT * FROM `tblServices` WHERE `column` = 'value'"; //You don't need an ORDER BY if you are only pulling one row.



$queryGetServices





= db_query($strQuery);




?>