Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote -2 down vote favorite

I am trying to pull out a row of data from MySQL and put it in an array and then reverse it before displaying the results and then if confirmed by the user it will post the reversed results back into mysql

I am using this code :

for($i=0;$i<6;$i++) {
// Make a MySQL Connection
$query = "SELECT * FROM databasedemo WHERE id='$i'"; 
$result = mysql_query($query)or die(mysql_error());
$row = mysql_fetch_array($result);
array_reverse($row,true);
echo $i."--"."A".$row['A']. " - ". "B".$row['B']. " - ". "C".$row['C']. " - ". "D".$row['D']. " - ". "E".$row['E'];
echo "<br>";
}

I am getting this error 

Warning: array_reverse() [function.array-reverse]: The argument should be an array in /home/nlp4mark/public_html/Databasedemo/main.php on line 37

Any help would be really appreciated. Thanks.

share|improve this question
 
if you var_dump($row) right after $row = mysql_fetch_array($result); what do you get? –  Book Of Zeus Sep 17 '11 at 2:46
 
does it work fine without array_reverse()? That error seems to sat that it isnt a true array. –  Wes Sep 17 '11 at 2:48
 
array_reverse((array)$row,true); –  steve Sep 17 '11 at 2:49
 
if I var($row) I get the following array(12) { [0]=> string(1) "1" ["id"]=> string(1) "1" [1]=> string(1) "1" ["A"]=> string(1) "1" [2]=> string(1) "2" ["B"]=> string(1) "2" [3]=> string(1) "3" ["C"]=> string(1) "3" [4]=> string(1) "4" ["D"]=> string(1) "4" [5]=> string(1) "5" ["E"]=> string(1) "5" } –  Sam Sep 17 '11 at 3:01
 
Using array_reverse() is completely worthless in this case when you are specifically displaying the output. –  Jason McCreary Sep 17 '11 at 3:06
show 4 more comments

3 Answers

up vote 2 down vote

You should only be executing this query once and then iterating through the results and displaying them:

$query = "SELECT * FROM databasedemo ORDER BY id DESC";
share|improve this answer
up vote 0 down vote 
$query = "SELECT * FROM databasedemo WHERE id='$i'";

That query will return a one record at the time. You are sending it 6 times with the for loop, that's why you get all the records, but you send 6 times a slighty different query.

try sending one query that return all the 6 records and then reverse it. It would be something like this

$sql = "SELECT * FROM databasedemo WHERE 1=1";
for($i=0;i<6;$i++){
    $sql .= " AND id=$i";
}
share|improve this answer
 
This would produce a query like SELECT * FROM databasedemo WHERE 1=1 AND id=0 AND id=1 AND id=2 AND id=3 AND id=4 AND id=5 - which will never find a result. Either try an OR in there, or else use IN. –  Surreal Dreams Sep 17 '11 at 5:58
 
Your answer doesn't make any sens to me ;) –  krtek Sep 17 '11 at 7:16
up vote 0 down vote

do like this 

select * from  (SELECT * from messages INNER JOIN logindata ON messages.author = logindata.id ORDER BY messages.mid DESC LIMIT 0,10) as t ORDER BY t.mid asc
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.