mysq_num_rows

[karimali831]

Hi,

 

I want to use:

 

if(mysql_num_rows($ergebnis2)==2)

 

how can the value 2, be retrieved from the database?

example, lets say I have if

 

(mysql_num_rows($ergebnis2)==$limit)

$limit = $ds['limit'];

 

also query:

 

safe_query("SELECT limit FROM ".PREFIX."settings WHERE limit = '$limit'"));

 

 

but this is wrong. I'm php beginner.

Can someone help me please build this together?

 

thanks for any help at all.

[trq]

Its not real clear what your asking. mysql_num_rows returns the number of rows contained within your result resource.

[karimali831]

yes and with:

if(mysql_num_rows($ergebnis2)==2)
echo '2 results';

 

it counts 2, but I want this value to be retrieved from a table? still no understand?

[trq]

yes and with:

if(mysql_num_rows($ergebnis2)==2)
echo '2 results';

 

it counts 2, but I want this value to be retrieved from a table? still no understand?

 

Nope. Still makes little sense.