Help needed with script

[steve.burgess]

I am quite new to all this and have stumbled at the first gate.

Can anyone tell me what is wrong with this?

<?php

$connection =
mysql_connect("domain","databaseusername","databas epassword");

$sql = 'SELECT * ';
$sql .= 'FROM `PageElements` ';
$sql .= 'WHERE pageid = 1 LIMIT 0, 30';

$result=mysql_query($sql,$connection);

while ($row = mysql_fetch_row($result)) * error message refers to this
line
{
for ($i=0; $i<mysql_num_fields($result); $i++)
echo $row[$i] . " ";

echo "\n";

}
mysql_close($connection);
?>

I am getting the following error message:

Warning: Supplied argument is not a valid MySQL result resource in
/home/nprie/public_html/index2.php on line 26 (i have put an asterisk
next to line 26 above) as above script is a fragment of a php file.

Cheers.

[Derek Scales]

Have you tried including a

mysql_select_db(...);

after the call to mysql_connect(...); Its the mistake that I always make.

Derek

st***********@boston-spa.org.uk wrote:

I am quite new to all this and have stumbled at the first gate.

Can anyone tell me what is wrong with this?

<?php

$connection =
mysql_connect("domain","databaseusername","databas epassword");

$sql = 'SELECT * ';
$sql .= 'FROM `PageElements` ';
$sql .= 'WHERE pageid = 1 LIMIT 0, 30';

$result=mysql_query($sql,$connection);

while ($row = mysql_fetch_row($result)) * error message refers to this
line
{
for ($i=0; $i<mysql_num_fields($result); $i++)
echo $row[$i] . " ";

echo "\n";

}
mysql_close($connection);
?>

I am getting the following error message:

Warning: Supplied argument is not a valid MySQL result resource in
/home/nprie/public_html/index2.php on line 26 (i have put an asterisk
next to line 26 above) as above script is a fragment of a php file.

Cheers.

[micha]

mysql_select_db('DB_NAME', $connection) between connecting to mysql and
your 1st query

micha

[steve.burgess]

Many thanks - that solved the problem.

Cheers