Syntax Error

[unemployment]

I have a MySQL syntax error.  Anyone know why?

 

$sql = "SELECT `user_id`, `friend_id` WHERE `user_id` OR `friend_id` = '${user_info['uid']}'";

 

UPDATE:

hmmm I'm guessing I forgot FROM

 

UPDATE:

My OR is still not working

 

$sql = "SELECT `user_id`, `friend_id` FROM `partners` WHERE `user_id` OR `friend_id` = '${user_info['uid']}'";

[kenrbnsn]

You need a condition on each piece of the WHERE, try:

<?php
$sql = "SELECT `user_id`, `friend_id` FROM `partners` WHERE `user_id` = '${user_info['uid']}' OR `friend_id` = '${user_info['uid']}'";
?>

 

Ken