Jump to content
php.lv forumi

sql and php problēma


Puika1

Recommended Posts

Tātad,man ir sekojoša problēma,es iegāju www.manalapa.lv/forum/admin/ -MANAGEMENT-Custom Profile Fields un izveidoju jaunu lauku skyp niks

kad ievietoju savu profile fiels,viņš saglabāja datubāzē šādi

 

post-3594-1270029676,67_thumb.jpg

 

un izveidotais scripts izskatās šādi

 

<?

$result = mysql_query("SELECT * FROM ibf_pfields_content id='$id'");
while($r = mysql_fetch_array($result)) {	
 echo "skyp   ";
 echo $r['field_1'];
 echo "<br />";
}
?>

 

field_1 -ir datubāzes tabula,kur ir saglabājies skyp niks,bet sekojoša scripta problēma ir uzmetot šādu kļūdu

5y6yu17f3a64pv9x5am.jpg

a un 7 rinda ir šī

while($r = mysql_fetch_array($result)) 

 

Kas varētu būt par problēmu,un kā to izlabot?

Edited by Puika1
Link to comment
Share on other sites

ieliku šādi,bet nestrādā

where($r = mysql_fetch_array($result)) {

Kļūda

Parse error: syntax error, unexpected '{' in /home/radio/public_html/profils/4.php on line 7

 

ieliku,lai rāda kļūdas paziņojumu

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='1'' at line 1

Edited by Puika1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...