|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 26th, 2001, 04:59 AM
|
|||
|
|||
Perl query of a simple mysql databse
hello,
i need to query this table 'MODEMS' in my 'rota' database. the format for 'MODEMS' is thus: mysql> select * from MODEMS; +-----+--------------------+ |Date | Name | +-----+--------------------+ |01 | Darren Bristow | |02 | Darren Bristow | |03 | Darren Bristow | +---------------------------+ I need to read the value of 'Name' into a perl variable, for printing, if '$date_query' = n. Where n=todays date. thanks, Marcus 
|
|
#2
July 26th, 2001, 05:03 AM
|
||||
|
||||
|
Marcus,
Are you asking for a shell script to process output from the mysql command or a perl script to handle the database itself?
__________________
Robert.
|
|
#4
July 26th, 2001, 05:17 AM
|
||||
|
||||
|
In that case, do you know the DBI or are you after the whole thing?
Suggest you search this board, check out CPAN for the DBI module and mysql.com for docs. 
|
|
#5
July 26th, 2001, 05:21 AM
|
||||
|
||||
|
try:
Code:
my $qs = "SELECT Name FROM MODEMS WHERE Date = $perldatevariable";
my $doselect = $dbh->prepare($qs);
$doselect->execute;
my $srows = $doselect->rows;
if ($srows > 0) {
my ($name) = $doselect->fetchrow_array();
print $name . " is selected for " . $perldatevariable;
}
$doselect->finish;
|
|
#6
July 26th, 2001, 10:53 AM
|
|||
|
|||
|
Check out the documentation for DBI.pm.
Code:
$ perldoc DBI Most MySQL books have a starter section on using DBI as well. If you are looking for some more informative instruction on using DBI then I recommend Programming the Perl DBI by O'Reilly.
__________________
- dsb -  Perl Guy
|
|
| Viewing: Dev Shed Forums > Programming Languages > Perl Programming > Perl query of a simple mysql databse |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
