MySQL Forums
Forum List  »  Newbie

Re: please please help me
Posted by: Claude Martin
Date: February 02, 2005 01:41AM

$result = @mysql_query('SELECT * FROM items WHERE cat LIKE "%glass%"');

replace with

$result = mysql_query('SELECT * FROM items WHERE cat LIKE "%glass%"') or die(mysql_error());

then the mysql error willl be displayed and you can fix it. maybe that table doesnt exist.

also use mysql_fetch_assoc not _array! its much faster and uses less memory.

mysql_select_db('hstles29_stlestatesale',$dbcnx);
once is enough. take out that line.

<?php echo($row['title']); ?>
could be replaced by
<?=$row['title']?>

http://animalliberation.tk http://veganismus.ch
http://maqi.de http://tierrechtskochbuch.de

Options: ReplyQuote


Subject
Written By
Posted
February 01, 2005 07:48PM
Re: please please help me
February 02, 2005 01:41AM
February 02, 2005 06:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.