|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
MYSQL and query
i have this codes,
<? function db_connect() { $result = @mysql_pconnect("localhost", "khai", "password"); if (!$result) return false; if (!@mysql_select_db("khai")) return false; return $result; } function get_story_record($name1) { $conn = db_connect(); $nameID = $_GET['nameID']; $sql = "select * from writers WHERE nameID='$nameID'"; $result = mysql_query($sql); return(mysql_fetch_array($result)); } if (isset($writers)) $s = get_story_record($name1); echo "<tr>"; echo "<td>"; echo $s[name1]; echo "</td>"; echo "<td>"; echo $s[address]; echo "</td>"; echo "<td>"; echo $s[phone]; echo "</td>"; ?> i try to query from database..but there is nothing come out with this pages. |
|
#2
|
|||
|
|||
|
RE: MYSQL and query
Are you sure $writers is set? Is the query correct? Can you run the query directory against the data base?
Try changing: $result = mysql_query($sql); to: $result = mysql_query($sql) or die (mysql_error()); see what that shows, if anything... |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > MYSQL and query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|