selecting a single record

[Anon]

Dear friends please help me to figure out how to do this.

Let's say i have a table "ds_search" which has a field "Text" etc. now the table ds_search has 2000 records, but i want to print only one of them and only the "Text" field. otherwise how can i pring a single column & single row from my ds_search table? thank you very much in advance for help.

Regards
Arman Galstyan
eNotalone.com

[Anon]

Try Using The

$row = [[row#]] function, that way you can choose a certain row.. then Im pretty sure you know how to print it.

[rulian]

if you know the row number you want, you can do a mysql_result for example you do a search in the text colum for the word apple. one result is found it will be labled as row 0 in mysql, so you can just do
$word='apple';
$query=("select text from ds_search where text like '$word' ");
$result=mysql_result($query, 0, 'text');

or for multiple results ::
$howmany=mysql_num_rows($query);
for ($i=0; $i<$howmany; $i++){
$result=mysql_result($query, $i, 'text');

hope it helps

[blackmamba]

$result = mysql_query ( "SELECT Text FROM ds_search WHERE Text LIKE '%$searchtext%' LIMIT 1" );

That will select all the Text entries containing $searchtext, but will only include one entry in the result set thanks to LIMIT. You could remove the WHERE clause and just return the first entry in the Text column.