?
Solved

More easy stuff :-)

Posted on 2000-03-14
11
Medium Priority
?
265 Views
Last Modified: 2008-02-01
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
Comment
Question by:dht1
  • 6
  • 5
11 Comments
 
LVL 2

Accepted Solution

by:
gravity earned 300 total points
ID: 2617371
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
 

Author Comment

by:dht1
ID: 2617387
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
 
LVL 2

Expert Comment

by:gravity
ID: 2617420
Skills ? I'm actually a musicien more than programmer :)

(check out my profile !)
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:dht1
ID: 2617450
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
 
LVL 2

Expert Comment

by:gravity
ID: 2617474
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
 

Author Comment

by:dht1
ID: 2617485
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
 

Author Comment

by:dht1
ID: 2617498
..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
 
LVL 2

Expert Comment

by:gravity
ID: 2617499
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
 
LVL 2

Expert Comment

by:gravity
ID: 2617503
Why not make the compiler better ?
Ever seen the design of a compiler ? It's a right bitch, it really is...

:)

0
 

Author Comment

by:dht1
ID: 2617514
I don't suppose you fancy giving me your email address such that I can email you my php3 for you to debug? :)
0
 
LVL 2

Expert Comment

by:gravity
ID: 2617523
Not a chance, that is until I get my shirt :)

Anyway, gotta go eat, so keep groovy...
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The title says it all. Writing any type of PHP Application or API code that provides high throughput, while under a heavy load, seems to be an arcane art form (Black Magic). This article aims to provide some general guidelines for producing this typ…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.
Suggested Courses

616 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question