[tirengarfio]

Hi,

im trying to write a code which writes and reads a string in a field of a table, but i get this error below at the line that starts with "$row = mysql_fet..."

Code:

 "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL 
result resource in /opt/lampp/htdocs/Sites/prueba.php on line 23"

This is the code:

PHP Code:

<?php



$nombre="Javier";



$nombre2;





if (!($link=mysql_connect("localhost","","")))

{

echo "Error conectando a la base de datos.";

exit();

}



mysql_db_query("ejemplo", "insert into clientes(nombre) values('$nombre')");



$result = mysql_db_query("ejemplo", "select * from clientes");



$row = mysql_fetch_array($result);



echo $row["nombre"];





?>

Anyone can help me?

Ciao

[Nico]

mysql_db_query() was deprecated a long... very long time ago.

Use mysql_query() and mysql_select_db() instead.

PHP Code:

<?php

$nombre="Javier";

$nombre2;


if (!$link = mysql_connect("localhost","",""))
{
    echo "Error conectando a la base de datos.";
    exit();
}

if (!mysql_select_db("ejemplo"))
{
    echo "Error conectando a la base de datos.";
    exit();
}

mysql_query("insert into clientes(nombre) values('$nombre')") OR die(mysql_error());

$result = mysql_query("select * from clientes") OR die(mysql_error());
$row = mysql_fetch_array($result);

echo $row["nombre"];

?>

www.php.net/mysql_select_db
www.php.net/mysql_query

[tirengarfio]

Thanks Nico,

your code gives this error:

Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /opt/lampp/htdocs/Sites/prueba.php on line 23

[ianbrind]

That is because there is no connection to the database.

[xEX3CUT1ONx]

Originally Posted by ianbrind

That is because there is no connection to the database.

I believe there is he has just taken out the username and password so we cannot see

[tirengarfio]

Originally Posted by ianbrind

That is because there is no connection to the database.

!?!...but, if i can't see the error message about the connection, why do you say that??

[job0107]

Nico's code works fine if you have
a database named "ejemplo"
with a table named "clientes"
that has a column named "nombre".

[tirengarfio]

Originally Posted by job0107

Nico's code works fine if you have
a database named "ejemplo"
with a table named "clientes"
that has a column named "nombre".

Hi,

thanks, i think your are wrong, don't you? :

Code:

mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| cdcol              | 
| ejemplo            | 
| mysql              | 
| phpmyadmin         | 
| prueba             | 
| test               | 
+--------------------+
7 rows in set (0.11 sec)

mysql> use ejemplo
Database changed
mysql> show tables;
+-------------------+
| Tables_in_ejemplo |
+-------------------+
| clientes          | 
+-------------------+
1 row in set (0.00 sec)

mysql> Describe clientes;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| nombre   | varchar(100) | YES  |     | NULL    |       | 
| telefono | varchar(100) | YES  |     | NULL    |       | 
+----------+--------------+------+-----+---------+-------+
2 rows in set (0.07 sec)

mysql>

[job0107]

Originally Posted by tirengarfio

Hi,

thanks, i think your are wrong, don't you? :

Code:

mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema | 
| cdcol              | 
| ejemplo            | 
| mysql              | 
| phpmyadmin         | 
| prueba             | 
| test               | 
+--------------------+
7 rows in set (0.11 sec)

mysql> use ejemplo
Database changed
mysql> show tables;
+-------------------+
| Tables_in_ejemplo |
+-------------------+
| clientes          | 
+-------------------+
1 row in set (0.00 sec)

mysql> Describe clientes;
+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| nombre   | varchar(100) | YES  |     | NULL    |       | 
| telefono | varchar(100) | YES  |     | NULL    |       | 
+----------+--------------+------+-----+---------+-------+
2 rows in set (0.07 sec)

mysql>

No, I am not wrong and neither is Nico.
You are doing something wrong some where.

[tirengarfio]

Originally Posted by job0107

You are doing something wrong some where.

Ok job0107, but... with the information i have posted (tables and code), is not enough to know Where is the error?