I am trying to run the following code in a vbulletin php page:
$theuserid = "2";
$file_name = $DB_site->query("SELECT file FROM user WHERE userid = $theuserid");
$site_text = $DB_site->query("SELECT site_text FROM user WHERE userid = $theuserid");
$site_link = $DB_site->query("SELECT site_link FROM user WHERE userid = $theuserid");
$banner = "<a target=\"_blank\" title=\"$site_text\" href=\"$site_link\"><img alt=\"$site_text\" src=\"http://www.thewebsite.com/images/banners/$file_name\" width=\"468\" height=\"80\" border=\"0\"></a>";
//$DB_site->query("UPDATE user SET total=total+1 WHERE userid = $theuserid");
//$DB_site->query("UPDATE user SET impressions=impressions-1 WHERE userid = $theuserid");
print $banner;

file where userid = 2 in table "user" contains the value: 2.gif
site_text where userid = 2 in table "user" contains the value: The Alternate Text
site_link where userid = 2 in table "user" contains the value: http://www.thewebsite.com

Why is the output this?:
<a target="_blank" title="Resource id #21" href="Resource id #22"><img alt="Resource id #21" src="http://www.thewebsite.com/images/banners/Resource id #20" width="468" height="80" border="0"></a>

First of all I would suggest checking your database, to confirm that the info is not all the same as that appears to be the problem from looking at your source, it seems fine.

Originally posted by barrywien
First of all I would suggest checking your database, to confirm that the info is not all the same as that appears to be the problem from looking at your source, it seems fine.

I repeat:
file where userid = 2 in table "user" contains the value: 2.gif
site_text where userid = 2 in table "user" contains the value: The Alternate Text
site_link where userid = 2 in table "user" contains the value: http://www.thewebsite.com

I have checked my database with phpmyadmin and the values above are inserted into the fields.

Ok try replacing the code with the following:$theuserid = "2";
$filename = $DB_site->query("SELECT file FROM user WHERE userid = $theuserid");
$sitetext = $DB_site->query("SELECT site_text FROM user WHERE userid = $theuserid");
$sitelink = $DB_site->query("SELECT site_link FROM user WHERE userid = $theuserid");
$banner = "<a target=\"_blank\" title=\"$sitetext\" href=\"$sitelink\"><img alt=\"$sitetext\" src=\"http://www.thewebsite.com/images/banners/$file_name\" width=\"468\" height=\"80\" border=\"0\"></a>";
//$DB_site->query("UPDATE user SET total=total+1 WHERE userid = $theuserid");
//$DB_site->query("UPDATE user SET impressions=impressions-1 WHERE userid = $theuserid");
print $banner;I didnt mean to sound rude above, but its always best to be 100% sure with this sort of problem.

The above may work, but obviously I havnt tested it, and its 1:03AM so my eyes are closing slowly at the moment.

I didn't mean to sound rude either if I did, lol.
Sadly, that code gives me the same results. :(

I don't know what the heck is going on. This code should work fine.

Most queries return result sets, not individual values. I'd check the DB_site class and see if there's a version of ->query that returns a single value when there is a single column/row result. Or use the mysql_fetch_* functions on what I'm assuming is the result set returned from ->query.

Chris

I believe you need to use $DB_site->fetchrow() or something along those lines.

Call to undefined function: fetch()
Call to undefined function: fetch_row()
http://www.vbulletin.com/docs/html/main/codestandards_sql_query

Looks like you need:

$DB_site->query_first

based on that vb link you pasted.

Chris

Yea, I did. I also had to add some other code so the variable wasn't storing the actual db call or whatever.

checking your database good idea

Originally posted by igor99
checking your database good idea Checking my database?