What is the difference between mysql_fetch_array and
mysql_fetch_object?
Answer Posted / abhay kumar
mysql_fetch_array display all matching record from table as
an array while mysql_fetch_object dispaly first matching
from table as ab object
Is This Answer Correct ? | 6 Yes | 9 No |
Post New Answer View All Answers
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
What is the full meaning of mysql?
Where is mysql password stored?
How can I insert images into a Mysql database?
How do I run mysql from command line?
Which statement is used to delete a table in MySQL.
How many ways to get the current time?
How to use triggers to track changes in mysql?
Can I install mysql on mac?
How many mysql connections can handle?
What is the difference between b-tree and hash indexes?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
What are date and time intervals?
What is the function of mysqldump?
Does mysql case matter?