The query seems OK. The problem is PHP doesn't access the database directly. You must first connect to the db and then retrieve the data. Please read this tutorial: http://www.freewebmasterhelp.com/tutorials/phpmysql/4
Tiago Relvão On 11/9/05, Jay Horvitz <[EMAIL PROTECTED]> wrote: > > I can get the entire database 10 records at a time, that is not the > problem, I want to just show one particular letter of artists like L or M or > whatever. > > Pete <[EMAIL PROTECTED]> wrote:In message <[EMAIL PROTECTED]>, > jmhorvitz <[EMAIL PROTECTED]> > writes > >If I wanted a > >artist that starts with the letter L I would click on the L link and > >it would show just the L's. Right now I have it working so it shows > >the entire database 10 records at a time. > > > >When I try the code" > ><a href="<?php SELECT artist_name FROM artist WHERE artist_name > >LIKE 'L%' ?>" />L</a> blah blah I get the following error: > > > >Parse error: parse error, unexpected T_STRING in..... > > You are a long way out with your example. > > As there are so many ways to do it, the simplest way is to ask, how you > get the 'entire database 10 records at a time'? Then we can adapt that. > > -- > Pete Clark > > http://www.hotcosta.com > http://www.spanishholidaybookings.com > > > > > The php_mysql group is dedicated to learn more about the PHP/MySQL web > database possibilities through group learning. > > > > SPONSORED LINKS > American general life and accident insurance company American general life > insurance company American general life American general mortgage American > general life insurance Computer internet security > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "php_mysql" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > > > Jay Horvitz > 309-253-8750 (cell) > [EMAIL PROTECTED] > > --------------------------------- > Yahoo! FareChase - Search multiple travel sites in one click. > > [Non-text portions of this message have been removed] > > > > > > > > The php_mysql group is dedicated to learn more about the PHP/MySQL web > database possibilities through group learning. > Yahoo! Groups Links > > > > > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
