shouldn't print?

[devil_online]

i type this code

<?php
$user = "root";
$pass = "";
$db = "forumcaf_golo";
$link = mysql_connect( "localhost", $user, $pass );
 if ( ! $link ) {
   die( "Couldn't connect to MySQL: ".mysql_error() );
 }

 mysql_select_db( $db, $link )
   or die ( "Couldn't open $db: ".mysql_error() );

$result = mysql_query( "SELECT 'team' FROM username ='devil' " );
print "$result";

 // summarise data

 mysql_close( $link );
?>

But should't this code print the team of the user devil?
(I've inserted already this data in a table of mysql)

thanks

[LordShryku]

$result = mysql_query( "SELECT 'team' FROM username ='devil' " );

Think you're missing some vital pieces here. First, remove the single quotes around "team". Second, it looks like table name and WHERE are missing.
SELECT team
FROM [table]
WHERE username ='devil'

Third, you have to fetch the results using one of the fetch commands. See those in the manual.

[TheDefender]

You gotta dig into the manual on this one. It looks as though you haven't spent too much time in it.

The mysql_close( $link ); isn't needed either, as PHP will automatically close the connection when no other link is needed to be opened.

Also, you don't need to run this if statement:
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link ) {
die( "Couldn't connect to MySQL: ".mysql_error() );
}

Instead, you can just do this:
$link = mysql_connect("localhost", $user, $pass) OR die("Couldn't connect to MySQL: ".mysql_error());

Open the manual and learn, learn, learn...

[devil_online]

Open the manual and learn, learn, learn...

this is the code of a manual i'm reading.....

Think you're missing some vital pieces here. First, remove the single quotes around "team". Second, it looks like table name and WHERE are missing.

I've made this changes and now tha page gives me this message:

Resource id #3

What's this? and how I corrected? thanks

[TheDefender]

Originally posted by devil_online
this is the code of a manual i'm reading.....

What manual are you reading? OK nevermind... Here's what you want to know. When you query the DB, all that does is check for values based on any criteria you specify. After that, you have to fetch the results in order to display them... What I gave you below, will loop you through all results returned where that username is equal to devil, and echo them all out. P.S. You gotta change the mysql_query portion so it has your table name in it.

<?php 
$user = "root"; 
$pass = ""; 
$db = "forumcaf_golo"; 
$link = mysql_connect( "localhost", $user, $pass ); 
 if ( ! $link ) { 
   die( "Couldn't connect to MySQL: ".mysql_error() ); 
 } 

 mysql_select_db( $db, $link ) 
   or die ( "Couldn't open $db: ".mysql_error() ); 

$result = mysql_query( "SELECT team FROM INSERTTABLENAMEHERE WHERE username ='devil' " ); 

while($row = mysql_fetch_array($result)){
echo $row['team']."<br />";
}
?> 

[dalecosp]

Originally posted by devil_online
this is the code of a manual i'm reading.....


I've made this changes and now tha page gives me this message:

Resource id #3

What's this? and how I corrected? thanks [/B]

This is telling PHP that the database query was a valid one, and the SQL server is holding a resource for PHP to fetch, using something like [man]mysql_result[/man], [man]mysql_fetch_array[/man], [man]mysql_fetch_row[/man], [man]mysql_fetch_object[/man], etc.

And here's the [man]manual[/man] you should be reading.

Cheers,

[devil_online]

i'm reading Sam's tech php in 24 hours (just by the case)

now..about the code..it works...thanks very much 😃

[LordShryku]

Someday, I'm gonna hit you with a stick Defender :p

This is such a widespread, constantly covered topic, you really shouldn't have written the code for him.

The third point in my first post told you this, and on just about every page of the php manual for mysql functions, an example exists. Not to mention the countless amount of examples on these boards.

But I digress...

[devil_online]

ok sorry...and thanks to all

[TheDefender]

I know, I know LordShryku... 😃
I just felt like this one needed to be resolved quickly...
You sound like my Grandmother... "Go fetch me a switch boy... Uh, yeah right old lady!" LOL

devil, do yourself a favor, and throw away the Sam's "Teach Yourself PHP in 24 hours" book, and stick to the PHP Manual that dalcosp was nice enough to post...

Just a guess, but I think it's going to take a little longer than 24 hours for you... especially if you don't read the book properly, and apply the examples they give in there properly. Trying to shortcut your learning curve is the worst thing you could ever do for yourself.

[dalecosp]

Originally posted by LordShryku
Someday, I'm gonna hit you with a stick Defender :p

<snip>

But I digress...

&& in the process, you missed picking up the LART :eek:

Not that we think Defender is a 'luser' ... but maybe occasionally too nice for the collective good.

"Give a man a fish...." 😉

[TheDefender]

Thanks dale... (I think :p )

[[ dodges the mighty swing of the LART, and sips down on the mai tai enjoying the cool breeze it generated ]]

I ain't flipping my cross over either, but I will buckle down and not be so nice anymore... How's this for a start?:glare:

[dalecosp]

ROFL!

/me ducks, lest vengeance in the form of flaming hot lead end my life prematurely...

[edit] I did say occasionally ...[/edit]

[LordShryku]

/me dangles a donut in front of your face...
"gimme the gun...."
mmmmmmmmm.......donut.........

[TheDefender]

{gurgle.... doughnuts... mmmmmmm....}

Newbies beware... Now, I got a full stomach... 😉