help!

[nightmareman]

<?php
$mysql_host = "***";
$mysql_database = "***";
$mysql_user = "***";
$mysql_password = "***";
mysql_connect($mysql_host,$mysql_user,$mysql_password);
mysql_select_db($mysql_database);
$query = "SELECT * FROM people coming";
$result = mysql_query($query);
while($w=mysql_fetch_array($result)) {
echo $w['Name'];
}

 ?>

this doesnt work--Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
y?

[cmps]

<?php
$mysql_host = "***";
$mysql_database = "***";
$mysql_user = "***";
$mysql_password = "***";
mysql_connect($mysql_host,$mysql_user,$mysql_password);
mysql_select_db($mysql_database);
$query = "SELECT * FROM people coming";
$result = mysql_query($query);
while($w=mysql_fetch_array($result)) {
echo $w['Name'];
}

 ?>

okay lets see ...
it's recommended that you don't insert spaces in the table names, but I think you can fix this by adding single quotation like this 'people coming', not sure. If this didn't fix the problem, then add this:
$result = mysql_query($query)** or die(mysql_error())**;
this will explane more what is your error :) good luck

[nightmareman]

still doesnt work :(

[pritaeas]

Use backticks:

$query = "SELECT * FROM `people coming`";

[cmps]

try
.... or die( mysql_error())
it will tell u the problem