im trying to display the sql table but i get these warnings please help im sorta on a deadline :o :o :o
and how do you tell it to pull from table
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/u160665993/public_html/argylewallet/testpanel.php on line 485
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/u160665993/public_html/argylewallet/testpanel.php on line 486
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/u160665993/public_html/argylewallet/testpanel.php on line 487
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/u160665993/public_html/argylewallet/testpanel.php on line 488
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/u160665993/public_html/argylewallet/testpanel.php on line 489
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/u160665993/public_html/argylewallet/testpanel.php on line 490
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/u160665993/public_html/argylewallet/testpanel.php on line 491
[php]<?php
mysql_connect(“sql server”,“u160665993_adds”,“addsadds”) or die(mysql_error());
mysql_select_db(“u160665993_adds”);
$query=“SELECT * FROM data”;
$result=mysql_query($query);
$i=0;
while ($i < 1)
{
$companyname=mysql_result($result,$i,“companyname”);
$posteddate=mysql_result($result,$i,“posteddate”);
$phone=mysql_result($result,$i,“phone”);
$web=mysql_result($result,$i,“web”);
$expirydate=mysql_result($result,$i,“expirydate”);
$categories=mysql_result($result,$i,“categories”);
$classified=mysql_result($result,$i,“classified”);
print("<em style=“font-weight: normal;”><span style=“font-size: 12pt;”>Categorie is $classified");
echo "<table border= “4” cellpadding=“2"cellspacing=“1” width=“100%”>”;
echo “
echo “
echo “
echo “
echo “
echo “
echo “
echo "
$i++;
}
?> [/php]