Fecth Array problem

steveoo · #1 (**permalink**) 03-06-05, 05:20

PHP Code:


			
$list_query = mysql_query("SELECT DISTINCT(`name`) FROM list WHERE approved = 'yes' ORDER BY name");

while($list_get = mysql_fetch_array($list_query))

{

$list_query_again = mysql_query("SELECT * FROM `list` WHERE name = '$list_get[name]' AND approved = 'yes'");

$list_get_again = mysql_fetch_array($list_query_again);

$report_query = mysql_query("SELECT * FROM `list` WHERE name = '$list_get[name]' AND approved = 'yes'");

$report_count = mysql_num_rows($report_query);

This is an extract from my code. When it echos the names, if it get to a name called "Gojita'Mu" with an apostrifie(?) in it, it causes an error. Is their any way of solving this? I've tried to rearrange " to ' and vice versa, but I got nothing.

Edit, my cpanel info says im on version 4.0.23-standard mysql

r937 · #2 (**permalink**) 03-06-05, 06:51

you would need to replace the single apostrophe with two of them in a row, as in ...

Code:

 ... where name = 'Gojita''Mu'

however, by doing a query inside a loop, you are severely crippling your application

what is this piece of code attempting to do?

it looks like you're just looping through the entire list table

steveoo · #3 (**permalink**) 03-06-05, 07:05

It's just selecting some "reports" in a table. Each report has a name date etc and weather or not if its been approved. Because its in one table many reports could be the same name, so I made it select only 1 and echo the name.

steveoo · #4 (**permalink**) 03-06-05, 07:31

Oh I'm also doing the while loop because I've only selected the name, and I'm just wondering if I can put a "*" their now. I'll test it.

steveoo · #5 (**permalink**) 03-06-05, 07:50

Hum nope. I'm, totaly confused now.

Is they another way to stop this error without editing the myql database andjust the code? When I edit the database it edits the name and shows two, where as id rather have 1 of those ' xP

r937 · #6 (**permalink**) 03-06-05, 07:53

no, what i meant in post #2 was that you need to replace one quote with two in your SQL, not in the database

you specify the value here --

... WHERE name = '$list_get[name]'

you have to do something in php so that when you substitute the actual value of $list_get[name] into the SQL, each single quote inside the name is replaced by two of them

how you do this in php is another matter, i don't do php so i can't help you there

steveoo · #7 (**permalink**) 03-06-05, 09:51

Thank you for your help, it's working. :]

Internet Services

Web Development

Digital Marketing

Consumer Tech