• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

More easy stuff :-)

Having performed a successful select, how can I refer to the result? (i.e. how could I assign a variable name to the result? Should that not be possible, how could I say if the result from the above query = x then...?

I've been looking at mysql_use_result() however I am totally confused by the MYSQL_RES bit.

Where does that need to be inserted?
What does it do?
0
dht1
Asked:
dht1
  • 6
  • 5
1 Solution
 
gravityCommented:
Ok then, remember the question you asked where I gave you the select code ? I assume that you'll store the SQL to execute it in $sql for this example.

<?
   $query = mysql_query($sql);
   while ($row = mylsq_fetch_row($query)) {
      $result = $row[0];
   }
?>

The thing is that $row is an array containing the fields from the SQL query for that row.
0
 
dht1Author Commented:
hehe... I actually worked it out a couple of hours ago (and neglected to delete the question)... oh well - it's clearly been another opportunity for you to show off your skills! :-)

Cheers!
0
 
gravityCommented:
Skills ? I'm actually a musicien more than programmer :)

(check out my profile !)
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
dht1Author Commented:
Checked out your profile.
Wonderful. I used to play trumpet & piano too. I still play the piano, but I gave up on the ol' trumpet quite a while ago.

Should you care, I'm a final year uni student. Sadly I opted to take computer science as my major - pretty dumb considering my hatred for programming. I'm actually studying comp sci and business administration, and I tell you what, a first in business is nothing compared to a first in computing... and I clearly won't be getting one of those!

....and now I have the pleasure of dealing with a parse error. I musta put my ifs, elses and endifs in the wrong places... Grrrrr...

*waiting for the days when programming languages will get the jist of what you're trying to say, and correct the code for you*
0
 
gravityCommented:
Yeah, I'm 18 and already my trumpet playing is beginning to lag, which is a shame considering it's my major instrument.
I recently applied to Uni for a music course, got an interview, and then a "Please piss off and die" letter, which was nice.
So, right now I'm going to continue working for this internet consultant in London... not exactly what I want to do, but hey, I need the money :)
0
 
dht1Author Commented:
Well, there's pleanty of money in IT... particularly if you're willing to work expat.

Music on the other hand, tends to pay very badly, but is fun...

I think I'd do the IT until I can afford to relax - but hey, that's me.
0
 
dht1Author Commented:
..and that feckin' parse error was for the lack of an inverted comma.

Why o why didn't they just put an additional bit of code into the compiler?
0
 
gravityCommented:
Basically, I'd really like to get into music, but I'm resigned to the sad fact that unless I'm pretty lucky, I'm not going to make any serious cash from it.

All I really want to do is get a job in a hotel or cafe where I can play cheesy jazz all day long.
0
 
gravityCommented:
Why not make the compiler better ?
Ever seen the design of a compiler ? It's a right bitch, it really is...

:)

0
 
dht1Author Commented:
I don't suppose you fancy giving me your email address such that I can email you my php3 for you to debug? :)
0
 
gravityCommented:
Not a chance, that is until I get my shirt :)

Anyway, gotta go eat, so keep groovy...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now