|
|
Posted by zek2005 on 02/10/07 14:48
On 10 feb, 15:09, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> zek2005 wrote:
> > Hi !!
>
> > Here is my problem. I can connect to data base through PHP (I receive
> > a "Connection OK" message)
>
> > <?php
> > function Conectarse()
> > {
> > if (!($link=mysql_connect("localhost","myuser","mypass")))
> > {
> > echo "Error to connect to DB.";
> > exit();
> > }
> > if (!mysql_select_db("users1",$link))
> > {
> > echo "Error selecting DB.";
> > exit();
> > }
> > return $link;
> > }
> > $link=Conectarse();
> > echo "Connection OK.<br>";
> > mysql_close($link); //
> > ?>
>
> > Then I try to execute a simple select * query, but I dont receive
> > results:
>
> > <?php
> > include("test.php"); // test.php refers to the file with the
> > function above
> > $link=Conectarse();
> > $result=mysql_query("select * from usuarios",$link);
> > while($row = mysql_fetch_array($result)) {
> > printf($row["Nombre"],$row["Apellido"]);
> > }
> > mysql_free_result($result);
> > mysql_close($link);
> > ?>
>
> > I also try other types of queries (update, as example), but it doesnt
> > work
>
> > Could it be a setting problem in my site?
>
> > Thanks in advance for your answer.
>
> > Ezequiel
>
> What does mysql_error() say about it?
>
> $result=mysql_query("select * from usuarios",$link);
> if (!$result)
> echo mysql_error();
> else
> while($row = mysql_fetch_array($result)) {
> ...
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstuck...@attglobal.net
> ==================- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -
mysql_error Returns the text of the error message from previous MySQL
operation
Any help?
REgards!
Ezequiel
Navigation:
[Reply to this message]
|