Jump to content

Archived

This topic is now archived and is closed to further replies.

Revan

IPB 'Syndicate'

Recommended Posts

Hello, my name is Revan and I am very new to PHP. My question is directed towards anyone who is familiar with the MySQL database setup of Invision Power Boards. What I want to do is connect to the MySQL database, get the topic title if it has a certain description, the url, and save it to be displayed in a sidebar for a webpage. As of the moment, I cannot say the address of the page... Here is the code so far:[code]<?php
require('config.php');

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$sql = 'SELECT `title` FROM `ibf_topics` WHERE `description`=\'=SCDTI=\'';

mysql_close($conn);

?>[/code]

Any help would be appreciated  ;)

Share this post


Link to post
Share on other sites
Welcome to the board. We have a specific forum for help with third party scripts, this really should be posted in there.

Share this post


Link to post
Share on other sites
$sql = 'SELECT `title` FROM `ibf_topics` WHERE `description`=\'=SCDTI=\'';
change to $sql = "SELECT `title` FROM `ibf_topics` WHERE `description`= '=SCDTI=' "; and try again.  also, you need a query statement in there.
Like:
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo $row['id'] // assuming your database has an 'id' field. Replace ID with feild name.  You could also use a loop here.\

Hope this helps.  I was recently stuggling with this too.

Share this post


Link to post
Share on other sites
Yeah I see now. Anyway.. sorry, im not familiar with IPB... you might be lucky though.

Share this post


Link to post
Share on other sites
[quote author=ChaosXero link=topic=100874.msg398582#msg398582 date=1153142842]
$sql = 'SELECT `title` FROM `ibf_topics` WHERE `description`=\'=SCDTI=\'';
change to $sql = "SELECT `title` FROM `ibf_topics` WHERE `description`= '=SCDTI=' "; and try again.  also, you need a query statement in there.
Like:
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
echo $row['id'] // assuming your database has an 'id' field. Replace ID with feild name.  You could also use a loop here.\

Hope this helps.  I was recently stuggling with this too.

[/quote]

Thanks. I'll try that as soon as the webmaster gets online.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.