Need some help with this php code, i have setup a system where when people register and login for my site (its just for a college project so no security issues here) that their username is shown at the top with some account options. Kinda like dailymotion or you tube do
Anyway a further option people can do is register as a seller, and if they do that there user id is entered into a seller table (hopefully somebody can folloow this)
What the code below is trying to do is check if the persons username has a corresponding entry in the sellers table (basically check are they registered as a seller - the SQL is correct cause i have that part tested) (if seller_id != 0) and if they have it displays the link to sell a book and if their not registered as a seller they get the option to register as a seller)
Code keeps throwing up errors and im not sure if the logic is correct either,
any1 have any pointers?
Cheers
<?php
include("db.php");
$check1 = mysql_query("SELECT seller_id FROM seller s,user u WHERE u.id = s.seller_id and u.username ='$username'")or die("error");
while($info1 = mysql_fetch_array( $check1))
{
if ($seller_id != 0($info1["seller_id"))
{
?>
<a href="sell.php">Sell a Book</a>
<?php
}
else {
?>
<a href="register_seller.php">Become a seller</a>
<?
}
}
?>
Regards
Daryll
