search mysql php script

[stream]

hi guys....

I've been days to learn phpscript and now would like to insert search script into my website.

the idea is I'd like the visitors to just click letter of a, b, c, etc in order to look up band names showing up their own songs (order by group of letter) from my song database (mysql). I've done trial n error so far (with phptriad) but it still showed error n sometime just blank

just today I got one script from internet (full script as attached), but again it showed
"....parse error in C:\apache\htdocs\search.php on line 22.."
I tried to modify to get rid of the errors, but still unlucky!

please anyone can advise me why? - assumed that I've created correctly database, tables in mysql (username n passwrd too)-

thank u good people!

[alex-party]

$trimmed = trim($var) //trim whitespace from the stored variable

should have ; at the end, like this:

$trimmed = trim($var); //trim whitespace from the stored variable

[stream]

thank alex, error now is gone. but overall the script result is not what I wanted. so I try to create another, but still get stuck anyway
may i ask u another thing? what is "sql statement" in order to retrieve certain fields from more than 1 table? (for instance, field1 from table1 and field2 from table2).

thank in advance alex or anybody who gives me help, very appreciated.

[alex-party]

you're welcome.
sql statement is a simple string that sent to the database from a programming language, like php in your case. here is examples:
a) "select * from users_table where username='blabla' and password='blabla'"

[stream]

big thanks again for your advice alex. I think "stuck" on my head now is gradually released