Multiple queries with mysql and php

[whitep8]

Hi all,

Im really baffled with this one. I have 2 tables that i simply wish to row count and display. the first works fine, but i just cant get the second to work, even if i rename the results variable

the code is below

<?php

$link = mysql_connect("localhost", "un", "pw") or die('error 1<hr>'.mysql_error());
mysql_select_db("db", $link) or die('error 2<hr>'.mysql_error());

$result = mysql_query("SELECT ID FROM tbl_sellers", $link) or die('Query1 Error<hr>'.mysql_error());
$num_rows = mysql_num_rows($result);

echo "$num_rows Private Seller records\n";
echo "<br>\n";


$result = "";

$result2 = mysql_query("SELECT id FROM index-peaform", $link) or die('Query2 Error<hr>'.mysql_error());
$num_rows = mysql_num_rows($result2);

echo "$num_rows records\n";
echo "<br>\n";
mysql_free_result($result2);

mysql_close($link);

?>

[Dormilich]

why don’t you use MySQL’s internal row counter?

SELECT COUNT(`id`) FROM table

[kovik]

I find aliasing the COUNT makes it easier to access.

$result = mysql_query('select count(*) as `count` from `table`');
echo mysql_fetch_object($result)->count;

* NOTE: PHP4 dislikes using the dereferencer (->) on non-variables, including directly on return values.

[whitep8]

hi,

Thanks for the responses.

I dont think ive been clear. I understand the counts, but my problem is that the second query returns only an error. The table exists, and there is data to count, but all i get is the same error.

4 Private Seller records
Query2 Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index-peaform' at line 1

[kovik]

It's a good idea to always surround table and column names with "`" characters. Also, it is standard to use underscores instead of dashes for this exact reason. SQL sees dashes as the subtraction operation, not as a character in a name.

[dgreenhouse]

Ding, ding, ding... And the prize goes to kovik!

[whitep8]

Hi,

Thank you all for your responses but my question is regarding the code in that the first query runs, the second one doesnt.

I dont see how your responses relate to my question

[kovik]

Really, ~whitep8? Did you even read my response...?

Basically, replace this:

SELECT id FROM index-peaform

With this:

SELECT `id` FROM `index-peaform`

And like I said, for future reference, DO NOT USE DASHES in table names or column names. Use underscores.