whats wrong?

[maxyes]

 [COLOR=#000000] [COLOR=#0000BB]<?php

$link [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_connect[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"localhost"[/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]"mysql_user"[/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]"mysql_password"[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]mysql_select_db[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"database"[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000BB]$link[/COLOR][COLOR=#007700]);

[/COLOR][COLOR=#0000BB]$result [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_query[/COLOR][COLOR=#007700]([/COLOR][COLOR=#DD0000]"SELECT * FROM table1"[/COLOR][COLOR=#007700], [/COLOR][COLOR=#0000BB]$link[/COLOR][COLOR=#007700]);
[/COLOR][COLOR=#0000BB]$num_rows [/COLOR][COLOR=#007700]= [/COLOR][COLOR=#0000BB]mysql_num_rows[/COLOR][COLOR=#007700]([/COLOR][COLOR=#0000BB]$result[/COLOR][COLOR=#007700]);

echo [/COLOR][COLOR=#DD0000]"$num_rows Rows\n"[/COLOR][COLOR=#007700];

[/COLOR][COLOR=#0000BB]?>[/COLOR] [/COLOR]

is it the php version?

 

[cowctcat]

what is the error that you get

 

[maxyes]

something about line 7 error. I dont quite know because my http is down.

 

[Anna]

it's in the echo, you need to concatenate (ie add the variable to the string) the string with the variable.

echo $num_rows . " Rows\n";

that should work

for info on various ways to use echo: http://se2.php.net/echo

 

[Scoochi2]

it's in the echo, you need to concatenate (ie add the variable to the string) the string with the variable.

echo $num_rows . " Rows\n";

No you don't. You only need to do that for single quotes. Double quotes is perfectly fine.


maxyes, can you post the exact error that you see? Copy-paste it straight here. (when you can)

 

[maxyes]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/topclans/public_html/index.php on line 7
Rows

I think its to do with the databse mayby

 

[xPlozion]

check to make sure that the query is properly executing without any hidden errors.

if ($result) {
  echo "good";
} else {
  echo "bad " . mysql_error();
}

Also, you don't need the $link if you've only got one open mysql connection. Just thought you might find that handy.

link_identifier

The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect() is assumed. If no such link is found, it will try to create one as if mysql_connect() was called with no arguments. If by chance no connection is found or established, an E_WARNING level error is generated.

 

[maxyes]

bad No database selected :s what should i do?

 

[xPlozion]

try this and see what you get:

<?php
mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database");

$result = mysql_query("SELECT * FROM table1");
if ($result) {
  $num_rows = mysql_num_rows($result);
  echo "$num_rows Rows\n";
} else {
  echo "bad " . mysql_error();
} 

?>

 

[scopey]

It's a good idea when you're testing a script to put 'or die(mysql_error())' next to all your 'mysql_query()' statements. It'll just stop and print the error it's getting.

Anyway... Make sure you have your database name right. It'll be named 'maxyes_database' or something similar.