MySQL Forums
Forum List  »  PHP

error in my sql code
Posted by: Chanwit Ditchroen
Date: November 22, 2016 10:12PM

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);
?>

Options: ReplyQuote


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.