Hey guys,

Can anyone give me a mysql code to extract a certain users avatar onto the main site?

And I'm not using SSI! I don't even know how to set that up and it's just annoying.

Thanks

Make sure you replace _MEM_ID_ with the variable of the member id somehow.

Chad

wouldn't i have to connect to my db first?

Well yeah, I had assumed you would have already done that.

Without any relevance to what you already have, I can't exactly assume everything you have already completed.

All you asked for was the string to get the Avatar info from the database and that was it.
So thats what I gave you.

If you do not currently know how to connect to MySQL. I suggest reading into that. It will help you in the future for reference.

Chad

well ok you didn't have to be so direct jeez ._.

I am trying to be as helpful as I can be.
I can only do so much with what little information you have given.

In order to receive help, you must give as much information as possible without boring anybody.

All I am trying to do is get you to where you need to be.

Please, don't take my above post so defensive. I am trying to help you.
That is what I am here for. To help you.

My intent above was, to give you information so you know in the future.

As I stated before, I am here to help.

Chad

well it said i connected but

Connected to MySQL
Query failed : No Database Selected

i used this php/mysql code

<?php
$username = "USERNAME";
$password = "PASSWORD";
$hostname = "LOCALHOST";
$dbh = mysql_connect($LOCALHOST, $USERNAME, $PASSWORD)
or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
// you're going to do lots more here soon
$query = "SELECT avatar,avatar_size FROM ibf_members WHERE id='2'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
mysql_close($dbh);
?>

i'm using invision power board v2

This is where SQL bugs me sometimes.

You have to select the database after you connect. It would be nice if you could select the database you want within the mysql_connect() function. But you can't.

So here is what needs to done after connecting to MySQL:



With _DATABASE_NAME_ beng the actual database name.

Chad

That's why some people like Perl. :-"

*cough* Sorry for going off topic.

erm ok i'm lost >< where exactly in my code do i stick yours?

Someone already thought of that.

<?php
$username = "USERNAME";
$password = "PASSWORD";
$hostname = "LOCALHOST";
$dbh = mysql_connect($LOCALHOST, $USERNAME, $PASSWORD)
or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
@mysql_select_db("ibf_members") or die("Could not select database");
// you're going to do lots more here soon
$query = "SELECT avatar,avatar_size FROM ibf_members WHERE id='2'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
mysql_close($dbh);
?>

ok i used that and got

Connected to MySQL
Could not select database

when i tried using your code it said: Parse error: parse error, unexpected ')' in /home/jdi/public_html/pages/test.htm on line 18

Can someone just amend my code please?

ibf_members is not the database. Find $info['sql_database'] or something like that in conf_global.php.

oh crap yeah XD

well now i'm getting this

Parse error: parse error, unexpected ')' in /home/jdi/public_html/pages/test.htm on line 18

BTW, I just noticed something.



should probably be

Got it