recordset in php

pang

hi,
can anyone know what's the synonym of the recordset rsCategorie in php :

strSQL = "SELECT * FROM TAB_CATEG ORDER BY cod_categ DESC"
Set rsCategorie = objConnection.Execute(strSQL)

strCategorie = Request.Form("lstCategorie")
If strCategorie = ""  Then
	If Not rsCategorie.EOF Then
    	strCategorie = rsCategorie("COD_CATEG")
	End If
End If

thanks in advance

pohopo

It should look something like this...

$objConnection = mysql_connect("LOOK", "THIS", "UP");

$strSQL = "SELECT * FROM TAB_CATEG ORDER BY cod_categ DESC";
$rsCategorie = mysql_query($strSQL,$objConnection);

$result = mysql_result($rsCategorie, 0, "COD_CATEG");

pang

Thanks for reply, how can i write the last code in php:

If Not rsCategorie.EOF Then
strCategorie = rsCategorie("COD_CATEG")

pohopo

$objConnection = mysql_connect("LOOK", "THIS", "UP");

$strSQL = "SELECT * FROM TAB_CATEG ORDER BY cod_categ DESC";
$rsCategorie = mysql_query($strSQL,$objConnection);

if ($rsCategorie) {
$strCategorie = mysql_result($rsCategorie, 0, "COD_CATEG");
}

pang

$rsCategorie = mysql_query($strSQL,$objConnection);

buts $rsCategorie does not return true , it returns only false or an id_result.

bubblenut

Why don't you try.

$objConnection = mysql_connect("LOOK", "THIS", "UP") or die("Failed to connect");

$strSQL = "SELECT * FROM TAB_CATEG ORDER BY cod_categ DESC";
$rsCategorie = mysql_query($strSQL,$objConnection) or die("Query failed [".mysql_error()."]");
if (mysql_num_rows($rsCategorie)>0) {
  $strCategorie = mysql_result($rsCategorie, 0, "COD_CATEG");
  echo $strCategorie;
}

Also, what are you actually trying to achieve? If you give us a little more insight into what you're trying to do we may be able to help more.

One last thing, you're in the wrong forum. Well, strictly you're not, this is for any kind of chatter so there's no reason you can't post here but don't complain if someone ... Oh! oh! look at that sunset! Isn't it pretty? I do like sunsets, for a long while I used to think sunrises were better but I think that was mainly because I saw them less often.