php changing the width of a table column

Question

Having a few issues with changing my column width and changing it through

colspan='2'

works up till my while loop where it throws the error

Parse error: syntax error, unexpected T_LNUMBER, expecting ',' or ';'

Any help, heres my code:

echo "<table border='0', width='100%'><tr><th colspan='2'>ID</th>
                     <th colspan='2'>First Name</th>                             
                     <th colspan='2'>Last Name</th><th colspan='2'>Location</th>
                     <th colspan='2'>Last Updated</th></tr>";
    while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC))
    {

        echo "<tr><td colspan='2'>" .$row['userID'].' </td><td colspan='2'> '.$row['first_name'].' </td><td colspan='2'> '
        .$row['last_name'].' </td><td colspan='2'> '.$row['current_location'].' </td><td colspan='2'> '
        .$row['last_updated']->format('Y-m-d H:i:s'). "</td><tr>";
    }

    echo "</table>";

Not sure if that will solve anything, but you've got a comma where it's not needed on line 1 : border='0', width='100%' — Alexis_A
– Alexis_A, Commented May 8, 2017 at 21:44
You're using single quote as the delimiter around the strings and also the delimiter around the colspan='2' attribute. — Barmar
– Barmar, Commented May 8, 2017 at 21:44

Omi · Accepted Answer · 2017-05-08 21:51:52Z

1

Your are doing wrong concatenation

paste this inside while loop:

echo "<tr><td colspan='2'>" .$row['userID']." </td><td colspan='2'> ".$row['first_name']." </td><td colspan='2'> "
        .$row['last_name']." </td><td colspan='2'> ".$row['current_location']." </td><td colspan='2'> "
        .$row['last_updated']->format('Y-m-d H:i:s'). "</td><tr>";

or

Simply use

<tr>
<td colspan='2'><?php echo $row['userID'];?>
<td colspan='2'><?php echo $row['first_name'];?></td>
<td colspan='2'><?php echo $row['last_name'];?></td>
<td colspan='2'><?php echo $row['current_location'];?></td>
<td colspan='2'><?php echo $row['last_updated']->format('Y-m-d H:i:s'); ?></td>
<tr>

edited May 8, 2017 at 21:51

answered May 8, 2017 at 21:45

Omi

4,0175 gold badges24 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Barmar · Accepted Answer · 2017-05-08 21:46:24Z

0

The problem is that you're using the same quotes as the delimiters around the PHP strings and around the attribute values inside the string, e.g.:

' </td><td colspan='2'> '

Change one of them to double quotes:

' </td><td colspan="2"> '

or

" </td><td colspan='2'> "

Or escape the quotes inside:

' </td><td colspan=\'2\'> '

answered May 8, 2017 at 21:46

Barmar

789k57 gold badges555 silver badges669 bronze badges

1 Comment

Charliejb Over a year ago

Thank you for your help!

lotfio · Accepted Answer · 2017-05-08 21:47:17Z

0

Pay attention to your concatenation You are using single quotes for both string and colspan attribute inside your loop

 while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC))
 {

    echo "<tr><td colspan='2'>" .$row['userID']." </td><td colspan='2'> 
   ".$row['first_name']." </td><td colspan='2'> "
   .$row['last_name']." </td><td colspan='2'> ".$row['current_location']." 
  </td><td colspan='2'> "
.$row['last_updated']->format('Y-m-d H:i:s'). "</td><tr>";

}

answered May 8, 2017 at 21:47

lotfio

1,9362 gold badges20 silver badges34 bronze badges

1 Comment

Charliejb Over a year ago

Appreciate you taking the time, thanks this was the problem!

Collectives™ on Stack Overflow

php changing the width of a table column

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related