outputting data neatly.

crazylegseddie

Hi everyone. Ive set up my script to output a field from my database e.g. pd_more text NULL. I used a text feild because a lot of data is needed to be entered. Through php i echo these details but i need to display them neatly in lines. ie the information is currently being displayed like.

Love Sensation '06 (Hi_Tack Mix) Loleatta Holloway Gusto >02. We Are Your Friends (Lee Cabrera Re Mix) Justice vs Simian Ten / Virgin >03. S.O.S. (Moto Blanco Re Mix) Rhianna Def Jam / Mercury >04. All I Need (Fuzzy Hair Re Mix) Ill Beat Hustlers Lowered Recordings >05. Touch It (Mary J Blige & Missy Elliott Re Mix)

when i need it to be displayed like:

Love Sensation '06 (Hi_Tack Mix) Loleatta Holloway Gusto

We Are Your Friends (Lee Cabrera Re Mix) Justice vs Simian Ten / Virgin

S.O.S. (Moto Blanco Re Mix) Rhianna Def Jam / Mercury
etc etc

Any assistance will be appreciated. Thank you

Houdini

Show the code you presently have it should be easy to do that with a <br />

crazylegseddie

i use this code to retrieve the field data:

<?php
require_once '../library/config2.php';
$result = mysql_query('SELECT pd_more, pd_name FROM tbl_product WHERE pd_id = ' . $_GET['pd_id']) or exit(mysql_error());
$row = mysql_fetch_assoc($result);
echo $row['pd_more'];
?>

Houdini

Try this

<?php
require_once '../library/config2.php';
$result = mysql_query('SELECT pd_more, pd_name FROM tbl_product WHERE pd_id = ' . $_GET['pd_id']) or exit(mysql_error());
$row = mysql_fetch_assoc($result);
echo $row['pd_more']."<br />";
?>

crazylegseddie

I tried that but it had no effect on the output 🙁

Houdini

It should in a browser but then just do this

echo $row['pd_more']."<br />\r";

bradgrafelman

Houdini - all of those records are coming down in one row... the line break need's to be between each of them.

Try something like this:

$row = mysql_fetch_assoc($result); 

$output = explode('>', $row['pd_more']);
array_shift($output);

foreach($output as $line)
	echo '>' . $line . '<br />';

EDIT: Changed code above... should work now.

crazylegseddie

cool that worked. Thanx alot. One more thing. Im trying to attach my stylesheet to it by using the require_once 'header.php'; command (which maintains the link to my stylesheet) but when i do this the page outputs as a blank screen. Ive tried to import the stylesheet directly into my pd_more page but does not seem to read it?

crazylegseddie

Having one more problem with my edit which I hope soemone can help me with. Im having trouble passing the client id on to update the record. on the edit page i have

echo "<input name = \"Client_ID\" type=\"hidden\" value=\"".$id."\">";

to pass the id to the process page

and on the process page i have:

<?php
require '../include/config.php';
id=$POST['Client_ID'];
$firstname=$POST['First_Name'];
$lastname=$_POST['Last_Name'];

if (!get_magic_quotes_gpc())
{
$firstname=addslashes($firstname);
$lastname=addslashes($lastname);
}
$sql = "update client SET
First_Name='$firstname',
Last_Name='$lastname'
where Client_ID='$id'";
$result = @($sql);
if ($result)
echo 'Record Edited Successfully';
else
echo 'Record Not Edited';
?>
If i manually change the ID the query works but this script is unable to recognize the clients ID automatically! Can someone inform me of what I am doing wrong.

Thank You

bradgrafelman

Is this not a duplicate of this post?

crazylegseddie

yes sorry! accidently wrote that one in the wrong topic 😐 but if anyone can still help me on the stylesheet problem as stated before, that would be good 🙂

crazylegseddie

The previous method you displayed did not work for all data entered. The screen would read blank if a row wa snot recognised but the script was fixed with this:

echo $row['pd_more'] = nl2br($row['pd_more']);