getting data from mySQL

[fortytwo]

Hi All,

I am using the following code to pull data from a mySQL database:

[tt]$q = "SELECT * FROM $table";
$result = (Query $dbh_mysql $q || die "Select failed \n
($Mysql::db_errstr)\n"

print &quot;$result<br>\n&quot;;[/tt]

and it outputs the string:

Mysql::Statement=HASH(0x101826a4)

to the screen (web page). But this is not the information in the database. I want to get some specific information! How do I get this? I really want to select specific information like this:

[tt]$q = &quot;SELECT * FROM $table WHERE (uniq_id = $id)&quot;;
$result = (Query $dbh_mysql $q || die &quot;Select failed \n
($Mysql::db_errstr)\n&quot;
$num_rows=$result->uniq_id; #Script seems to crash here
print &quot;$num_rows<br>\n&quot;;[/tt]

but the script seems to crash at the point indicated. I know the database is there and I can insert data into it so connection is fine but does anyone know how I can get data out of it!

Thanks.




fortytwo
will@hellacool.co.uk

http://www.hellacool.co.uk

 

[MikeLacey]

Hi Will,

Thought for a minute you were using the DBI there, but I don't think so... How are you getting access to MySql then?

Mike
michael.j.lacey@ntlworld.com

http://www.cargill.com/

 

[fortytwo]

Hi Mike, I am using

[tt]use mySQL;[/tt]

as I don't think there are any other modules installed on the server. I have actually sorted *that* problem out by using the following line:

[tt]%hash = $result->fetchhash;[/tt]

but would you believe it, I have another one I can get the hash using the line:

[tt]$q = &quot;SELECT * FROM $table&quot;;[/tt]

but the line:

[tt]$q = &quot;SELECT * FROM $table WHERE (uniq_id = $id)&quot;;[/tt]

throws back a premature end of script header error. I really need to select individual records and not the whole lot as the first select statement does. $id contains the correct information.



fortytwo
will@hellacool.co.uk

http://www.hellacool.co.uk

 

[fortytwo]

It works!

$q = &quot;SELECT * FROM $table WHERE (uniq_id = \'$id\')&quot;;

Thanks Mike.

fortytwo
will@hellacool.co.uk

http://www.hellacool.co.uk

 

[MikeLacey]

<grin> my pleasure Will, not that I actually *did* anything...

Mike
michael.j.lacey@ntlworld.com

http://www.cargill.com/

 

[fortytwo]

Fine:

[tt]$post =~ s/Thanks Mike//g;[/tt]



fortytwo
will@hellacool.co.uk

http://www.hellacool.co.uk

 

[MikeLacey]

LOL

Mike
michael.j.lacey@ntlworld.com

http://www.cargill.com/