Okay so I got this sample link (not working):

http://www.acosta.com/joo.asp?id=654


Now suppose I have a PHP file that would use MySql in order to get all values in the row where id 654 is found.

Here's a sample DB:

Table: demnyc

______________________________________
| id | Name | Age | Email |
*----------------------------------------------------*
| 1 | Albert | 17 | no email |
*----------------------------------------------------*
| 2 | YaPow | 888 | no email |
|______________________________________|

The result should be "Albert"

Here's a portion of the current code to display the desired value:




The current result is: Resource id # 4

Can someone tell me please what I'm missing?

 

 

 

Reply

When you use mysql_query, it doesn't return a string/number, but rather a resource. For example, if you select more rows, how would you display them? That's why mysql_result is used.

After selecting a row from the table (or rows), you will get $result. In order to use it, you must do this:



By doing this, $someVariable will be assigned the value from the first row of $result (0 is for the first row, 1 for the second etc). You can also add another parameter after the "0" which will indicate what column you want to use, if more have been selected.

Reply

Yes indeed, you get the resource from which you can pull the actual data.

Mysql_result() is fine function to use if you need to fetch only one row and value from it. However these cases are quite rare and for instance I can't remember ever using the basic function.

Instead use mysql_fetch_assoc() or mysql_fetch _row() which fetch one entire row from which you have access to all the values your query returned. The difference between these two is that mysql_fetch_assoc() gives you an associative array, for exmple $result['id'] would point to the id value which with mysql_fetch_row() it'd be $result[0] (presuming 'id' is mentioned first in the query).

There's also a third alternative mysql_fetch_object() which doesn't return an array but an object. Nice if you like to work with objects. (duh)


Under no circumstance use mysql_result() in a loop to get entire row. I've seen code like that and I nearly had a stroke.

 

 

 

Reply

Oh so would the syntax be like:

$result = mysql_query($query);

$name = mysql_fetch_row($result[0]);

Would this syntax be right?

Reply

No, because $result is not an array, it is a resource.

$name = mysql_fetch_row($result);

This, on the other hand, will work. After doing this, you will get $name - and that's an array. But, as Hercco said, you are better off with mysql_fetch_assoc(), because you will be able to use column names instead of numbers. (so that's $name["column"]).

Reply

How do I retrieve related data using Mysql/php on id query? If this make sense
PHP & MySQL: Displaying Content From A Given ID

I Have set up a video website whereby a user selects a video to play, but I have other videos which I want to display that are related but I am only getting the output for the selected video. I am new to this and the frustration is killing me trying to get this to work. Can someone tell me the best way to approach this.

Regds Wilburwt

-question by Wilburwt

Reply

How do I retrieve related data using Mysql/php on id query? If this make sense
PHP & MySQL: Displaying Content From A Given ID

I Have set up a video website whereby a user selects a video to play, but I have other videos which I want to display that are related but I am only getting the output for the selected video. I am new to this and the frustration is killing me trying to get this to work. Can someone tell me the best way to approach this.

Regds Wilburwt

-question by Wilburwt

Reply