Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/seekide/public_html/storegroup/sg_forum/search.php on line 23
here is my html code:
Code: Select all
<input type="radio" value="1" name="venture_id" checked>Joint Venture<br>
<input type="radio" value="2" name="venture_id">Link Exchange<br>
<input type="radio" value="3" name="venture_id">Customer Exchange<br>
<input type="radio" value="4" name="venture_id">Banner Exchange<br>
<input type="radio" value="5" name="venture_id">Advertising Exchange</td>
<td width="50%"><input type="radio" value="6" name="venture_id">Offer to Advertise<br>
<input type="radio" value="7" name="venture_id">Offer to Accept Ads<br>
<input type="radio" value="8" name="venture_id">Feature / Technology / Code Exchange<br>
<input type="radio" value="9" name="venture_id">Service / Product Exchange<br>
<input type="radio" value="10" name="venture_id">Resource ExchangeCode: Select all
$venture_id = $_POSTї'venture_id'];
//$pm_url = append_sid("privmsg.$phpEx?mode=post&" . POST_USERS_URL . "=$poster_id");
/* Let's strip some slashes in case the user entered any escaped characters. */
$venture_id = stripslashes($venture_id);
// Search Query - Display Results
echo "<table width='100%' cellpadding='2' cellspacing='1' border='0' class='forumline'><tr><td class='catLeft' height='26'><img src='templates/phpib2/images/nav.gif'><span class='genmed'><font color='white'><b>Venture Results</b></font></a></span></td></tr>";
$result = mysql_query(
"SELECT sgforum_users.username, sgforum_users.companyname, sgforum_users.storename, sgforum_users.storewebsite, sgforum_users.storecategory, sgforum_users.orders, sgforum_users.hits, sgforum_users.customers, venture_master.venture_type, venture.products, venture.venture_desc
FROM sgforum_users, venture_master, venture
WHERE sgforum_users.user_id = venture.user_id
AND venture.venture_id = venture_master.venture_id
AND venture_master.venture_id = ".$venture_id."
ORDER BY venture.venture_date", $linkid);
while ($row = mysql_fetch_array($result))
{
echo "<tr>
<span class='genmed'>
<td>
User Name: <a href='http://www.seekideas.com/storegroup/sg_forum/privmsg.php?mode=post&u=2'>".$rowї'sgforum_users.username']."</a><br>
Company Name: ".$rowї'sgforum_users.companyname']."<br>
Store Name: ".$rowї'sgforum_users.storename']."<br>
Store Website: <a href='".$rowї'sgforum_users.storewebsite']."' target='_blank'>".$rowї'sgforum_users.storewebsite']."</a><br>
Store Category: ".$rowї'sgforum_users.storecategory']."<br>
Orders per Year: ".$rowї'sgforum_users.orders']."<br>
Hits per Month: ".$rowї'sgforum_users.hits']."<br>
Total Customers: ".$rowї'sgforum_users.customers']."<br><br>
Venture Type: ".$rowї'venture_master.venture_type']."<br>
Type of Products:<br>
".$rowї'venture.products']."<br>
Venture Details:<br>
".$rowї'venture.venture_desc']."<br>
<br>
Click User Name to send Private Message
</span>
<img src='images/line_break.gif' width='555' height='2' align='absmiddle'><br>
</td>
</tr>";
}
echo "</table>";