Jump to content

need help in my php code

pixeltrace

By pixeltrace
in PHP Coding Help

 Share

Recommended Posts

pixeltrace Advanced Member

pixeltrace

Posted
Posted

hi,

 

i need help,

i cant figure out how to fix the error.

 

kindly check this page

http://mango.resonance.com.sg/myoochi/findit/test.php

 

and this is the code for that page

<? 
include 'db_connect.php'

$view = isset($_GET['view']) ? $_GET['view'] : $view="main";
if ($view == "main"){
echo " 
<a href='test.php?id=328&view=sub'>Furniture, Fittings and Decor</a><br>
<a href='test.php?id=354&view=sub'>Interior Design</a><br>
<a href='test.php?id=355&view=sub'>Cleaning and Repairs</a><br>
<a href='test.php?id=367&view=sub'>Home Accessories and Appliances</a><br>
<a href='test.php?id=381&view=sub'>Home Alterations and Additions</a><br>
<a href='test.php?id=388&view=sub'>Architects, Engineering and Construction</a><br>
<a href='test.php?id=391&view=sub'>Home Entertainment</a><br>
<a href='test.php?id=395&view=sub'>Real Estate Agents</a><br>
<a href='test.php?id=397&view=sub'>Property Services</a><br>
<a href='test.php?id=401&view=sub'>Garden and Landscaping</a><br>
";
}
if ($view =="sub"){
$id = $_GET['id'];
		$uSql = "SELECT * FROM jos_classifieds_categories WHERE parent = '$id' AND published=1";
		$uResult = mysql_query($uSql, $connection);
		if(!$uResult){
		echo 'no data found';
		}else{
		while($uRow = mysql_fetch_array($uResult)){
		$name = $uRow["name"];

echo "<a href='test.php'>$name</a>" . "<br>";
}
}
}
?>

 

 

hope you could help me with this.

 

thanks!

Link to comment
Share on other sites
shamilton Newbie

shamilton

Posted
Posted

On line #4 you have:

 

$view = isset($_GET['view']) ? $_GET['view'] : $view="main";

 

You're missing a parenthesis set and you don't need to do $view =  anthing:

 

$view = (isset($_GET['view'])) ? $_GET['view'] : "main";

 

That should work.

Link to comment
Share on other sites
pixeltrace Advanced Member

pixeltrace

Posted
  • Author
Posted

hi,

 

still  not working.

http://mango.resonance.com.sg/myoochi/findit/test.php

i am still getting the same error.

below is my current code

<? 
include 'db_connect.php'

$view = (isset($_GET['view'])) ? $_GET['view'] : "main";

if ($view == "main"){
echo " 
<a href='test.php?id=328&view=sub'>Furniture, Fittings and Decor</a><br>
<a href='test.php?id=354&view=sub'>Interior Design</a><br>
<a href='test.php?id=355&view=sub'>Cleaning and Repairs</a><br>
<a href='test.php?id=367&view=sub'>Home Accessories and Appliances</a><br>
<a href='test.php?id=381&view=sub'>Home Alterations and Additions</a><br>
<a href='test.php?id=388&view=sub'>Architects, Engineering and Construction</a><br>
<a href='test.php?id=391&view=sub'>Home Entertainment</a><br>
<a href='test.php?id=395&view=sub'>Real Estate Agents</a><br>
<a href='test.php?id=397&view=sub'>Property Services</a><br>
<a href='test.php?id=401&view=sub'>Garden and Landscaping</a><br>
";
}
if ($view =="sub"){
$id = $_GET['id'];
		$uSql = "SELECT * FROM jos_classifieds_categories WHERE parent = '$id' AND published=1";
		$uResult = mysql_query($uSql, $connection);
		if(!$uResult){
		echo 'no data found';
		}else{
		while($uRow = mysql_fetch_array($uResult)){
		$name = $uRow["name"];

echo "<a href='test.php'>$name</a>" . "<br>";
}
}
}
?>

 

hope you could help me with this.

 

thanks!

Link to comment
Share on other sites
pixeltrace Advanced Member

pixeltrace

Posted
  • Author
Posted

thanks!

 

its working now.

 

i have another question, how can i display the listing result

in such a way that i can display the listing result in

2, 3 or 4 columns?

 

currently this is my code

 

<? 
include 'db_connect.php';

$view = (isset($_GET['view'])) ? $_GET['view'] : "main";

if ($view == "main"){
echo " 
<a href='test.php?id=328&view=sub'>Furniture, Fittings and Decor</a><br>
<a href='test.php?id=354&view=sub'>Interior Design</a><br>
<a href='test.php?id=355&view=sub'>Cleaning and Repairs</a><br>
<a href='test.php?id=367&view=sub'>Home Accessories and Appliances</a><br>
<a href='test.php?id=381&view=sub'>Home Alterations and Additions</a><br>
<a href='test.php?id=388&view=sub'>Architects, Engineering and Construction</a><br>
<a href='test.php?id=391&view=sub'>Home Entertainment</a><br>
<a href='test.php?id=395&view=sub'>Real Estate Agents</a><br>
<a href='test.php?id=397&view=sub'>Property Services</a><br>
<a href='test.php?id=401&view=sub'>Garden and Landscaping</a><br>
";
}
if ($view =="sub"){
$id = $_GET['id'];
		$uSql = "SELECT * FROM jos_classifieds_categories WHERE parent = '$id' AND published=1";
		$uResult = mysql_query($uSql, $connection);
		if(!$uResult){
		echo 'no data found';
		}else{
		while($uRow = mysql_fetch_array($uResult)){
		$name = $uRow["name"];

echo "<a href='test.php'>$name</a>" . "<br>";
}
}
}
?>

 

 

hope you could help me with this.

 

thanks!

Link to comment
Share on other sites
JayBachatero Newbie

JayBachatero

Posted
Posted

I think this should do what you want to do.  Just need to fix the link and make it point to where you want to.  Also change the # of columns.

 

<?php
include('db_connect.php');

$view = isset($_GET['view']) ? $_GET['view'] : 'main';

if ($view == 'main')
{
echo '
<a href="test.php?id=328&view=sub">Furniture, Fittings and Decor</a><br>
<a href="test.php?id=354&view=sub">Interior Design</a><br>
<a href="test.php?id=355&view=sub">Cleaning and Repairs</a><br>
<a href="test.php?id=367&view=sub">Home Accessories and Appliances</a><br>
<a href="test.php?id=381&view=sub">Home Alterations and Additions</a><br>
<a href="test.php?id=388&view=sub">Architects, Engineering and Construction</a><br>
<a href="test.php?id=391&view=sub">Home Entertainment</a><br>
<a href="test.php?id=395&view=sub">Real Estate Agents</a><br>
<a href="test.php?id=397&view=sub">Property Services</a><br>
<a href="test.php?id=401&view=sub">Garden and Landscaping</a><br>';
}
elseif ($view == 'sub')
{
$id = (int) $_GET['id'];
$uSql = "
SELECT *
FROM jos_classifieds_categories
WHERE parent = '$id'
	AND published=1";
$uResult = mysql_query($uSql, $connection);
if(!$uResult)
	echo 'no data found';
else
{
	$columns = 3;// How many columns?
	$counter = 0; // Start the counter.
	$width = 100 / $columns; // Set the width so that each cell is split up evenly.

	echo '
	<table>';

	while ($uRow = mysql_fetch_assoc($uResult))
	{
		// Open up the first row.
		if ($counter == 0)
			echo '
		<tr>';

		// Now for the data for each cell.
		echo '
			<td width="' . $width . '%"><a href="test.php">' . $uRow['name'] . '</a></td>';

		// Increase the counter.
		$counter++;

		// We have the max # of columns.
		if ($counter == $columns)
		{
			echo '
		</tr>';

			// Start fresh.
			$counter = 0;
		}
	}

	// We have some rows to close.
	if ($counter != 0)
	{
		// Lets fill in the missing cells.
		if ($columns - $counter > 0)
		{
			for ($i = 0; $i < $columns - $counter; $i++)
				echo '
			<td width="' . $width . '%"> </td>';
		}
		echo '
		</tr>';
	}

	// Close table.
	echo '
	</table>';
}
}

?>

Link to comment
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.