Forums

Boy, I'm just getting in way deeper that I had expected. I'm finding that to make everything work the way I want, I need to learn php, java script, and sql. Well I started an on line php course, and wonder of wonders, my web site now says hello to the world.

seriously, I'm butting my head up against a wall with the sql needed to display a table. It would appear that I need to create a where clause in that first section. For now, at least, all I want to do is display all the records, all the fields. If I can display SOMETHING I might be able to limit what is shown and how.

I've tried entering the following
where lname>' '
where lname='brown' (there is a record with the name brown in the field

Nothing is displayed, but at least i'm not getting 5 lines of syntax error messages.

Can someone provide some guidance on this issue for a frustrated newbe?

Thanks.

Hi cousinjay,

If you want everything displayed then leave the Where box empty.

It sounds as though you may not have anything in the body section. Try putting <table> in the header box, </table> in the footer and <tr><td>{lname}</td></tr> in the body box

Bob

PS The correct syntax for the Where box is WHERE `lname` = 'brown'