Code:
<?php
$connect = mysql_connect("localhost", "username", "password");
mysql_select_db("db", $connect);
$select = mysql_query("SELECT * FROM `tutorials` WHERE category = 'photoshop'", $connect);
while($row = mysql_fetch_array($select, MYSQL_ASSOC)) {
$id = $row['id'];
$name = $row['name'];
$email = $row['email'];
$category = $row['category'];
$url = $row['url'];
$url2 = $row['url2'];
$websitename = $row['websitename'];
$tutorialname = $row['tutorialname'];
$description = $row['description'];
echo "
<p>
<strong>Tutorial Name:</strong> <a href=\"$url2\">$tutorialname</a><br />\n
<strong>Submitted By:</strong> <a href=\"$url\">$websitename</a><br />\n
<strong>Description:</strong> $description</p>";
}
?>
I hope you all understand, and what i am trying to do is intergrate pagination, but i dont know where the script will go and how to use the
Code:
$select = mysql_query("SELECT * FROM `tutorials` WHERE category = 'photoshop'", $connect);
while($row = mysql_fetch_array($select, MYSQL_ASSOC)) {
$id = $row['id'];
$name = $row['name'];
$email = $row['email'];
$category = $row['category'];
$url = $row['url'];
$url2 = $row['url2'];
$websitename = $row['websitename'];
$tutorialname = $row['tutorialname'];
$description = $row['description'];
echo "
<p>
<strong>Tutorial Name:</strong> <a href=\"$url2\">$tutorialname</a><br />\n
<strong>Submitted By:</strong> <a href=\"$url\">$websitename</a><br />\n
<strong>Description:</strong> $description</p>";
}
?>
bit which i need. Thanks
