PHP MySQL Return Results Issue

Posted on 16th Feb 2014 07:03 pm by admin

Hi guys,

I'm running joomla and made a module which is using ajax.
Basically i just have an html input textbox which i put a SQL statement in and then onblur it does the ajax script which returns the query results.

my sql query: "SELECT * FROM jos_users"

So, why does this:
Code: $result = mysql_query($query);

while ($row = mysql_fetch_array($result))
{
for ($x=1; $x<=count($row); $x++)
{
echo $row[$x]."<br />";
}
}

return this:
QuoteAdministrator
admin
your-email@email.com
21232f297a57a5a743894a0e4a801fc3
Super Administrator
0
1
25
2005-09-28 00:00:00
2009-10-14 13:11:45

while this:
Code: $result = mysql_query($query);

while ($row = mysql_fetch_array($result))
{
foreach ($row as $item)
{
echo $item."<br />";
}
}

return this:
Quote62
62
Administrator
Administrator
admin
admin

your-email@email.com
21232f297a57a5a743894a0e4a801fc3
21232f297a57a5a743894a0e4a801fc3
Super Administrator
Super Administrator
0
0
1
1
25
25
2005-09-28 00:00:00
2005-09-28 00:00:00
2009-10-14 13:11:45
2009-10-14 13:11:45

Thanks for any light you can shed.

Your Answer:

Login to answer

Other forums

First root of a number
Hi,

I can't find any function in php to give me the first root of a number.
Is there any

Time script, set to my time zone?
I am using this line to get the date and time

Code: $time = date(F." ".d.", &q

Passing PHP variables from one page to another
Hello-

I'm having trouble figuring out how to transport a variable from one php file to anoth

foreach loop, assistance request
I would like some guidance on the usage of foreach as I try to parse through a large database and wh

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

Variable Clash
In the past I've had variables clash. For example:

Code: <?php
$c = 5;
$ca

Online Event Ticket Sales
Has anyone wrote a script for online tickets sales?

I have been googling and found lots of th

multiple recipients + dbuser mail recall
Hello,

I am building a php login script.

When the user registers the script will send

How to limit the calls to an API
Hello, in my simple script I call an api which effectively involves me getting an xml file.

H

Getting Resource id #11 while trying to connect..
So i tried using "DEFINE" for the first time and im using the variables i defined to conne