/    Sign up×
Community /Pin to ProfileBookmark

Error message needed!

I’ve got an enormeous query (3 tables simultaneously), and when echoing results this query is working fine but, depending on what the HELL is in database, sometimes everything between the {} of the while sentence doesn’t appear.
How can I generate an error message that gaves me some light about which data is causing me trouble?

[code=php]
$result = mysql_query(“SELECT * FROM DatosInmueble, Precios, Disponibilidad, Extras WHERE (DatosInmueble.Ref=’$Ref’ AND Precios.Ref=’$Ref’ AND Disponibilidad.Ref=’$Ref’ AND Extras.Ref=’$Ref’)”, $link);
echo mysql_errno().”: “.mysql_error().”<BR>”;//This gives me 0:
while($row = mysql_fetch_array($result)){
[/code]

to post a comment
PHP

1 Comments(s)

Copy linkTweet thisAlerts:
@AdamGundryJan 19.2004 — Your script may be timing out - try setting a longer time limit:

http://www.php.net/manual/en/function.set-time-limit.php

Adam
×

Success!

Help @Perfidus spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...