whats wrong?

[maxyes]

  <?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

?> 

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.