<?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?
<?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
still doesnt work :(
Use backticks:
$query = "SELECT * FROM `people coming`";
try
.... or die( mysql_error())
it will tell u the problem
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.