Retrieving data from mysql

mlsbraves

I want to retrieve my own data from my mySQL database. So lets say I have a database called test and my prefix is mv_. Lets call the table "one". Now mv_one has three rows in it, with id: 1, 2, and 3.

Now from a page on my site I want to call data from mv_one, row 1(id 1), what code do I need to use to retrieve this?

planetsim

I can see you dont know much in PHP/Mysql so ill be nice to you.

Try this.

mysql_connect("localhost","username","password")or die(mysql_error())
mysql_select_db("database_name");
$result=mysql-query("SELECT * FROM table_name");
while($r=mysql_fetch_array($result))
{
//echo your results.
}

Also read up it all in the PHP manual. A good Tut is at Spoono.com. Good easy to understand tutorials for the beginner.

mlsbraves

This line keeps giving me a an error:

while($r=mysql_fetch_array($result))

But I did go to the site and figured out how to connect to my database and have done that with no problem. But now I need to query my data from my database and I can't figure that part out.

My database name is movies and I have a table named m_1. I have 5 fields the first one being "ID" and its "auto_increment".
The other fields are img, spec, sum, and dl.

I have 4 rows on this table and there labeled ID: 1,2,3,4.

Now I want to display some of this data on my page. So lets say I need to get data from ID: "1"--> field: "img". How do I do that?

I'm sorry if some of this doesnt make since but I have tried to look this up and nothing is working for me. I think I kinda figure out the basics of mysql or at least what things are called, and I can connect to the database, but I need to query data from rows and fields in my table, and I don't know how.

Can someone please give me some help here.

DigitalExpl0it

while ($row = mysql_fetch_array($result)){
		$rs_fld1 = $row["row_name"];
echo "$rs_fld1 ";
}

cgraz

There is nothing wrong with planetsims code, and the only error you would get on that line (besides parse error, but there was no parse error in his code) is that it is not a valid mysql result resource. What you probably didn't do is replace table_name with the name of your table (which you said was movies).

I'll show you how to do what you want and explain how it works, but don't expect people to write code for you. You should figure out how to adapt the code to your needs as it's all rather straight forward.

Now I want to display some of this data on my page. So lets say I need to get data from ID: "1"--> field: "img". How do I do that?

$query = mysql_query("SELECT img FROM movies WHERE ID='1'");

// now to display the results of that
$a_row = mysql_fetch_array($query);

// that just created an array called $a_row and you can call the fields by $a_row['field_name'] 
// You have to plug in YOUR FIELD NAME, don't use field_name

// now to display it
echo $a_row["img"];

// notice how i plugged in the field name

To select all the fields in your database

SELECT * FROM your_table (replace your_table with the name of your table)

If you watn to select all the fields where id = 1

SELECT * FROM your_table WHERE id=1

(make sure you use proper caps. id and ID and Id are all different).

Now if you have 4 rows, and want to display all 4 rows, you'd use a while statement

I have 4 rows on this table and there labeled ID: 1,2,3,4.

You'd normaly only use the id to in the WHERE part of your select, you'd want to call each particular field as I did above using it's field_name

$query = mysql_query("SELECT * FROM your_table"); // replace your_table with the name of your table

while ($a_row=mysql_fetch_array($query)) {

echo $a_row["image"] . "<br>\n";
echo $a_row["spec"] . "<br>\n";
echo $a_row["sum"] . "<br>\n";
echo $a_row["dl"] . "<br><br>\n";

// end while loop
}

That's really all there is to it. The above code would display the values for each of those fields for each row in your table. so if you have 4 rows, it would display the value for image, spec, sum, dl, then repeat that 3 more times. It keeps going until there are no more rows in your database.

Search for PHP/MySQL tutorials. If you still can't find any, post back and we can give you some good ones, but there are literally thousands out there. For more on the SELECT statement, SELECT()

Cgraz

mlsbraves

Thank you so much. I got it working fine now. Now all I have to do is make a script that edits these fields and I'll be done. I'm sure I'll run into problems though...

Merry Christmas