[SOLVED] connecting to mySQL and executing querys

[simonpatp]

Hi, I am having trouble with mysql_query, it doesn't return a MySQL Result resource, Here is my code:

$conne = mysql_connect("dbhost", "username", "MYPASS", "DB");
$res = mysql_query("SELECT * FROM mems_users;", $conne);
while ($newArray = mysql_fetch_array($res)) //generated warning: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource...
{
print_r($newArray);
}
echo mysql_num_rows($res);//also generated warning

mysql_close($conne);

[dropfaith]

???i use something along these lines conf is just my user details

<?php
// Make a MySQL Connection
include("../template/conf.php");
// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
$result = mysql_query("SELECT * FROM Movies");
$num_rows = mysql_num_rows($result);
// Display the results
echo "There are Currently ($num_rows) Movie Reviews";
?>

[rhodesa]

also, instead of

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

use

$result = mysql_query("SELECT * FROM Movies") or die("Query failed: ".mysql_error());

...that will give more info on what is going wrong

[.josh]

As far as what your actual problem is: you're trying to add your db argument to your mysql_connect.  That's not where it goes.  You need to select it with mysql_select_db.  Look at dropfaith's example.