Show certain tutorials.

Xyzer · Mar 30, 2006

Hi,

I have a tutorial site here at www.x6core.com, and people submit tutorials, how would i make it so when the submit the choose a catorogry for the tutorial? I think on say the photoshop page the code could be something like this, but im not sure. Can someone help please? P.S All the records are in a mysql database.

Code:

if $categories == photoshop{
showrecord}

Im not sure how to show all records that meet criteria.

sacx13 · Mar 30, 2006

We need to know more ... When the tutorials are posted you you can decide for a category ? If yes then you can select them. If not the single posibility is to look in title after "category" like "photoshop".

Your tutorials are in sql database or are simple text files on harddrive ?

Regards
Adrian

Xyzer · Mar 30, 2006

My tutorials are all stored in a mysql database and i want it so when people submit them they can choose the catogoru.

asgsoft · Mar 30, 2006

do you have a pre-defined list

if you sign up to http://aysha.hostmatrix.org/ and see the form for submitting a tutorial should show you a good example.

sacx13 · Mar 30, 2006

Your site support adding categorys ? otherwise you need to change your database and all ...

Regards

Xyzer · Mar 31, 2006

I know i will change the database and everything but i want the predifined list then a page that shows all the ones in which the catogory is photoshop.

asgsoft · Mar 31, 2006

OK first what is ur pre-defined list

wackyjoe · Mar 31, 2006

umm not quite getting wht your saying?

try:

PHP:

<a href="/tutorials.php?cat=photoshop">Photoshop</a>

PHP:

<?php
$cat = $_GET['cat'];

if ($cat == "photoshop") {
//whtever u can here
}
else
{
echo"Invalid Category";
}
?>

sacx13 · Mar 31, 2006

Is more easy in this way ...

PHP:

<?php

function get_articles_cat($cat)
{
//  sql stuff searching for articles from categories $cat
}

$cat = $_GET['cat'];

if ($cat != "") get_articles_cat($cat);

?>

if you trto doit with if's you will need to add a if for each category added

Regards

Xyzer · Apr 2, 2006

^^ what goes in the orange area?

asgsoft · Apr 2, 2006

that is a comment

Xyzer · Apr 3, 2006

right, i like the way this one is made and i want to use it:

Code:

<?php 
$cat = $_GET['cat']; 

if ($cat == "photoshop") { 
//whtever u can here 
} 
else 
{ 
echo"Invalid Category"; 
} 
?>

I dont know how to intergrate it with this:

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<?php
$connect = mysql_connect("localhost", "dbun", "dbpw");
mysql_select_db("dbname", $connect);

$select = mysql_query("SELECT * FROM `tutorials`", $connect);
while($row = mysql_fetch_array($select, MYSQL_ASSOC)) {
    $id = $row['id'];
    $name = $row['name'];
    $email = $row['email'];
    $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 think it should be:

Code:

<?php
$connect = mysql_connect("localhost", "bdun", "dbpw");
mysql_select_db("dbname", $connect);

$select = mysql_query("SELECT * FROM `tutorials`", $connect);
while($row = mysql_fetch_array($select, MYSQL_ASSOC)) {
    $id = $row['id'];
    $name = $row['name'];
    $email = $row['email'];
    $url = $row['url'];
	$url2 = $row['url2'];
	$WebsiteName = $row['WebsiteName'];
	$TutorialName = $row['TutorialName'];
    $description = $row['description'];
    $cat = $row['cat'];
}
if ($cat == "photoshop") { 
//echo statement??
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>";
}
else {
echo "There are no tutorial in this category";
{
?>

Is this correct??

whyme953 · Apr 3, 2006

i think what you want to do is

SELECT * FROM tutorials WHERE cat = 'photoshop'

then loop through the results.

Xyzer · Apr 3, 2006

Thanks, ive done a copy with my code and get this error:

Code:

Parse error: syntax error, unexpected $end in /home/gibbons/public_html/photoshop.php on line 37

In

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<?php
$connect = mysql_connect("localhost", "dbun", "dbpw");
mysql_select_db("dbname", $connect);

$select = mysql_query("SELECT * FROM `tutorials`", $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'];
	
if ($category == "Photoshop"){
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>";
	}
else {
echo "Sorry, There are currently no tutorials in this category.";
}
?>
</body>
//LINE 37 BELOW
</html>

whyme953 · Apr 3, 2006

you're missing the closing } for the while($row = mysql_fetch_array... statement.

generally when you get an error like that on the last line that's what it is.

Xyzer · Apr 3, 2006

I have done this and its has worked the WHERE cat=photoshop.

Where can i put a statement if there is no tutorials??

Xyzer · Apr 3, 2006

also now what has happened is that it wont display the site and tutorial name, check here: http://www.x6core.com/?id=photoshoptutorials But all i have changed is the where cat = photoshop, if you want to see my code its here:

Code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<?php
//Connect goes here, but deleted user and pw.

$select = mysql_query("SELECT * FROM `tutorials` WHERE category = 'photoshop'", $connect);
while($row = mysql_fetch_array($select, MYSQL_ASSOC)) {
	$category = $row['category'];
    $id = $row['id'];
    $name = $row['name'];
    $email = $row['email'];
	$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>
";
}
?>

</body>
</html>

Xyzer · Apr 4, 2006

can anyone help me please?

whyme953 · Apr 4, 2006

after you run the mySQL query add this:

PHP:

if (mysql_num_rows($select) >0) {//there are tutorials in this cat.

//print out your stuff

} else {//nothing in this cat.

    echo 'Sorry, no tutorials in this category'; //replace with message of your choice.
}

i'm not sure if this is what you're looking for or not. hope it helps.

Xyzer · Apr 4, 2006

Fixed thanks everyone.

Show certain tutorials.

VIP Member

Established Member

VIP Member

VIP Member

Established Member

VIP Member

VIP Member

Established Member

Established Member

VIP Member

VIP Member

VIP Member

Established Member

VIP Member

Established Member

VIP Member

VIP Member

VIP Member

Established Member

VIP Member

generalalarms.com

StarkCountyNews.com

BellefontePA.com

TrumpTrips.com

wordagram.com

x-clip.com

islamicEconomy.com

aigirlfriend.eu

PrecisionLocating.com

DirectBand.com

Similar threads

We're social

generalalarms.com

StarkCountyNews.com

BellefontePA.com

TrumpTrips.com

wordagram.com

x-clip.com

islamicEconomy.com

aigirlfriend.eu

PrecisionLocating.com

DirectBand.com

Pinned

Appreciation

Agreement

Answers

Relevance

Reaction

Status

Feeling