Show Apostrophe (') with sql recset

Question

I do not know what the best option in my case is:

I use a SQL query (built into a php file) to feed na excel chart.

PROBLEM: My first column is made of complex serial numbers (such as 08/18), when excel updates the query, these numbers are automatically transformed into August/18.

BEST SOLUTION (That I can think of):

Edit php file to place a ' before the serial number, that way, when excel updates, it won´t transform into date (I think...)

How can I achieve this?

This is my code:

  <? while($sql1_recset = mysql_fetch_array($sql1)) {?>
    <tr>
    <td><?=$sql1_recset['ID'];?></td>
</tr>
<?}?>
</table>
</body>
</html>

I tried a few things, but I do not get PHP:

 <td><?{echo("'").echo($sql1_recset['ID']);?}></td>

doesn´t work

<td><?{echo("'")}&=$sql1_recset['ID'];?></td>

doesn´t work

 <td><?{echo("'")&$sql1_recset['ID'];?></td>

doesn´t work

`="'" . $sql1_recset['ID'];?>` - See [PHP docs for string operators](http://php.net/manual/en/language.operators.string.php) — frobinsonj, Nov 27 '18 at 13:20
Jeee! That was much simpler than I thought! Problem solved! Please answer the question so I can award you and thanks! — ROCA, Nov 27 '18 at 13:23

score 0 · Accepted Answer · answered Nov 27 '18 at 13:32

0

You can concatenate strings in php using .. Have a read of the PHP docs for string operators.

You've tried two different things so to make this semi-worth the answer, I've included the corrected way of doing both:

<td><?="'" . $sql1_recset['ID'];?></td> - <?= is the shorthand for echo, available by default since PHP 5.4
<td><? echo "'" . $sql1_recset['ID']; ?></td>

answered Nov 27 '18 at 13:32

frobinsonj

1,109
9
21

1

Why not just `'=$sql1_recset['ID'];?>`? – Álvaro González Nov 27 '18 at 13:46
Yeah that also works haha @ÁlvaroGonzález, however, it's more situation specific. This gives a more general knowledge on how to concatenate strings, something that OP didn't know how to do before. – frobinsonj Nov 27 '18 at 13:47

Show Apostrophe (') with sql recset

1 Answers1