Проблем със заявка..

[stasiiiii]

Дава ми тази грешка като напиша

echo mysql_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 '.users as u WHERE p.cat_id=1 AND p.added_by=u.user_id' at line 1

Ето и заявката

$rs = mysql_query('SELECT * FROM posts as p.users as u WHERE p.cat_id='.$cat_id.' AND p.added_by=u.user_id');

 

[emagi]

$rs = mysql_query('SELECT * FROM posts as p.users as u WHERE p.cat_id='$cat_id' AND p.added_by=u.user_id') or die(mysql_error());

 

[stasiiiii]

Сега ми дава

rse error: syntax error, unexpected T_VARIABLE in C:\xampplite\htdocs\radobb\topic.php on line 24

 

[emagi]

$rs = mysql_query("SELECT * FROM posts as p.users as u WHERE p.cat_id='$cat_id' AND p.added_by=u.user_id") or die(mysql_error());

 

[stasiiiii]

Сега пък ми изписа това

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 '.users as u WHERE p.cat_id='1' AND p.added_by=u.user_id' at line 1

 

[emagi]

ДАй структурата на таблицата
Иначе тази заявки ти ли си я мислил:

$rs = mysql_query("SELECT * FROM posts as p.users as u WHERE p.cat_id='$cat_id' AND p.added_by=u.user_id") or die(mysql_error());

Няма никакъв смисъл
Пробвай така:

$rs = mysql_query("SELECT * FROM posts as u WHERE p.cat_id='$cat_id' AND p.added_by=u.user_id") or die(mysql_error());

 

[adrian]

$rs = mysql_query("SELECT * FROM posts as p, users as u WHERE p.cat_id='$cat_id' AND p.added_by=u.user_id") or die(mysql_error());

трябва да е запетайка, а не точка. Можеш да използваш и JOIN

SELECT * FROM posts as p LEFT OUTER JOIN users as u ON p.added_by = u.user_id WHERE p.cat_id='$cat_id'