MySQL: Fields/Rows are empty
#6

Quote:
Originally Posted by AndreT
Посмотреть сообщение
Integers do not need to be enclosed in quotes. In fact, a query
SELECT gPavadinimas FROM gaujos WHERE gID = %d
is perfectly valid as well. You don't need to use single quotes unless you have a string or a word that will be handled specially (as a keyword) by MySQL.

zgintasz, run the same query in phpMyAdmin and see if it gives a valid result. Assuming it does, try using a different function for handling the loading of this string. As far as I know, you're selecting only one field, but then using a very comprehensive function to access it! There must be something simpler like mysql_fetch_row.
Then I assume strings needed to be enclosed
Reply


Messages In This Thread
MySQL: Fields/Rows are empty - by zgintasz - 12.05.2012, 11:11
Re: MySQL: Fields/Rows are empty - by zgintasz - 12.05.2012, 12:21
Re: MySQL: Fields/Rows are empty - by Pinguinn - 12.05.2012, 12:36
Re: MySQL: Fields/Rows are empty - by AndreT - 12.05.2012, 12:39
Re: MySQL: Fields/Rows are empty - by zgintasz - 12.05.2012, 12:55
Re: MySQL: Fields/Rows are empty - by Pinguinn - 12.05.2012, 14:15
Re: MySQL: Fields/Rows are empty - by AndreT - 12.05.2012, 15:11
Re: MySQL: Fields/Rows are empty - by Evoturk - 12.05.2012, 16:36

Forum Jump:


Users browsing this thread: 1 Guest(s)