[Resolved] PHP/MySQL problems

[Krista2882]

I'm very new to PHP and MySQL, and Im having a bit of trouble. right now with this code, I'm just trying to display rows of my database. here is the PHP code:


<?php

$hostname = "localhost";
$database = "yourLastName_cust";
$username = "root";
$password = "password";
$dbconnect = mysql_connect($hostname, $username, $password);
mysql_select_db($database, $dbconnect);

$printg = mysql_query("SELECT * FROM project1 WHERE totalSpent > 100");
echo $printg;


?>

when I run it, in the browser, this message is displayed: Resource id #3
Anyone have any idea what that is? and how I can print the rows that I am requesting from the table?

Thanks for your help!!

[tomhath]

Looks good. The query probably worked.

Now you have to fetch the rows that you selected. Take a look at the examples here:

http://www.phpbuilder.com/manual/function.mysql-fetch-array.php

[Krista2882]

thanks for your help!

this is what I addded to the code:

$printg = mysql_query("SELECT * FROM project1 WHERE totalSpent > 100");
while($row = mysql_fetch_array($printg)){
echo $row;
}

and as the output, I get: ArrayArray

any ideas?

Edit:
nevermind, I got it!
thanks for your help!🙂