Jeff Holzfaster wrote:
>
> Where is a good place to find help with some basic sql? I am having a
> problem getting the query results I need. Don't tell me to consult the
> manual because that is the first place I turned to. I just need a real life
> example of the solution to see be able to pick it apart. I posted the
> request to this list (see Two table query help...) and only got one off-list
> reply that didn't help. Is there a better place to get such assistance or a
> better way of requesting it here???
>
> -- A Newbie
Jeff:
The way it works is thusly:
Send an example of the query you're having trouble with. Indicate whether the
query is executed in a PHP, c, or perl application.
Send the result of the query, or error messages if they exist.
Ex.:
The query:
$rs2=mysql_query(
"select count(*) from dlg where hid='$UId' and
(dlgdate >= DATE_SUB(now(), INTERVAL 31 DAY)
and (dlgdate <= '$DlgNow'
and
dialog like '%$rowexpl[expletive]%'))");
PHP application.
Result in this example is successful. No errors.
Start from there. You could also get Paul Dubois excellent book: ISBN
0-7357-0921-1.
Best Regards,
Van
--
=================================================================
Linux rocks!!! http://www.dedserius.com/
=================================================================
