[Webdev] writing SQL neatly.

[adam beecher]

Which just happens to be < 76 chars.

LOL


> > All rather neat and tidy, makes it easy to read. How do the rest of you
> > write your SQL?
> >
> Break at the screen width. :)
> 
> $query  = "INSERT INTO cork
> (aid,term,constructs,definition,useEx,useDef,derivation,more) VALUES ";
> $query .=
> "('$aid','$term','$constructs','$definition','$useEx','$useDef','$deri
> vation','$
> more')";
> mysql_query($query);
> 
> Most of my SELECTS are fairly simple, since I haven't needed complex searches
> yet.
> 
> Ok, Donncha - there's your first topic for the BOF, you can train me up too:
> 
> "Searching a MySQL database."
> 
> adam
> 
> 
> _______________________________________________
> Webdev mailing list
> Webdev at linux.ie
> http://www.linux.ie/mailman/listinfo/webdev
>