[RESOLVED] PHP/SQL Displays in table columns

[systm]

Hey Guys,

Looking for some help here, I am trying to output my SQL results into a table with 3 columns and having no luck. Every site I've seen doesn't work for me. Any help would be appreciated. Here is the code right now, It's just for one column and while I could include the code I have been working with I won't as it doesn't even work.

<?php
	require_once 'login.php';
	$db_server = mysql_connect($db_hostname, $db_username, $db_password);

if (!$db_server) die("Unable to connect to server: " . mysql_error());

mysql_select_db($db_database, $db_server)
	or die("Unable to select database: " .mysql_error());

$date = date("Y-m-d");

$sql = "SELECT * FROM pickups WHERE status = 'PENDING' AND date = '$date' AND type = 'WorkOrder' ORDER BY priority ASC";
$result = mysql_query($sql);
if (!$result) die ("Database access failed: " . mysql_error());
$rows = mysql_num_rows($result);

for ($j = 0 ; $j < $rows ; ++$j)
{
	$row = mysql_fetch_row($result);

echo <<<_END
<br><b>CALL NUMBER:</b> <a href="https://xxxx.xxxxx.xxx?JobType=$row[3]&JobNumber=$row[4]" class=info-text>$row[4]</a><hr width="100%">
<table class=text>
<tr>
<tr><td align="right"><b>TYPE:</b></td><td>$row[3]</td>
<tr><td align="right"><b>CITY:</b></td><td>$row[5]</td>
<tr><td align="right"><b>ADDRESS:</b></td><td>$row[6]</td>
<tr><td align="right"><b>ISSUE:</b></td><td>$row[7]</td>
<tr><td align="right"><b>AVAILABLE:</b></td><td>$row[8]</td>
<tr><td></td><td width=270>
<form action="process-pickup.php" method="get">
<input type="hidden" name="status" value="$row[10]" />
<input type="hidden" name="region" value="$row[2]" />
<input type="hidden" name="priority" value="$row[9]" />
<input type="hidden" name="type" value="$row[3]" />
<input type="hidden" name="number" value="$row[4]" />
<input type="hidden" name="grid" value="$row[5]" />
<input type="hidden" name="address" value="$row[6]" />
<input type="hidden" name="issue" value="$row[7]" />
<input type="hidden" name="available" value="$row[8]" />
<input type="hidden" name="contact" value="$row[11]" />
<tr><td><input type="submit" value="PICKUP CALL" /></td><td></td>
</form></td>
</tr></table>
_END;
}
	mysql_close($db_server);

function get_post($var)
{
return mysql_real_escape_string($_POST[$var]);
}

?>

Thanks again, R

[Copenhagener]

What exactly is it, that doesn't work? Which result do you see? Do you get any error messages? What do they say?

[systm]

The code above works PERFECTLY! the issue is how to take it and divide the results into 3 columns. Right now it just goes down 1 column.

[systm]

This is what I have so far, however I am getting a PARSE error "unexpected } on line 45"

<?php
	require_once 'login.php';
	$db_server = mysql_connect($db_hostname, $db_username, $db_password);

if (!$db_server) die("Unable to connect to server: " . mysql_error());

mysql_select_db($db_database, $db_server)
	or die("Unable to select database: " .mysql_error());

$date = date("Y-m-d");
$port = "101";


echo '<p>Search for domains containing <span style="color:#ff0000;font-weight:bold;text-decoration:underline;">"' . $_GET['searchname'] . '"</span>.</p>';
$query="SELECT * pickups where date = '$date'";
$result=mysql_query($query) or die (mysql_error());
// Use result
// Set column count

 $columns = 2;
 $rowCount = mysql_num_rows($result);

    echo '<p>There are currently <span style="color:#ff0000;font-weight:bold;text-decoration:underline;">' . $rowCount . '</span> pickup requests for your system.</p>';

    // Calculate how many records per column
    $html = '<table width="100%"><tr>';

    $x = 1;

    while ($row = mysql_fetch_assoc($result)) {

        $html .= '<td width="50%"><a href="https://xxxxx.xxxxx.xxx/,DanaInfo=techportal.oss.prd+WorkdayDetails.aspx?JobType=' . $row['type'] . '">' . $row['number'] . '</a></td>';

        $html .= ($x++ % $columns == 0) ? '</tr><tr>' : '';

    }

    $html .= '</tr></table>';

    echo $html;

    mysql_free_result($result);

    } else {

                echo '<p style="color:#ff0000;font-weight:bold;">Nothing found.</p>';

?>

[Copenhagener]

First, find the unexpected } and fix that. Then try again and report what new error you get.

Apart from that, it looks strange that you use both a while expression and a counter for the same job; retrieving data for the coloumns. Clean it so that you are using only the while expression or the counter.

[systm]

I've tried to find the syntax error but no luck, as far as I see the } all add up with their respective {

[Derokorian]

        mysql_free_result($result); 

    } else { 

                echo '<p style="color:#ff0000;font-weight:bold;">Nothing found.</p>'; 

I do not see a matching if statement.

[systm]

I got fixed, took @ advice and got my functions sorted out. I works great now.

here is the final code so if anyone out there who was like me and spent hours searching, here it is. all you need to do is change the columns #.

<?php
	require_once 'login.php';
	$db_server = mysql_connect($db_hostname, $db_username, $db_password);

if (!$db_server) die("Unable to connect to server: " . mysql_error());

mysql_select_db($db_database, $db_server)
	or die("Unable to select database: " .mysql_error());

$date = date("Y-m-d");
$port = "101";


echo '<p>Search for domains containing <span style="color:#ff0000;font-weight:bold;text-decoration:underline;">"' . $_GET['searchname'] . '"</span>.</p>';

$query="SELECT * FROM pickups where date = '$date'";
$result=mysql_query($query) or die (mysql_error());
// Use result
// Set column count

 $columns = 4;
 $rowCount = mysql_num_rows($result);

    echo '<p>There are currently <span style="color:#ff0000;font-weight:bold;text-decoration:underline;">' . $rowCount . '</span> pickup requests for your system.</p>';

    // Calculate how many records per column
    $html = '<table width="100%" border="1" class="text"><tr>';

    $x = 1;

    while ($row = mysql_fetch_assoc($result)) {

        $html .= '<td>' . $row['type'] . ': <a href="https://xxx.xxxxx.xxx/,DanaInfo=techportal.oss.prd+WorkdayDetails.aspx?JobType=' . $row['type'] . '">' . $row['number'] . '</a>
        <br>Address: ' . $row['address'] . '</td>';

        $html .= ($x++ % $columns == 0) ? '</tr><tr>' : '';

    }

    $html .= '</tr></table>';

    echo $html;

    mysql_free_result($result);
?>