error in my sql code
could any one help me fix error that occur around my while loop
<?
$link = mysql_connect("localhost","root","1234");
mysql_query("Use visitor;");
$sql = "select * from visiting;";
$result = mysql_query($sql)
while ($dbarr = mysql_fetch_array($result))
{$dbarr[visitor_number];
}
$pgcount = $pgcount+1;
$pgcount = "00000".$pgcount;
$pgcount = substr($pgcount -6);
echo "<p><left><b> you are vsitor number $pgcount";
$sql = "insert into visiting (visitor_number, date) values ('$pgcount', cast(now() as date);";
$result = mysql_query($sql);
?>
Subject
Written By
Posted
error in my sql code
November 22, 2016 10:12PM
November 23, 2016 12:13AM
November 27, 2016 02:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.