robertboyle

Yes, I have, it connects successfully, no query error, but returns 0 rows.

It's here: [a href=\"http://bluleb.com/dir/?lok\" target=\"_blank\"]http://bluleb.com/dir/?lok[/a] Try clicking on a link with no apostrophe, it displays results. Try clicking on a link with apostrophe: no results shown.

Hi, It doesn't seem to be working. Again, here's what I have: [code] $sec = "Répertoires d'objets multimédias"; mysql_query("SELECT * FROM dir WHERE sec=\"$sec\" ORDER BY st ASC",$db); [/code] The corresponding "sec" in the db is "Répertoires d'objets multimédias". Affected rows for this query=0. Works with other queries with no apostrophe. Thanks It's here: [a href=\"http://bluleb.com/dir/?lok\" target=\"_blank\"]http://bluleb.com/dir/?lok[/a] Try clicking on a link with no apostrophe, it displays results. Try clicking on a link with apostrophe: no results shown. It's here: [a href=\"http://bluleb.com/dir/?lok\" target=\"_blank\"]http://bluleb.com/dir/?lok[/a] Try clicking on a link with no apostrophe, it displays results. Try clicking on a link with apostrophe: no results shown.

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]You dont use database connection $db on the select query Also silly me you dont have to backslash with the double quotes in place.[/quote] Yes, I do, because there's an apostrophe: if i use: '$sec', MySQL will think the query is cut at the apostrophe in "..d'objets...". The database connection is fine, it works with other values. redarrow, where do i put the backslash? This is the query output: SELECT * FROM dir WHERE sec="Répertoires_d'objets_multimédias" ORDER BY st ASC It should be working, but it isn't. WHY? Thanks.

Hi, I have the following code: [code]$sec = "Répertoires d'objets multimédias"; mysql_query("SELECT * FROM dir WHERE sec=\"$sec\" ORDER BY st ASC",$db);  [/code] and it returns 0 rows. When I use another $sec value, one that doesn't contain an apostrophe ('), it returns normal rows. How can I fix that? Thanks. Robert ll

Hi, Imagine I have a photo/image and I want to know what color is attributed to a certain pixel. Is it possible to do that with PHP? I found this in the PHP manual: <?php $im = ImageCreateFromPng("rockym.png"); $rgb = ImageColorAt($im, 100, 100); $r = ($rgb >> 16) & 0xFF; $g = ($rgb >> 8) & 0xFF; $b = $rgb & 0xFF; ?> but apparently, it gives me three different colors. Plus, would it still work if $im points to an image file? Thanks.