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); ?> Link to comment https://forums.phpfreaks.com/topic/65365-how-to-pass-html-link-in-mysql-where-condition/ 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/'"; Link to comment https://forums.phpfreaks.com/topic/65365-how-to-pass-html-link-in-mysql-where-condition/#findComment-326438 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. Link to comment https://forums.phpfreaks.com/topic/65365-how-to-pass-html-link-in-mysql-where-condition/#findComment-326445 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. Link to comment https://forums.phpfreaks.com/topic/65365-how-to-pass-html-link-in-mysql-where-condition/#findComment-326454 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.