Select Query

golfinggod

Hi can someone help me I want to select a certain value

mysql_connect("localhost", "", "") or
   					die("Could not connect: " . mysql_error());
					mysql_select_db("Flowers");

				$result = mysql_query("SELECT * FROM Flowers");

				while ($row = mysql_fetch_array($result, MYSQL_NUM)) {}

problem is I get this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\phpdev\private\testing.php on line 21

FirEwAteR

I do not see a reason for that MYSQL_NUM to be in there, if there is no reason take it out. Also change $resul to:

 $result = mysql_query("SELECT * FROM Flowers") or die(mysql_error());

wad

mysql_connect("dbhost", "dbusername", "dbpassword") or die(mysql_error());

mysql_select_db("dbname");
mysql_query("SELECT * FROM tablename");

while($row = mysql_fetch_array($result)) 
{
// Code
}

Are both the database and table named "Flower"?

If the database is name "Flower", but the table you want information pulled from is named "RosesAreRed", your mysql_query should say "SELECT * FROM RosesAreRed".

At least thats what I've gathered from your code.

ozzythaman

are you sure you have a table named Flowers AND a database named Flowers ? (they are NOT the same thing)

And are you sure you can log in without a username and password, i've never tried that..

and as previous reply said, put " or die(mysql_error()); " at the end of your mysql commands for easier debugging.. even after the select db query (but not after the fetch_array though)