Re: Simple Problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



That's a SQL problem, nothing to do with PHP.

You've forgotten a JOIN clause.

---------------------
Skrol29
www.tinybutstrong.com
---------------------

PartyPosters a écrit :
I can't figure out what I am doing wrong,
this sql string seems to filter out the information I want but it duplicates the all info, as 'num_rows' is total of rows in the table and not the correct value of the filtered information?

$sql="SELECT products.productID, products.title, products.number_per_box, products.stock_level, products.image, users.username, users.email, users.userID FROM users, products  WHERE products.userID = $userID";
$mysql_result=mysql_query($sql,$connection);
$num_rows=mysql_num_rows($mysql_result);


this is the old sql statement which works fine - $sql="SELECT productID, title, number_per_box, stock_level, image, userID FROM products WHERE userID = '$userID'";
$mysql_result=mysql_query($sql,$connection);
$num_rows=mysql_num_rows($mysql_result);


what I am I doing wrong.

Thanks
Kaan.




-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux