MySQL data load
#1

Hi, I want to get car units from MySQL, but I get variable name, not variable value.
My table:
http://www.part.lt/img/24e29761f44e7...d4d4b11227.png

MySQL log:
Код:
:33:29] CMySQLHandler::Query(SELECT 483, 418, 422, 478, 543, 554, 600, 555, 587, 401, 410, 436, 491, 496, 526, 527, 533, 549, 439, 542, 518, 534, 535, 536, 575, 426, 445, 507, 516, 529, 547, 550, 551, 585, 404, 400, 458, 479, 489, 500 FROM carvienetai) - Successfully executed.

[17:33:29] >> mysql_store_result( Connection handle: 1 )

[17:33:29] CMySQLHandler::StoreResult() - Result was stored.

[17:33:29] >> mysql_fetch_row_format( Connection handle: 1 )

[17:33:29] CMySQLHandler::FetchRow() - Return: 483|418|422|478|543|554|600|555|587|401|410|436|491|496|526|527|533|549|439|542|518|534|535|536|575|426|445|507|516|529|547|550|551|585|404|400|458|479|489|500
Code:
Код:
	new savingstring[100];
	mysql_query("SELECT 483, 418, 422, 478, 543, 554, 600, 555, 587, 401, 410, 436, 491, 496, 526, 527, 533, 549, 439, 542, 518, 534, 535, 536, 575, 426, 445, 507, 516, 529, 547, 550, 551, 585, 404, 400, 458, 479, 489, 500 FROM carvienetai");
	mysql_store_result();

	if(mysql_fetch_row_format(savingstring))
	{
		sscanf(savingstring,"p<|>dddddddddddddddddddddddddddddddddddddddd",
		v[483],
		v[418],
		v[422],
		v[478],
		v[543],
		v[554],
		v[600],
		v[555],
		v[587],
		v[401],
		v[410],
		v[436],
		v[491],
		v[496],
		v[526],
		v[527],
		v[533],
		v[549],
		v[439],
		v[542],
		v[518],
		v[534],
		v[535],
		v[536],
		v[575],
		v[426],
		v[445],
		v[507],
		v[516],
		v[529],
		v[547],
		v[550],
		v[551],
		v[585],
		v[404],
		v[400],
		v[458],
		v[479],
		v[489],
        v[500]);
  	}
   	mysql_free_result();
Reply
#2

Try to rename table name by insert some char in the front.

Ex. c483 c418 c422 .......
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)