Take A Look At This Query Real Quick

[computermax2328]

Take a look at this really quick. I am not getting anything out of this query. All I am doing is echoing description which is saved as a text in a phpmyadmin database. 'table' is coming from the URL. The variable $table is working in other queries.

 

   $table = $_GET['table'];
   $issues = "SELECT * FROM issues WHERE table='$table'";
   $isquery = mysql_query($issues, $connection);
   while ($row = mysql_fetch_array($isquery)) {
$desc = $row['description'];
   }

 

Thanks,

[Christian F.]

var_dump ($_GET);

 

Also, you really need to validate input and escape your output. This script is wide open for any kind of attack, SQL and HTML (XSS) injection both.

[Barand]

while ($row = mysql_fetch_array($isquery)) {

$desc = $row['description'];

}

 

that doesn't echo anything!

[computermax2328]

I echo it somewhere else.

 

echo $desc;

[nodirtyrockstar]

Your variable ('$table') is in quotes. I don't know if that matters since I can't see the rest of your script. Also, have you tried plugging the query directly into MySQL? It helps to start with a good query, and then troubleshoot the PHP.

Edited October 5, 2012 by nodirtyrockstar

[Jessica]

You should always post your actual code, and the entire relevant part. Of course we're going to point out you don't echo it. If you're echo'ing it outside of the loop, that's probably a big part of the problem.

[computermax2328]

Echoing inside the loop did not work. I echo outside the loop all the time and it works fine. I did the var_dumb and it can back null.

[Pikachu2000]

If it won't echo inside the loop, and it won't echo outside the loop, what would that tell you? Maybe that the query isn't returning any results?

[Christian F.]

...I did the var_dumb and it can back null.

That means you're not sending any data to the page in the URL, which causes PHP to query for data where table = ''.

[White_Lily]

If the table is being found in the database try echoing the rows:

 

$num = mysql_num_rows($issues);

echo $num;

 

If it echos nothing (not even a 0) then your query is probably the problem, if it echos '0' then its saying you have no entries, anything higher and the problem is elsewhere.

[computermax2328]

Alright, so I did some tests, var_dumb, num_rows and some !if statements, and I found that the query is what is incorrect. The $_GET variable is coming down, but the query is not working. It stops at the fetch_array.

[Christian F.]

Then this is solved, or..?

 

PS: It's "var_dump", not "b".

Edited October 5, 2012 by Christian F.

[computermax2328]

Yeah that was a typo. I solved it. I will mark it so