beboo002 Posted August 17, 2007 Share Posted August 17, 2007 hello all 1.->I am facing some problem how html link value pass to mysql select query in where condition here i am paste my html code and mysql code. 2->and also want that same mysql select code pass to page to page and pick the page to page link pass to where condition like this site http://www.offshoreoutsourcingsite.com/ database coding <?php $con = mysql_connect("localhost","root","") or die("Could not connect "); mysql_select_db("offshore", $con) or die("could not find db"); $select1 = "select reciprocallinkurl from recordonsubmit where category='2d and 3d animation'"; (need here link) $result = mysql_query($select1,$con); echo "<table border=1> <tr> <th>Reciprocal Link URL</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr><td>"; echo $row['reciprocallinkurl']; echo "</td></tr>"; } echo "</table>"; mysql_close($con); ?> Quote Link to comment Share on other sites More sharing options...
trq Posted August 17, 2007 Share Posted August 17, 2007 $select1 = "SELECT reciprocallinkurl FROM recordonsubmit WHERE category='2d and 3d animation' && fieldname = 'http://www.offshoreoutsourcingsite.com/'"; Quote Link to comment Share on other sites More sharing options...
beboo002 Posted August 17, 2007 Author Share Posted August 17, 2007 thanks for reply but i connot use catagory value like 2d and 3d animation in here i pass link value <html> <body> <a href = "2d and 3d animation.html">2d and 3d animation</a> </body></html> here my qus. is how i am pass 2d and 3d animation link to where conditions. Quote Link to comment Share on other sites More sharing options...
trq Posted August 17, 2007 Share Posted August 17, 2007 You need to be alot clearer in the explinaation of your problems, I'm actually having trouble making out a question at all. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.