If you do "SELECT LEFT(loc1,3) FROM openart_table" the column name in $row
is probably not "loc1". Try this: "SELECT LEFT(loc1,3) AS loc1 FROM
openart_table". Also, after the fetch you can do some debuggin thru this:

<?php
        $row = mysql_fetch_assoc($result); // change $result to your own
cursor variable
        print "<pre>"; print_r($row); print "</pre>";
?>

That prints out a list of all the keys and values of $row and tells you what
columns you're receiving (and their names).

Jos

-----Original Message-----
From: Sugimoto [mailto:[EMAIL PROTECTED]
Sent: 19 April 2005 07:58
To: php-db@lists.php.net
Subject: [PHP-DB] PHP&MySQL left/substring etc problem


Hello,
I need your help about PHP (ver 4.3.1) and MySQL (ver 3.23) database.
I am struggling to customise a database (using left command etc), and am
stuck now.
Please have a brief look at my scripts below.

What I do like to do is to get first 3 letters from "loc1" column from
openart_table (MySQL).
And show the data in the follwoing part...
  <td><? echo $row["loc1"]; ?><br></td>

but also I would like to make hyperlinks to jpg files to images/"the first 3
letters from loc1".jpg
So it will be something like this...
  <td>
  <a href="/image/<? echo $row["loc1"]; ?>.jpg"><? echo $row["loc1"];
?></a><br>
  </td>

But when I tried, "select left (loc1,3) from openart_table where......"
doesnt work properly.
I do not want to destroy anything for the rest of the table.
I need all data from "tit1", "pub1", "id1", and "ref1" in each column.

Could you help me, please?

---------------------------------------------PHP script from here
<html>
<body>
<table border="1" bordercolor="black" cellspacing="0" align="center"
BGCOLOR="#CCFFFF" width="900">
<tr bgcolor="#ffcc66">
<td align="center"><b>ID No</b><br></td>
<td align="center" BGCOLOR="#CC3366"><b>Book Title</b><br></td>
<td align="center"><b>Publisher</b><br></td>
<td align="center"><b>ID</b><br></td>
<td align="center"><b>Reference</b><br></td>
<td align="center" width="10%"><b>Location</b><br></td>
</tr>

<?
mysql_connect(localhost,root,cheers);
mysql_select_db(openart);
if($tit == "" &&
   $res == "" &&
   $pub == "" &&
   $date == "" &&
   $id == "" &&
   $ref == "" &&
   $loc == "" &&
   $type == "" &&
   $vol == "" &&
   $fre == "" &&
   $note == "")
{
 echo 'Type something';
}

elseif($tit == "%" || $res == "%" || $pub == "%" || $date == "%" || $id ==
"%" ||
       $ref == "%" || $loc == "%" || $type == "%" || $vol == "%" || $fre ==
"%" || $note == "%"){
 echo 'Not Valid';
}

else{
 if($tit == ""){
    $tit = '%';
 }
 if($res == ""){
    $res = '%';
 }
 if($pub == ""){
    $pub = '%';
 }
 if($date == ""){
   $date = '%';
 }
 if($id == ""){
   $id = '%';
 }
 if($ref == ""){
    $ref = '%';
 }
 if($loc == ""){
    $loc = '%';
 }
 if($type == ""){
    $type = '%';
 }
 if($vol == ""){
    $vol = '%';
 }
 if($fre == ""){
    $fre = '%';
 }
 if($note == ""){
    $note = '%';
 }
$result = mysql_query("select * from openart_table
 where tit1   like '%$tit%'
   and res1   like '%$res%'
   and pub1  like '%$pub%'
   and date1  like '%$date%'
   and id1   like '%$id%'
   and ref1  like '%$ref%'
   and loc1  like '%$loc%'
   and type1   like '%$type%'
   and vol1  like '%$vol%'
   and fre1  like '%$fre%'
   and note1   like '%$note%' order by tit1");

$rows = mysql_num_rows($result);
 echo $rows,"Records Found <p>";
 while($row = mysql_fetch_array($result)){
  ?>
  <tr>
  <td><a href = "openart_detail.php ?iden=<? echo $row["openart_id"] ?>"><?
echo $row["openart_id"]; ?></a><br></td>
  <td><? echo $row["tit1"]; ?><br></td>
  <td><? echo $row["pub1"]; ?><br></td>
  <td><? echo $row["id1"]; ?><br></td>
  <td><? echo $row["ref1"]; ?><br></td>
  <td><? echo $row["loc1"]; ?><br></td>
  </tr>
  <?
   }
}
?>
</table>
</body>
</html>

----------------------------------------------------end of script

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to