For Programmers: Free Programming Magazines  


Home > Archive > PHP Language > September 2006 > allways 0 rows affected - php5 and mysql5









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author allways 0 rows affected - php5 and mysql5
vasilis

2006-09-12, 6:57 pm

Hi, i have problem with php and mysql, the problem is:
when i try to update the database from a internet explorer i don't have
problem with a code but i have the following message: 0 rows affected.
can any body help me?
the code is:


<?php
..
..
..
..

if(!get_magic_quotes_gpc())
{
Janwillem Borleffs

2006-09-13, 6:57 pm

vasilis wrote:
> Hi, i have problem with php and mysql, the problem is:
> when i try to update the database from a internet explorer i don't
> have problem with a code but i have the following message: 0 rows
> affected. can any body help me?
> the code is:
>

[...]
> $query='insert into dvd values (?,?,?,?,?,?)';
>


From http://www.php.net/manual/en/functi...ected-rows.php:

"The mysqli_affected_rows() function only works with queries which modify a
table. In order to return the number of rows from a SELECT query, use the
mysqli_num_rows() function instead."


JW


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com