[SOLVED] spacing

[amylou]

not sure if this is a php or mysql question so i am going to post in both places. sorry if this is the wrong forum.

 

i am looking to have spaces between the output from a query.

 

below is the code and then below that is what the output looks like

 

 

echo "<p><strong>These are the dates that you have requested off!!!!</strong></p>";


$sql ="SELECT first, last, requestedDate FROM timeoff WHERE last = '$last' AND first = '$first'";
$query=mysql_query($sql) or die("Query failed : " . mysql_error());

while($row = mysql_fetch_assoc($query))
{
echo "<p>";
echo $row['first'] ;	
echo $row['last'];	
echo $row['requestedDate'];
echo "</p>";

 

 

 

AmyCoppola2007-08-17

 

Amy Coppola2007-08-01

 

AmyCoppola2007-08-23

 

 

 

i only posted the section of code that is relevant i think

 

[nathanmaxsonadil]

??? I dont understand what you mean

[Fadion]

What is the question??

 

EDIT: Im just giving it a go with chance. If what u mean is to seperate with a space two mysql records then:

 

echo $row['first'];
echo " ";
echo $row['last'];

 

//it will output "First Last"

 

[lemmin]

I believe this is an HTML question, actually.

 

try:

echo $row['first'] . "<br><br>";	
echo $row['last'] . "<br><br>";	
echo $row['requestedDate'];

[amylou]

i would like to have a space between the name and the date

[nathanmaxsonadil]

use this

	echo "<p>";
echo $row['first'] ;	
echo $row['last']." ";	
echo $row['requestedDate'];
echo "</p>";

instead of this

	echo "<p>";
echo $row['first'] ;	
echo $row['last'];	
echo $row['requestedDate'];
echo "</p>";

[amylou]

AmyCoppola 2007-08-17

 

AmyCoppola 2007-08-17

 

Amy Coppola 2007-08-01

 

Amy Coppola 2007-08-01

 

AmyCoppola 2007-08-23

 

AmyCoppola 2007-08-23

 

 

this is the out put i get from using the last code from nathanmaxsonadil. puts a space but also doubles the output

[Fadion]

Is it me or no one cant see the double quotes in the output??

[nathanmaxsonadil]

Is it me or no one cant see the double quotes in the output??

what do you mean ???

[Fadion]

amylou is saying that the space is put, but it also have double quotes, which i cant see in the output he provided (the double quotes i mean). It was kinda ironic

[amylou]

what i meant to say was that it shows the output of what is there twice

 

ex.

 

amycoppola 2007-08-17

 

amy coppola 2007-08-17

 

 

does this for everything

[Fadion]

Oh my fault i thought u meant double quotes 

 

The code is just adding a space between records, it has nothing to do with duplicate records. U must have something in your code. Try posting the whole 'while' part of the script.

[AndyB]

Then it looks as though you have copy/pasted something in twice.

 

Approximately what you want is this:

$sql ="SELECT first, last, requestedDate FROM timeoff WHERE last = '$last' AND first = '$first'";
$query=mysql_query($sql) or die("Query failed : " . mysql_error());
while($row = mysql_fetch_assoc($query)) {
echo "<p>";
echo $row['first'] ." ". $row['last']. " ". $row['requestedDate'];
echo "</p>";
}

[amylou]

thank you all for your help. it now looks correct.