Posted by Skrol29 on 04/12/05 18:49

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.
>
>
>

[Back to original message]