Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

More easy stuff :-)

Posted on 2000-03-14
11
Medium Priority
?
260 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to dynamically set the form action using jQuery.
Suggested Courses

730 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