Tag Archive | "Query"

Show 10 Products Per Page? More Than 10 Auto Create New Page To Display Next 10?php?


Ok hey guys, thanks for reading this post. now what I am trying to do is simply displaying 10 products from the table and if more than 10 products are shown it will then automatically add a new page with like.. a different ID in the url? Well anything really as long as it will generate the pages dynamically. Below is my current coding.
$data = mysql_query(“SELECT * FROM products;”) or die(mysql_error());
$id = mysql_query(“SELECT ID FROM products;”) or die (mysql_error());
while($info = mysql_fetch_array( $data ))
{
echo ‘

‘;
echo “

“;
}
echo “

“;
echo ‘<a href="?page=products&uid='.$info['ID'].'…
Echo "
“;
echo “
“;
echo “

“;
Echo “Name: “.$info[‘name’] . “
“;
Echo “Price: “.$info[‘price’] . ”

“;
echo “

“;
Echo “Please click the image for further info.


“;
echo “


?>
As the coding shows, it is simply displaying the entire table in the PHP, however the problem is that the table will simply continue for ever, until their is no more products!! If you don’t know how to automatically generate a new page then would it be a good idea to show row 1-10, 11-20, 21-30 in different pages. If so how would this be done? Oops, I forgot to mention that the user will access the next list of products, E.G 11-20 by clicking the next page button.
Is it possible to use a get function to change the ID of the url when next page is clicked? then it will show the 11-20 results depending on the URL? eg products&id=2 therefore showing the next list of products? I am pretty confused hehe!:)
Thanks, your knowledge is appreciated!:)

Posted in Affiliate Marketing 101Comments (0)

Yahoo (linkdomain) Search Commands?


I’ve been trying to do a backlink search for one of the competitor sites (www.girlygames247.com) in the niche im targeting.
Here is my problem when I try searching for the backlinks of the domain
Search Query: (linkdomain:www.girlygames247.com)
http://siteexplorer.search.yahoo.com/search?p=www.girlygames247.com&bwm=i&bwmo=d&bwmf=s
Its showing all the backlinks of that site.
But when I try to remove a site from the backlinks
Search Query: (linkdomain:www.girlygames247.com -site:philippinesfoodrecipes.blogspot.co…
http://search.yahoo.com/search;_ylt=Avq29YfqIuy3JXdRD4oHoVubvZx4?vc=&fp_ip=ph&p=linkdomain%3Awww.girlygames247.com+-site%3Aphilippinesfoodrecipes.blogspot.com&toggle=1&cop=mss&ei=UTF-8&fr=yfp-t-701
I am getting an error. I’ve been doing this in the past and it gives me the results I want but now its not.
Anyone help me please.

Posted in Affiliate Marketing 101Comments (0)

Archives

Powered by Yahoo! Answers