Can I get Some Help

D-mac

Sigh...

This

<?
mysql_connect("localhost","blank","blank");
$query = mysql_query("SELECT * FROM phpbb_config");
while ($row = mysql_fetch_array($query)) {
$board_date = $row["board_startdate"];
echo $board_date;
}
?>

Results in

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/duanejr/public_html/files/number_retrrieve.php on line 4

Help?

Its a long story why im doing thes but I am...

any help is
AWSOME...
TIA

jpmoriarty

your query isnt returning any results.

dont you need a "mysql_select_db()" in there before your query too?

cgraz

just a suggestion: always use mysql_error() to troubleshoot mysql problems. If people did this and printed their query (if it was a string), these simple troubleshooting questions would be easily answered.

Cgraz

spcomputing_com

Before you start running mysql commands, you need to connect to the database.

you have specified a host, username and password, but have not selected a database.

this code will connect you up, then you can run your mysql commands:

$dbhost = 'localhost';
$dbuser = 'username';
$dbpass = 'password';
mysql_connect($dbhost, $dbuser, $dbpass);
$dbname = 'dbname';
mysql_select_db ($dbname);
// MySQL commands go here.

dbhost, which is localhost works on most servers, just change username, password and dbname.

hope this helps 🙂

jpmoriarty

well i agree sp, but it's a bit of a redundant post given as the original poster does a db connection (mysql_connect("localhost","blank","blank"); ) and i've suggested that he/she needs to select a database.

but your code is flawless 😉

D-mac

Thanks to all who have replyed Im a noob to this and it was a just jump right in and do it type thing for me 🙂

A good friend said to come here where all the top dogs hang out thats why Im here 🙂

Thanks again..

Oh yeha this is what I ponderd over

<?
mysql_connect("localhost","XXXXXX","XXXXXX");mysql_select_db("duanejr_bbforum");
$query = mysql_query("SELECT board_startdate FROM phpbb_config");
while ($row = mysql_fetch_array($query)) {
if (mysql_num_rows($query) != 1) { echo "no data in this table."; }
$board_date = $row["board_startdate"];
echo $board_date;
}
?>

seems to work but but its not finding what im looking for.. 🙁