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


Messages In This Thread
MySQL data load - by deimantas1 - 08.11.2013, 14:44
Re: MySQL data load - by MyLife - 08.11.2013, 19:58

Forum Jump:


Users browsing this thread: 1 Guest(s)