making it look like something

Anon

i am not quite sure where to look, or what topic to look under

problem being - not that the table in my database works, when i bring it up in a browser - all 4 sample entries i have show as a continous line of text - ideally they should show as 4 separate entries in a database - could anyone direct me to where i can find instructions and/or info on this
i want to create the effect that each entry is separate - possibly a diff coloured background on each entry - also a way to inatall a link to open a page giving more detail on the selected entry?

hope i am clear on what i would like to acheive with this
thanks
mike

fahhem

put \n at the end of the last column of each entry.

herve

somewhere in your code you have something
like this :

do
{
$firstname = $myrow ["firstname"];
print $firstname;
}
while ($myrow=$mysql_fetch_array($result);

you should have :

$firstname = $myrow ["firstname"];
print "$firstname<BR>\n";

The <BR> is the HTML tag for "break"
the line (a carriage return if you
prefer) and the \n is to beautify
your HTML source in case you want to
read it (for checking errors for
instance)

Anon

i do not have that in my code
i tried inserting and changing to point to my table and colum, just got a parse error

herve

Can you show us your code (relevent part) ?

Anon

<?

// Step 1, connect to the database server
if (!$rDatabaseConnection = mysql_connect(localhost, cantrack, bwYxXzYn))

{

// Step 1 failed, fatal error
echo 'Could not connect to database server';

}

else

{

// Step 2
// Select a database to work with
if (!mysql_select_db('simplysold_com', $rDatabaseConnection))

{

// Step 2 failed
// Not being able to select a database means we can't run queries on it.
echo 'Could not select database';

}

else

{

// Step 3
// Run a query.
// Note that the query is run on the $rDatabaseConnection that I opened in step 1.
$sQuery = "SELECT computersniagaraDate, computersniagaraID, computersniagaraCost, computersniagaraText FROM computersniagara";

if (!$rResult = mysql_query($sQuery, $rDatabaseConnection))

{

// Step 3 failed.
// The query was not executed.
// This is most likely because there is a syntax-error in the query,
// so I print the error message that MySQL gave me,
// and I print the Query that I was trying to run.
echo 'SQL query failed:';

echo mysql_error($rDatabaseConnection)."<BR>";

echo $sQuery."<BR>n";

}

else

{

// Step 4
// The query worked, now see if it gave any results
if (mysql_num_rows($rResult)>0)

{

// Step 5
// Yay, results found, process them
while ($aRow = mysql_fetch_array($rResult, MYSQL_ASSOC))

{

echo $aRow['computersniagaraID'].' '.$aRow['computersniagaraDate'].' '.$aRow['computersniagaraCost'].' '.$aRow['computersniagaraText'];

};
}

else

{

// Step 4 failed
// No results found
echo 'Your query did not return any results';

}; // end of step 4
}; // end of step 3
}; // end of step 2
}; // end of step 1