|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
mysql_fetch Problem
Hi!
Please can some one help me with this problem. I have fetches on an other site and that one is OK. Im new programming with PHP so I dont understand whats the problem. Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/p/pocketli/www/mobile/search/search.php on line 29 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/p/pocketli/www/mobile/search/search.php on line 45 Do you know whats wrang? Here is the new code: <? if ($searchstring) { if (!isset($start)) $start = 0; include("common.php"); $link = dbConnect(); $query ="SELECT kundid, icon, namn, typ FROM $table WHERE namn LIKE '%$searchstring%' LIMIT" . $start . ", 10"; $result = mysql_query($query); ?> <br> <table border="0" width="200" cellpadding="0" cellspacing="0"> <? while ($raden = mysql_fetch_row($result)){ echo "<tr bgcolor=#cccccc> <td width=20><img src='$raden[1]' width=20 height=20></td> <td><font face=verdana size=2> <b><a href=info.php?kundid=$raden[0]>$raden[2]</a></b></font></td> <td><font face=verdana size=1>$raden[3]</font></td> </tr> <tr height=2 bgcolor=#ffffff> <td colspan=3> </td> </tr>"; } ?> <tr><td colspan=3> <? $query = "SELECT count(*) as count FROM table"; $result = mysql_query($query); $row = mysql_fetch_array($result); $numrows = $row['count']; if($start > 0) echo "<a href="" . $PHP_SELF . "?start=" . ($start - 10) . "">Previous</a><BR>n"; if($numrows > ($start + 10)) echo "<a href="" . $PHP_SELF . "?start=" . ($start + 10) . "">Next</a><BR>n"; ?> </td></tr> </table> <? } mysql_close($link); ?> |
|
#2
|
|||
|
|||
|
RE: mysql_fetch Problem
The error is caused by something wrong with your SQL query.
try this $query ="SELECT * FROM $table WHERE namn LIKE '%$searchstring%' LIMIT $start , 10"; if thats still causing problems, use this $result = mysql_query($query) or die(mysql_error); |
|
#3
|
|||
|
|||
|
RE: mysql_fetch Problem
you should actually use
$result = mysql_query($query) or die(mysql_error()); instead of $result = mysql_query($query) or die(mysql_error); |
|
#4
|
|||
|
|||
|
RE: mysql_fetch Problem
Thanks! Now is the fetch Problem not a Problem any more.
But I still dont get any new rows when I click on the next link. Any suggestion. //Micke |
![]() |
| Viewing: Codewalkers Forums > PHP Related > PHP Coding > mysql_fetch Problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|