heeeeeeelp!

Anon

I have written the following in my PHP script:
$Query_1 = "SELECT COUNT(*) FROM $Table";
$get_it = mysql_query($Query_1) or die("Query failed!");
which doesn't cause any problems.
I would like to use this data but how?????
I have tried
$n=mysql_fetch_array;
print ("$n[0]");
it writes
"Supplied argument is not a valid MySQL result resource in..."

if I just write:
print("$get_it");
it writes: "Resource id #2"...

what does resource id mean???? I would like to use the number of rows in at db table ....how???

Please help!

Thanks

[deleted]

read this:
http://www.hvt-automation.nl/yapf/index.php?cmd=viewitem&itemid=12

Anon

First of all thanks for the help uey I still havn't solved the problem quite...

I have so far:

$Table= "forum1";

// Connecting, selecting database

$Link = mysql_connect ($Host, $User, $Password) or die("Could not connect to $Host!");

mysql_select_db($D😎 or die("Could not select database $DB!");

$Query_1 = "SELECT COUNT(id) FROM $Table";
$Get_it = mysql_query($Query_1) or die("Query failed!");
$Antal = mysql_fetch_*($Get_it);

print ("$Antal<br>");

if i query:
SELECT COUNT(id) FROM 'forum1'
in phpmyadmin it returns the result 5 as it should yet if i write the above in a .php it writes 0?????????
What did I misunderstand?

[deleted]

lol,

wth "mysql_fetch_*" mean the functions called
mysql_fetch_array() and mysql_fetch_row() :-)

read more about those functions in the manual.

Anon

Well, It works with mysql_fetch_row and then print("$Antal[0]");

Thank u very much Vincent u have been a great help!!!! :-)

Your site's cool - good thing!

[deleted]

I think you may find it easier to use
$row = mysql_fetch_array($result, MYSQL_ASSOC);

then you can print the results by name;

$result = mysql_query("SELECT firstname, lastname FROM table");
$row = mysql_fetch_array($result, MYSQL_ASSOC);
echo $row['firstname'];
echo $row['lastname'];

just easier to read, and it makes no difference in speed.

Anon

I'll have a look at it tomorrow, I must go offline now! See ya!

ps.: I'm working right now, as a part of my study, on a thread based forum much like this one. Is there any smart way of doing so or some general scriptelements which is common for such work???

Again thanks a lot!