I gang

PHP/ MYSQL Scripts

I have a couple of things, php, that I need to work out.

1.

I have a php script that gives me the following output:

________________________________________________________________________

&title=Title;1;2;3;4;5;6;7;8;9;10;

&data1=;[url removed, login to view]; [url removed, login to view]; [url removed, login to view]; [url removed, login to view]; [url removed, login to view]; [url removed, login to view]; [url removed, login to view]; [url removed, login to view]; [url removed, login to view]; [url removed, login to view];

________________________________________________________________________

Which is almost what I need I am using this:

// Print Title

print "&title=Title;1;2;3;4;5;n";

print "";

print "&data1=;";

// Print Result

$i=value;

while ($row = mysql_fetch_object($result)) {

print "$row->value;rn";

$i++;

}

________________________________________________________________

The first question is, is there a way for the &title=Title; to reflect automatically the number of "value" results without hardcoding the column title? And the second question is.. the $row->value; gives me 10,9,8,7,6,5,4,3,2,1 because I am using the DESC function in the mysql query to get to the end of the database. Is there a way to reverse the output so that I get 1,2,3,4,5,6,7,8,9,10 where 10 represents the last row in the database?

______________________________________________________________________________________________________________________________________________________________

The second part of the question has to do with a mysql query. When I use phpmyadmin to test the query all is well but the create php doesn't seem to work right. The query that I'm using in phpmyadmin is

SET @runningTotal :=0;

SELECT value, @runningTotal := value + @runningTotal AS newvalue

FROM orders_total

WHERE class = 'ot_total'

LIMIT 0 , 30

How do I write that in php?

______________________________________________________________________________

Ok that's all for now. If you are available please let me know how much it would cost to answer those questions and I'll pay right away through GAF.

Sincerely

Daniel M. May

Færdigheder: PHP

Se mere: pay php, mysql questions, create database using php, second scripts, php end script, php create function, get php, rn, php test, mysql, mysql test, mysql query, gaf, desc, daniel, create php, c mysql, amp php mysql, almost, php script last, output php, write mysql, mysql amp, php using, using scripts

Om arbejdsgiveren:
( 1 bedømmelse ) Afghan, Afghanistan

Projekt-ID: #15504

Tildelt til:

bearcoder

Hi, i'm experienced php/mysql coder and I can give you the answers RIGHT NOW by $30 which is a MINIMAL ALLOWED BID so why wait? ;-) thanks

$30 USD in 0 dage
(3 bedømmelser)
3.2

7 freelancere byder i gennemsnit $35 for dette job

mistersoft

Can answer to all questions. Thanks.

$50 USD in 0 dage
(385 bedømmelser)
7.5
pradeepksingh

Please See PMB.

$30 USD på 1 dag
(5 bedømmelser)
6.0
xhenxhe

Daniel, There are multiple ways to answer your questions, provided I understand your questions correctly. If you just want a count of the values returned from your query, you can get this by running the mysql_num_ro Mere

$30 USD in 0 dage
(8 bedømmelser)
3.8
arcmax

can answer them right now .. thanks apuva m

$40 USD på 1 dag
(0 bedømmelser)
3.0
jarmaug

please look at pm

$30 USD in 0 dage
(0 bedømmelser)
0.0
jhilldesigns

Easy answers - the answer to your first is "ORDER BY ASC" instead of "DESC" - I can tell you more soon...PM me

$35 USD in 3 dage
(0 bedømmelser)
0.0