PHP mysql_num_rows die error

Question

I want to create one page, where users add their informations.. I allready have that page created, but my real problem its down code..

I have some kind of problem, with that part of code:

<?php
//Connect to DB
$db = mysql_connect("localhost","USER","PASS") or die("Database Error");
mysql_select_db("DB",$db);

//Get ID from request
$idstire = isset($_GET['idstire']) ? (int)$_GET['idstire'] : 0;

//Check id is valid
if($idstire > 0)
{
//Query the DB
$resource = mysql_query("SELECT * FROM stiri2 WHERE idstire = " . $idstire);
if($resource === false)
{
    die("Eroare la conectarea cu baza de date");
}

if(mysql_num_rows($resource) == 0)
{
    die("Se pare ca stirea nu mai exista, sau a fost stearsa. <a     href='http://www.wanted-web.ro'>ACASA</a>");
}

$user = mysql_fetch_assoc($resource);

echo "
<div class='main-article-content'>
<h2 class='article-title'>asd</h2>

<div class='article-photo'>
<img src='" . $user['poza'] . "' class='setborder' alt='' />
</div>

<div class='article-controls'>

<div class='date'>
<div class='calendar-date'>" . $user['data'] . "</div>

                            </div>

<div class='right-side'>
<div class='colored'>
<a href='' class='icon-link'><span class='icon-text'></span>Printeaza articol</a>
<a href='#' class='icon-link'><span class='icon-text'></span>Trimite prietenilor</a>
                                </div>

                                <div>
<a href='#' class='icon-link'><span class='icon-text'></span>de Cristian Cosmin D.</a>
<a href='#' class='icon-link'><span class='icon-text'></span>39 comentarii</a>
                                </div>
                            </div>

<div class='clear-float'></div>


                        </div>


<div class='shortcode-content'>
<p>" . $user['nume'] . " , " . $user['prenume'] . " , " . $user['varsta'] . " , " . $user['localitatea'] . "</p>
                        </div>
                    </div>


";
}

$query = "UPDATE stiri2 SET accesari = accesari + 1 WHERE idstire=\"" . $idstire . "\"";
$result = mysql_query($query) OR die(mysql_error());
?>

It's show me error from here:

if(mysql_num_rows($resource) == 0)
{
    die("Se pare ca stirea nu mai exista, sau a fost stearsa. <a     href='http://www.wanted-web.ro'>ACASA</a>");
}

I really dont understand why!?

Can someone explain me? Thank you!

Is this new code? If it is you might want to consider not using mysql_* functions as they are deprecated. Consider prepared statements instead, with PDO or MySQLi. — Benjamin Gruenbaum
– Benjamin Gruenbaum, Commented Aug 24, 2013 at 12:23
That error: boldSe pare ca stirea nu mai exista, sau a fost stearsa. <a href='wanted-web.ro'>ACASA</a>**bold** — Muzica Veche
– Muzica Veche, Commented Aug 24, 2013 at 12:25
table records are "id , nume , prenume , varsta , localitatea, numep, poza, data, accesari" . when i write details on form,they are added in database.. but in that page show me that error — Muzica Veche
– Muzica Veche, Commented Aug 24, 2013 at 12:27

bhawin · Accepted Answer · 2013-08-24 12:35:01Z

1

mysql_query should have the second parameter as the connection which is in your case $db

$resource = mysql_query("SELECT * FROM stiri2 WHERE idstire = " . $idstire,$db);

if this also not works then use mysql_error to know the exact error

$row=mysql_num_rows($resource);
if($row)
{

}
else
{
    mysql_error();
}

this will show you if there is problwm in mysql_num_rows

answered Aug 24, 2013 at 12:35

bhawin

2851 gold badge6 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Muzica Veche Over a year ago

i changed with your code, but now not show me informations from database.. Not show any error, but not show informations added.. I hope to understand what i say

Ignacio Vazquez-Abrams Over a year ago

@MuzicaVeche: You do understand that there is no information to show, right?

Muzica Veche Over a year ago

now i see the error.. i try to resolve that.. ty a lot brothers for help me.

Reflic · Accepted Answer · 2013-08-24 12:24:54Z

1

Well the problem is, that your SQL Statement does not have any results.

Please check if your database contains some rows for this idstire.

answered Aug 24, 2013 at 12:24

Reflic

1,42115 silver badges27 bronze badges

4 Comments

Muzica Veche Over a year ago

idstire row exist , and informations are added succesfully .. but still show me the error on page

Reflic Over a year ago

Try to execute the SQL Statement directly in PHPMyAdmin to test it.

Muzica Veche Over a year ago

its show me that:

ERROR: Unknown Punctuation String @ 3 STR: // SQL:   //Get ID from request $idstire = isset($_GET['idstire']) ? (int)$_GET['idstire'] : 0;

Reflic Over a year ago

Paste this "SELECT * FROM stiri2 WHERE idstire = X" in to PMA and replace X with the idstire you normally use for test purpose.

rakeshjain · Accepted Answer · 2013-08-24 12:47:26Z

1

If $_GET['idstire'] is not set, you are setting $idstire to 0. Is there any entry in the table for idstire=0?

You can print your php query with $idstire replaced with its value. Take that query and execute in phpmyadmin to see the error. Also verify that row exists for the value of $idstire being used in the query.

answered Aug 24, 2013 at 12:47

rakeshjain

1,76111 silver badges11 bronze badges

1 Comment

Muzica Veche Over a year ago

i see my error was in form page.. i resolved that.. ty a lot brothers for opening my eyes !

Collectives™ on Stack Overflow

PHP mysql_num_rows die error

3 Answers 3

3 Comments

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related