Correct use of brackets

[Iceman512]

Hi everyone,

 

Could someone please shed some light on the correct use of brackets { and } in a MySQL query.

 

For example, I understand that the following query is not entirely correct:

<?php
$sql = "SELECT id, title, date, description, publish FROM $dbtable WHERE title LIKE '$search%' || body 
LIKE '$search%' && publish='yes' ORDER by id DESC LIMIT '$offset', '$limit'";
?>

 

Rather, the following should be used but is this actually correct?:

<?php
$sql = "SELECT id, title, date, description, publish FROM $dbtable WHERE title LIKE '{$search}%' || body
LIKE '{$search}%' && publish='yes' ORDER by id DESC LIMIT '{$offset}', '{$limit}'";
?>

 

I have looked this up on the net, but there seem to be many conflicting opinions.

 

Thanks to anyone who can shed some light.

Regards,

Iceman

[MadTechie]

personally i only use{} when i include an array ie

 

$sql = "SELECT id, title, date, description, publish FROM $dbtable WHERE title LIKE '$search%' || body 
LIKE '$search%' && publish='{DATA['publish']}' ORDER by id DESC LIMIT '$offset', '$limit'";

 

 

note the publish='{DATA['publish']}'

[HuggieBear]

Check out the Variable Parsing in the PHP manual for a better understanding.

 

It covers both simple and complex (curly) syntax.

 

Regards

Huggie

[Iceman512]

Ok, I see.

 

Thanks for the replies. I'll take a look.

 

Regards,

Iceman