Hi Ben,<br><br>Followed your instructions but now get:<br><br>"Unable to include adodb.inc.php"<br><br>Instead of my home page.<br><br>Any ideas?<br><br>Thanks,<br><br>Jon<br><br>Hi<br><br><div><span class="gmail_quote">
On 9/26/07, <b class="gmail_sendername">Ben Stallings</b> <<a href="mailto:ben@interdependentweb.com">ben@interdependentweb.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Jon Fowler wrote:<br>> I took out the Select Query with comment so my config now looks like:<br>><br>> $Databases['connection_name'] = array(<br>> 'driver' => 'mysql',<br>> 'hostname' => '
<a href="http://sql2.byethost13.com">sql2.byethost13.com</a> <<a href="http://sql2.byethost13.com">http://sql2.byethost13.com</a>>',<br>> 'database' => 'b13_961097_central',<br>> 'username' => 'b13_961097',
<br>> 'password' => 'lionheart');<br><br>Looks fine, except I'd recommend you change 'connection_name' to<br>something meaningful to you, such as 'central'.<br><br> > #$FarmD/cookbook/selectquery.php
<br><br>This is probably why your wiki disappeared, when the line wasn't<br>commented out. The syntax for including a file is<br><br>include "$FarmD/cookbook/selectquery.php";<br><br>or if you're using DataQuery instead,
<br><br>include "$FarmD/cookbook/dataquery.php";<br><br>> Also I can't find any simple info on how to call a table. Is there a<br>> guide on this I'm missing? Or something simple on MySQL syntax?<br>
><br>> Sorry for being dim. I'll write the guide for other dummies once I get<br>> it...!<br><br>Yah, I realize the docs could use some work, and thanks for your offer<br>to help! If you're going to use DataQuery, then assuming you have the
<br>include_once line above, your next step is to go to the<br>DataQuery.DataQuery page of your wiki and see if you can list the<br>contents of the table. See instructions at<br><a href="http://workscited.net/dataquery/Main/StatusScreen">
http://workscited.net/dataquery/Main/StatusScreen</a> .<br><br>You may also want to install DataPlates, as it will save you a lot of<br>work creating templates.<br><br>Let me know how it goes! --Ben<br></blockquote></div>
<br>