SQL / PHP Fetch

Anon

I'm disgustingly new to PHP, so this may come off as a stupid question, but I can't fine the answer. When you use msql_fetch_array to step through a variable (e.g. $result) that you've stored the results of a query in, it will eventually return 'false' when it hits the end of that array. Is there any way to reuse $result in another msql_fetch_array? If, in the same php page, you want to use the same query results that were initially stored in $results, but fetch_array has "used up" the current array, do you have to make the same query multiple times, and store it as different variables? ($results0, $results1...).
Anyone?
Bueller?
Bueller?

Gracias

Anon

umm....I think I know what you mean.
You mean you've run a while() loop and got some variables from the database, but you want to keep them instead of having them go away.
If this is the case, then u can just do something like this:
If your variables were $Row[Variable1], $Row[Variable2] and $Row[Variable3] then you can save them by renaming them
like
$Row[Variable1] = $Variable1;
$Row[Variable2] = $Variable2;
This will keep them for that loading of your script.
However sometimes I have problems with that so you can also do this
$Variable1 = "$Row[Variable1]";
It does the same thing...

Anon

Let me be more specific, maybe it'll help ungarble what I meant. Say you have a table of movie records, with TITLE and FORMAT being two of the fields. You want to query for those two fields, and display, grouped by format, rather like this:

DVD
-The Matrix
-Ghostbusters
VHS
-Howard the Duck
BETA
-Killer Klowns from Outer Space

Not a real example, mind you, but you get the point. The first way that occured to me to do it was something like

echo("DVD <ul>");
while($row=mysql_fetch_array($result)){
if($row["Format"]=="DVD"){
echo("<li> . $row[Title"] ."</li>");
}
echo("</ul>");
echo("VHS <ul>");
while($row=mysql_fetch_array($result)){
if($row["Format"]=="VHS"){
echo("<li> . $row[Title"] ."</li>");
}
echo("</ul>");

...etc. Problem is, that would only display the DVD titles, because the $result array is at the end. So, you could make it work by running the query multiple times for different variables [($result0=@("SELECT Title, Format FROM blah"); ($result1=@("SELECT Title, Format FROM blah"); ] and using a different variable for each while loop, but that seems excessively wasteful. So, is there a way to display results like that in the current framework, or would it have to be done in the SQL statement itself (or, am I just way off base here)? Thanks

Anon

sigh...that's what I get for typing on the fly and not paying attention. There was HTML fragments embedded in there- unordered list tags surrounding the while loop, and a list element tag as part of the echo inside the if statement. My mistake.

Anon

You may want to use something else entirely.
Try something on the order of this:

$rslt = sybase_query("web_get_city_avg $countselect",$CON);

$rslt_obj = sybase_fetch_object($rslt);

The "web_get_city_avg $countselect" is a sybase stored procedure with a CHAR variable ($city -> $countselect).

with the object result you can add anything you like as long as you have the variable names of the stored procedure.

For example in the above stored procedure I have city_online_total (which is a variable for the stored procedure, but an actual field name for the table) you can then use $rslt_obj thus:

print(" <TR valign=\"top\"><TD>");
print("$ " . number_format($rslt_obj->city_online_total,2));
print("</TD></TR>\n");

Hope this helps.

TroyB

Spelunker99

hmm...any suggestions for trying it in MySQL?...

devinemke

you need to use mysql_data_seek(). This function resets the internal pointer of a result set. After you loop thru once, call
mysql_data_seek ($result, 0) so you can loop thru again starting at the first record.

alfred_hulle

What you're looking for is

reset ($result);

After stepping through an array you will have reset the array pointer to the first element in that array in order to cycle through the array once again.